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.

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...
16 January
2017
Author: JasonStrate

Monday Morning SQL Break – January 16, 2017

It’s Monday and time, finally, for a weekly blog and twitter round-up for last week.  It’s been a while since I’ve published this summary post, but hey that’s what life is for, getting in the way of things that you sometimes want to be doing.  If you haven’t already, follow me on twitter...
16 January
2017
Author: JasonStrate

Monday Morning SQL Break – January 16, 2017

It’s Monday and time, finally, for a weekly blog and twitter round-up for last week.  It’s been a while since I’ve published this summary post, but hey that’s what life is for, getting in the way of things that you sometimes want to be doing.  If you haven’t already, follow me on twitter...
13 January
2017
Author: Robert Cain

What’s New in SQL Server 2016 Reporting Services–Now live at Pluralsight

So you want to see what’s new in SQL Server 2016 Reporting Services? Well I’ve got just the thing for you. My 12th course just went live on Pluralsight, named appropriately “What’s New in SQL Server 2016 Reporting Services”. This course is designed specifically for those who are already familiar...
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...
03 January
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 32 – Percentile Chart)

In this module you will learn how to use the Percentile Chart Power BI Custom Visual.  The Percentile Chart is used to show a distribution of values over a range. This helps you answer questions like “What percentage of my customers bought 4 or more items”. Module 32 – Percentile...
29 December
2016
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 31 – Horizontal Funnel)

In this module you will learn how to use the Horizontal Funnel Power BI Custom Visual.  The Horizontal Funnel functions somewhat similar to the traditional funnel but it allows you to display a secondary measure and has a few more customizations than you would normally get. You’ll find that the...
21 December
2016
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 30 – Linear Gauge)

In this module you will learn how to use the Linear Gauge Power BI Custom Visual.  The Linear Gauge would often be used to visualize a KPI. It gives you the ability to compare an actual vs target as well as showing up to two trend lines. Module 30 – Linear Gauge Downloads Power BI Custom Visual...