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.

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...
30 November
2016
Author: DevinKnight
DevinKnight

This Week in Data – Episode 14 (Hacking Your Professional Development)

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 hacking your own professional development. Having a plan for your professional development is essential when tackling your career goals. You need...
29 November
2016
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 27 – Synoptic Panel)

In this module you will learn how to use the Synoptic Panel Power BI Custom Visual.  The Synoptic Panel is really one of the more impressive visuals available. This visual allows you to take an image and plot data on different regions that you define. Module 27 – Synoptic Panel Downloads Power...