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 March
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 43 – Gantt)

In this module you will learn how to use the Gantt Power BI Custom Visual.  Using the Gantt chart you can easily visualize project timelines and deliverable completion. Module 43 – Gantt Downloads Power BI Custom Visual – Gantt Dataset – Project Progress.xlsx Completed Example – Module 43 –...
14 March
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 42 – Stars)

In this module you will learn how to use the Stars Power BI Custom Visual.  The Stars visual is a great way to visualize ratings data. Module 42 – Stars Downloads Power BI Custom Visual – Stars Dataset – Movie Ratings.xlsx Completed Example – Module 42 – Stars.pbix Key Takeaways The Stars...
07 March
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 41 – Image Viewer)

In this module you will learn how to use the Image Viewer Power BI Custom Visual.  The Image Viewer visual helps in displaying images based on an image URL stored in your data. Module 41 – Image Viewer Downloads Power BI Custom Visual – Image Viewer Dataset – Car Listings.xlsx Completed Example...
01 March
2017
Author: BradleyBall

Microsoft: 1 Year in, how's it going?

Hello Dear Reader, one year ago today it was leap year, February 29th 2016. So I'm a year older, the big four zero.... 40.  A little wiser?  Maybe. Despite my New Year's resolution to get fatter and work out less, I've lost 21 pounds and I'm working out 3-5 times a week.  CURSE YOU NEW YEARS...
28 February
2017
Author: BradleyBall

How Do I Add an R Package to SQL Server from In-Database R?

Hello Dear Reader!  I'm working on some really fun stuff with in-database R using SQL Server 2016. I needed to add a couple packages to my R engine so I could use them and call them from an R script. I realized I had not added any external packages to my R instance so this was a perfect...
28 February
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 40 – Long Text Viewer)

In this module you will learn how to use the Long Text Viewer Power BI Custom Visual.  The Long Text Viewer visual helps in displaying longer text fields that you have in your dataset. Module 40 – Long Text Viewer Downloads Power BI Custom Visual – Long Text Viewer Dataset –...
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...