<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Pragmatic Works Blog

Your source for SQL Server and Business Intelligence expert insight and the latest Pragmatic Works' news.

Power BI Custom Visuals - Dot Plot by MAQ Software

Posted Aug 18, 2017 by Devin Knight

In this module,  you will learn how to use the Dot Plot Custom Visual by MAQ Software.  The Dot Plot is used to show distribution using dots among multiple categories or attributes.

Arrange, Act, Assert - The Strategy for BI and Data Warehouse Testing

Posted Aug 17, 2017 by Tim Moolic

Are you incorporating BI and data warehouse testing into your data world? If not, it’s time to give this more thought. The importance of testing your data warehouse and BI systems cannot be overlooked. Testing early in the process can save you time and effort, as well as allow you to make better business decisions.

SSIS for Beginners

Posted Aug 16, 2017 by Philip de la Cal

We understand that the world of data can seem daunting, especially when you're a n00b. For those of you that fall in that category, as a Product Engineer, I offer this advice: "All you need is dedication and the foresight to start small and slowly scale up. With this mindset, you'll achieve great things." 

In case you missed yesterday's Intro to SSIS webinar, or would simply like a refresher of some of the main topics covered, I invite you to continue reading this blog post.

Automate Your Documentation With DOC xPress

Posted Aug 14, 2017 by Philip de la Cal

Time is money. As a developer, I want to code as quickly as possible, and although I know the importance of documentation, it can be a painful chore. "It takes a village to manage a database" ...is NOT how the saying goes, but chances are, there will be times when you're not the only one parsing through your data and environments. Without good documentation, you're going to bog down your fellow programmers and DBAs, and this inefficiency could really cost you at a crucial time in development.

NH Sales Team Beach Party!

Posted Aug 14, 2017 by Pragmatic Works

The 2017 Pragmatic Works Sales Beach Party was back in full swing this year - literally. The New Hampshire weather cooperated with a beautiful 80-degree day at Hampton Beach. Parasailing, surf lessons, a mean Can Jam tournament (not to mention a few cocktails) gave the team a much-needed break and time to enjoy the short New England summer.  Around here we know all too well—don’t blink, we’ll be wearing flannel and watching the Patriots’ kickoff before you know it! 

Power BI Custom Visuals - Quadrant Chart

Posted Aug 10, 2017 by Devin Knight

In this module, you will learn how to use the Quadrant Chart Custom Visual.  The Quadrant Chart is used to show a distribution of data across separate quadrants.

Real-World Data Testing: Remediating Bad Data

Posted Aug 09, 2017 by Tim Moolic

 There's a lot of talk about the need for BI and data warehouse testing to identify and fix bad data out there. What is the real purpose of BI and data warehouse testing? The purpose of data testing is to identify defects, which will add the new challenge of remediating the error. Who in your organization should be responsible for this? 

Power BI - Problem, Design, Solution - Text Search Slicer

Posted Aug 08, 2017 by Mitchell Pearson


In this installment of the "Problem, Design, Solution" series, we are going to walk through the process of performing a text search using slicers in Power BI, simulating a “LIKE” type search. Please note that there is a video explaining the solution in-depth at the end of the blog under "Resources."

The Benefits of Data Lineage and Impact Analysis with DOC xPress

Posted Aug 07, 2017 by Philip de la Cal

Let's face it - data is the lifeblood of any company. And for SQL Developers and DBAs, knowing the relationships and origins of data can be the difference between meeting a deadline or not.

As a new Product Engineer at Pragmatic Works, I find that a common issue developers face is knowing what is going to break downstream upon making changes to their ecosystem,  like a package or table name, for example. Additionally, a common question may be, "How did my data get into this column?"

Power BI Custom Visuals - Beyondsoft Calendar

Posted Aug 03, 2017 by Devin Knight

In this module, you will learn how to use the Beyondsoft Calendar Custom Visual.  The Beyondsoft Calendar displays a single metric across a month calendar.

BI and Data Warehouse Testing Challenge: Time!

Posted Aug 01, 2017 by Tim Moolic

Bad data has become an epidemic across all industries in the world today. Bad data affects data quality and productivity, and also creates a lack of confidence that business owners have in their reports.

Subscribe to Blog Updates