<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.

9 Truths and a Lie for Our 9th Anniversary

Posted Jul 28, 2016 by Devon Stiles

Over the past 9 years, we’ve had some hilarious and odd occurrences happen in our office - some that are barely believable! In honor of our anniversary, we thought it’d be fun to share some of these stories in a round of 9 truths and a lie. Can you spot the lie in the following Pragmatic Works memories?

Power BI Custom Visuals - Chord

Posted Jul 28, 2016 by Devin Knight

In this module, you will learn how to use the Chord Power BI Custom Visual. Chord diagrams show directed relationships among a group of entities using colored lines (chords); this allows for an easy representation of correlating data. If you want to learn more about Power BI Custom Visuals, view my previous blog posts.

Next Generation Data Validation, Put an End to Your Bad Data Days

Posted Jul 22, 2016 by Tim Moolic

As the COO of a company, Tim understands the important role data plays in a business's success. Whether it's annual reports, forecasting sales or making important decisions for the business's future, Tim relies on data - data he knows is accurate because it's been tested and validated.

Pragmatic Works helps customers all over the world with their data-centric challenges. If it involves data, we’ve pretty much done it. One challenge our customers continue to see, and we experience ourselves, is the random and unexpected bad result. These are results that cause our business users and customers to question the validity of the reports we produce for them. Even with Master Data Management, Data Cleansing and products like DQS, companies continue to wrestle with bad data. But why?

Power BI Custom Visuals - Dot Plot

Posted Jul 21, 2016 by Devin Knight

In this module, you will learn how to use the Dot Plot Power BI Custom Visual. The Dot Plot is often used when visualizing a distribution of values or a count of an occurrence across different categorical data you may have. Watch this module to learn more! If you want to learn more about Power BI Custom Visuals, view my previous blog posts.

Power BI Custom Visuals - Enhanced Scatter

Posted Jul 13, 2016 by Devin Knight

In this module, you will learn how to use the Enhanced Scatter Power BI Custom Visual.  This new-and-improved scatter chart allows for more customization and better data representation over the standard scatter chart that is provided to you by default with Power BI. If you want to learn more about Power BI Custom Visuals, view my previous blog posts.

Power BI Custom Visuals - Histogram

Posted Jul 07, 2016 by Devin Knight

In this module, you will learn how to use the Histogram, a Power BI Custom Visual. A Histogram is a column chart which shows the distribution of occurrences divided into categories, called bins. This type of chart is useful for estimating density and discovering outliers.

Power BI - Checking Query Folding with View Native Query

Posted Jul 06, 2016 by Devin Knight

A really great feature that was silently added into June update of the Power BI Desktop is a feature called View Native Query. This feature is integrated into Power BI Query Editor and appears to give you the ability to see the queries that are running against your data source when Query Folding is taking place. I’ll get back to what View Native Query does in a moment, but first for those that are unfamiliar let’s talk a bit about what Query Folding is and why it’s important.

Power BI Role Level Security

Posted Jul 01, 2016 by Devin Knight

In the June update of the Power BI Desktop, there were some really cool features that were added. I’d encourage you to review the full Power BI blog to see all the June updates. My favorite of all these new features is Row Level Security (RLS) for Power BI. The Power BI team blog didn’t go into any great detail yet (I’d expect a follow up blog from them later), so I thought I may give you a little more context here.

Power BI Custom Visuals - KPI Indicator

Posted Jun 30, 2016 by Devin Knight

In my previous post, we explored the Radar Chart visual. In this module you will learn how to use the KPI Indicator (This is kind of like saying “ATM Machine” isn’t it?) Power BI comes standard with a KPI visual but the custom visual we will cover in this post shows a few more options than is available in the standard tool. Using the KPI Indicator allows you to not only visualize key performance indicators but also include a historical trend line or bar chart with it.

Microsoft is Taking Over July Free Training!

Posted Jun 29, 2016 by Liz Hamilton

We are really excited about our July webinar lineup. Several of the awesome folks at Microsoft have signed up to host some amazing sessions, you might even recognize some of the names as being past Pragmatic Works employees. The topics in July cover SQL Server 2016, Power BI and Azure. So if you ever wanted some behind the scenes information on these topics, check out our July webinars!

Subscribe to Blog Updates