Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

21 February
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 39 – Waffle Chart)

In this module you will learn how to use the Waffle Chart Power BI Custom Visual.  The Waffle Chart visual is most useful for presenting a percentage of data. This chart is a great option to choose over other visuals like Pie Charts, which are not great at showing proportions of data. Module 39 –...
14 February
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 38 – Mekko Chart)

In this module you will learn how to use the Mekko Chart Power BI Custom Visual.  The Mekko Chart visual is helpful when you need to analyze two different dimensions on a single chart. Module 38 – Mekko Chart Downloads Power BI Custom Visual – Mekko Chart Dataset – Country Sales.xlsx Completed...
08 February
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 37 – Gap Analysis)

In this module you will learn how to use the Gap Analysis Power BI Custom Visual.  The Gap Analysis visual is used to analyze the difference between two different groups of data you have.  For example, you might use it to analyze the gap between two answers people gave in survey response...
03 February
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 36 – Box and Whiskers (Brad))

In this module you will learn how to use the Box and Whiskers (Brad) Power BI Custom Visual.  This is the second of two Box and Whiskers visuals that we have covered (You can learn more about the first one here). The Box and Whiskers chart is used to show things like data outliers, clusters of...
03 February
2017
Author: BradleyBall

The High Availability Conversation Part 1: Introduction

Hello Dear Reader!  Twitter is a fantastic tool if you use SQL Server.  It is a great way to network, find presentations, interact with experts, and #SQLHelp offers some of the best technical forum conversation on the subject.  I was on Twitter and my friend Kenneth Fisher asked a question....
30 January
2017
Author: DustinRyan
DustinRyan

Another 5 Power BI Tips

If you’ve been at least paying attention to my blog a little bit, you’ve probably noticed I occasionally blog about Power BI. Part of the reason I blog so often about Power BI is because that’s the topic of a whole bunch of conversations I’m having with my customers. The other reason is that the...
24 January
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 35 – Box and Whiskers (Jan Pieter))

In this module you will learn how to use the Box and Whiskers (Jan Pieter) Power BI Custom Visual.  This is the first of two Box and Whiskers visuals that we will cover. The Box and Whiskers chart is used to show things like data outliers, clusters of data points and the volume of data between...
17 January
2017
Author: DevinKnight
DevinKnight

Power BI Subscriptions

Newly added to the Power BI Service is a much awaited feature called Power BI Subscriptions. If you’ve worked in Microsoft BI in the past this idea is likely familiar to you. This new feature shares some similarities to Subscriptions in Microsoft Reporting Services. The idea of subscriptions is...
17 January
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 34–Sankey with Labels)

In this module you will learn how to use the Sankey with Labels Power BI Custom Visual.  The Sankey with Labels is a type of diagram that visualizes the flow of data between a source and destination columns. This is visual is similar to the visual we showed in Module 28 but with a few key...
10 January
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 33–Sankey Bar Chart)

In this module you will learn how to use the Sankey Bar Chart Power BI Custom Visual.  The Sankey Bar Chart is used to show a flow of data between different different stages of a process. Module 33 – Sankey Bar Chart Downloads Power BI Custom Visual – Sankey Bar Chart Dataset – Sales...