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.

16 February
2018
Author: BradleyBall

Black Panther is Going to Change Superhero Movies

Hello Dear Reader!  Sorry it has been so long, I've been blogging over on the MSDN site about technology.  I'll have a Twitter Sentiment update for Black Panther later today with an update on Tuesday for the holiday weekend.Since the early 2000's a trend of Superhero movies began, comic book...
13 February
2018
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 90 – Brick Chart MAQ Software)

In this module you will learn how to use the Brick Chart by MAQ Software. The Brick Chart provides a simple method for highlighting your best and worst performers in a 100 square colored chart. Module 90 – Brick Chart (MAQ Software) Downloads Power BI Custom Visual – Brick Chart (MAQ...
12 February
2018
Author: DevinKnight
DevinKnight

How I Used Pragmatic Works Training to Pass the Power BI 70-778 Certification

Recently I took and passed the Microsoft certification exam 70-778 for Power BI called Analyzing and Visualizing Data with Microsoft Power BI.  I’ve taken Microsoft certification exams in the past but for the first time I took the exam using the online proctor method.  I read several reviews by...
08 February
2018
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 89 – Filter by List)

In this module you will learn how to use the Filter by List Custom Visual. The Filter by List allows you to easily copy and paste in a list of values that you wish to filter by on your report. Module 89 – Filter by List Downloads Power BI Custom Visual – Filter by List Dataset – Sales By...
30 January
2018
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 88 – Pulse Chart)

In this module you will learn how to use the Pulse Chart Custom Visual. The Pulse Chart can easily display trends in your data and any events that could have causes those trends to occur. Module 88 – Pulse Chart Downloads Power BI Custom Visual – Pulse Chart Dataset – US Stock...
30 January
2018
Author: DustinRyan
DustinRyan

Converting a Power BI Desktop File from Import to Live Query

A customer of mine is in the midst of a proof of concept using SQL Server and Power BI. During the POC, all the modeling was done in Power BI Desktop. Now that the POC is coming to the next phase, the customer is ready to move the Power BI data model to Analysis Services. But the problem is that...
28 January
2018
Author: DustinRyan
DustinRyan

2017 Year in Review for SQLDusty.com

2017 was an awesome year for SQLDusty.com! Thank you to all of the readers and visitors that stopped by to leave a comment or share a blog post on social media. I appreciate all of you! But I also thought I’d share some interesting stats from the previous year: 18 new blog posts 261,586...
23 January
2018
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 87 – Funnel with Source MAQ Software)

In this module you will learn how to use the Funnel with Source Custom Visual by MAQ Software. The Funnel with Source is great for displaying data as it flows through a process or set of steps. Module 87 – Funnel with Source (MAQ Software) Downloads Power BI Custom Visual – Funnel with Source...
19 January
2018
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 86 – Bubble Chart by Akvelon)

In this module you will learn how to use the Bubble Chart Custom Visual by Akvelon. The Bubble chart allows you to show the value of categories proportionally represented by the size of the bubble. Module 86 – Bubble Chart By Akvelon Downloads Power BI Custom Visual – Bubble Chart by...
12 January
2018
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 85 – Image Grid)

In this module you will learn how to use the Image Grid Custom Visual. This visual is a unique way to visualize multiple images at once that can be resorted by a measure value. Module 85 – Image Grid Downloads Power BI Custom Visual – Image Grid Dataset – Movie Studios.xlsx Completed Example –...