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 September
2017
Author: Robert Cain

Windows 10 Icons Not Showing, Preview Not Working

I had a weird issue with Windows 10 today. All of a sudden, my icons weren’t displaying correctly. When I had the Preview Pane on, nothing was displayed. Even more bizarre, The Layout area of the View pane in Windows Explorer, had all the icons disabled. Turned out I had a corrupted icon cache....
19 September
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 69 – Heatmap)

In this module you will learn how to use the Heatmap Custom Visual.  The Heatmap is useful for show data density on a map. It does this well because it aggregates data points and plots them to colors on a map. Module 69 – Heatmap Downloads Power BI Custom Visual – Heatmap Dataset – Consumer...
11 September
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 68 – Dynamic Tooltip MAQ Software)

In this module you will learn how to use the Dynamic Tooltip Custom Visual by MAQ Software.  The Dynamic Tooltip allows you to add extra insight to your report or visuals with a popup that provides additional information. Module 68 – Dynamic Tooltip (MAQ Software) Downloads Power BI Custom...
05 September
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 67 – Impact Bubble Chart)

In this module you will learn how to use the Impact Bubble Chart Custom Visual.  The Impact Bubble Chart is an animated bubble chart that allows you to compare two entities against each other. Module 67 – Impact Bubble Chart Downloads Power BI Custom Visual – Impact Bubble Chart Dataset – Movie...
02 September
2017
Author: DustinRyan
DustinRyan

Setting Up a Drillthrough Action in your Power BI Report

At some point this weekend, the Microsoft Power BI folks turned on the drillthrough feature in the Power BI service. This is the same drillthrough feature that demonstrated during day 1 of the Microsoft Data Insights Summit, which you can read about here. So I thought it’d be good to quickly walk...
29 August
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 66 – Calendar by Tallan)

In this module you will learn how to use the Calendar Custom Visual by Tallan.  The Calendar Visual provides a calendar layout that filters and aggregates data across a range of dates. Module 66 – Calendar by Tallan Downloads Power BI Custom Visual – Calendar by Tallan Dataset – Correctional...
24 August
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 65 – Visio Visual)

In this module you will learn how to use the Visio Visual Custom Visual.  The Visio Visual allows you to embed Visio diagrams stored in either OneDrive for Business or Sharepoint Online in your Power BI reports. Module 65 – Visio Visual Downloads Power BI Custom Visual – Visio Visual Dataset –...
23 August
2017
Author: DustinRyan
DustinRyan

Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI

Late last month Microsoft released the certification exam for Power BI, 70-778: Analyzing and Visualizing Data with Microsoft Power BI. The exam is currently in beta and will likely remain that way for the next eight to twelve weeks. If you were lucky enough to snag one of the 300 uses of the...
18 August
2017
Author: DustinRyan
DustinRyan

Power BI FAQ Chat Bot 9000 lives!

So I’ve been working on a fun little project over the past couple weeks. A lot of my customers have questions related to Power BI and I spend a lot of my time answering those questions. So I said to myself, “Self, why don’t you build a chat bot that can help field some of those basic questions?”...
17 August
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 64 – Dot Plot MAQ Software)

In this module you will learn how to use the Dot Plot Custom Visual by MAQ Software.  The Dot Plot is used to show distribution using dots among multiple categories or attributes. Module 64 – Dot Plot (MAQ Software) Downloads Power BI Custom Visual – Dot Plot (MAQ Software) Dataset – Regional...