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.

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...
12 August
2017
Author: DustinRyan
DustinRyan

Building Your Brand and Becoming a Thought Leader Session Materials

Thank you to everyone that attending my session today at SQL Saturday #649 in Jacksonville, Florida! It was a packed room with over 70 people attending my session and the audience was lively! We had lots of great questions and tons of awesome interaction! If you want to download my slide deck...
10 August
2017
Author: DustinRyan
DustinRyan

What-If Analysis in Power BI Desktop

One of the most talked about features previewed during the Microsoft Data Insights Summit in the previous June was the What-If Analysis capabilities. Today, this capability was finally released as part of the August update to Power BI Desktop. New to Power BI? Start here! The What...
09 August
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 63 – Quadrant Chart)

In this module you will learn how to use the Quadrant Chart Custom Visual.  The Quadrant Chart is used to show a distribution of data across separate quadrants. Module 63 – Quadrant Chart Downloads Power BI Custom Visual – Quadrant Chart Dataset – NFL Offense.xlsx Completed Example – Module 63...
08 August
2017
Author: DevinKnight
DevinKnight

Power BI – Problem, Design, Solution (Text Search Slicer)

There is a video that walks you through the solution in depth, please find the video at the end of this post along with the completed solution. In this installment of the Problem, Design, Solution series we are going to show you how to perform a text search using slicers in Power BI, this...
04 August
2017
Author: BradleyBall

Day of Data Science with SQL Server, Azure ML, Spark, Hadoop, and R

Hello Dear Reader!  Next week in Jacksonville, Friday August 11th,  I will be presenting a Day of Data Science: With SQL Server 2016/2017, Azure ML, Spark, Hadoop, & R.  We will also be working in some Power BI, and may even be building something like what you see on the page.  Here's the...
31 July
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 62 – Beyondsoft Calendar)

In this module you will learn how to use the Beyondsoft Calendar Custom Visual.  The Beyondsoft Calendar displays a single metric across a month calendar. Module 62 – Beyondsoft Calendar Downloads Power BI Custom Visual – Beyondsoft Calendar Dataset – Daily Sales Results.xlsx Completed Example...
28 July
2017
Author: DustinRyan
DustinRyan

Power BI NFL Football Stats Comparisons and Analysis Report is now available!

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power BI reports featuring player statistics. This year is no different. This year I’m finally able to release my NFL Football Stats, Comparisons, and Analysis reports featuring the stats...
28 July
2017
Author: DustinRyan
DustinRyan

Power BI NFL Football Stats Comparisons and Analysis Report is now available!

For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power BI reports featuring player statistics. This year is no different. This year I’m finally able to release my NFL Football Stats, Comparisons, and Analysis reports featuring the stats...