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.

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...
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...
14 December
2016
Author: DevinKnight
DevinKnight

This Week in Data – Episode 16 (Top 5 Reasons You Need a Data Warehouse)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we discuss the importance of having a data warehouse. Are there really only 5 reasons you need a data warehouse? No, but in our latest episode, Adam and...
13 December
2016
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 29 – Dial Gauge)

In this module you will learn how to use the Dial Gauge Power BI Custom Visual.  While the usefulness of gauges on a dashboard is often debated, this module will show you how to configure one using Power BI. Module 29 – Dial Gauge Downloads Power BI Custom Visual – Dial Gauge Dataset – Sales...
07 December
2016
Author: DevinKnight
DevinKnight

This Week in Data – Episode 15 (Why People Are Flocking to SQL Server)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we discuss why companies are deciding to move to SQL Server. In our industry, we often hear people talking about being on or migrating to SQL Server, but a...
06 December
2016
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 28 – Sankey)

In this module you will learn how to use the Sankey Power BI Custom Visual.  The Sankey is a type of diagram that visualizes the flow of data between a source and destination. Module 28 – Sankey Downloads Power BI Custom Visual – Sankey Dataset – Moving Regions.xlsx Completed Example – Module...