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.

12 December
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 81 – Social Network Graph)

In this module you will learn how to use the Social Network Graph Custom Visual. The Social Network Graph allows you to visualize relationships between people or items in your data. Module 81 – Social Network Graph Downloads Power BI Custom Visual – Social Network Graph Dataset – Coaching...
11 December
2017
Author: DustinRyan
DustinRyan

Creating a Knowledge Base Chat Bot w/ Azure Bot Service

A while back you may have caught my blog post introducing the Power BI Chat Bot 9000. Since posting that blog, I’ve received a lot of requests on the steps required to build the bot. The good new is that its super easy and really only take a few minutes to get it set up. In this blog post, I’m...
06 December
2017
Author: DustinRyan
DustinRyan

Making Sense of Data Migration Assistant Assessments with Power BI

The Data Migration Assistant is a great tool developed to assess your SQL Server environment for a migration to a modern SQL Server platform such as SQL Server 2017 or Azure SQL Database. If you’re assessing a single SQL Server with only a few databases, reading the exported results (which can be...
04 December
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 80 – TreeViz)

In this module you will learn how to use the TreeViz Custom Visual. The TreeViz is a breakdown tree that allows you to expand or collapse levels of hierarchical data. Module 80 – TreeViz Downloads Power BI Custom Visual – TreeViz Dataset – Sales by Product Hierarchy.xlsx Completed Example –...
27 November
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 79 – Venn Diagram MAQ Software)

In this module you will learn how to use the Venn Diagram Custom Visual by MAQ Software. The Venn Diagram shows relationships between two or more categories with overlapping circles. Module 79 – Venn Diagram (MAQ Software) Downloads Power BI Custom Visual – Venn Diagram (MAQ Software) Dataset –...
21 November
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 78 – Data Image by CloudScope)

In this module you will learn how to use the Data Image Power BI Custom Visual by CloudScope. The Data Image visual helps in displaying images based on an image URL stored in your data. Module 78 – Data Image by CloudScope Downloads Power BI Custom Visual – Data Image by CloudScope Dataset –...
13 November
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 77 – Card Browser)

In this module you will learn how to use the Card Browser Custom Visual.  The Card Browser allows you to display document data in visually appealing way with images. Module 77 – Card Browser Downloads Power BI Custom Visual – Card Browser Dataset – Pragmatic Works Employees.xlsx Completed...
08 November
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 76 – Image Timeline)

In this module you will learn how to use the Image Timeline Custom Visual.  The Image Timeline is a great way to display data in order across a timeline.  If you have images of your data you can also display those images on the timeline. Module 76 – Image Timeline Downloads Power BI Custom...
01 November
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 75 – Enlighten Stack Shuffle)

In this module you will learn how to use the Enlighten Stack Shuffle Custom Visual.  The Enlighten Stack Shuffle is helpful when you want to display a Top N set of values.  For example if you want to display your top 5 selling employees this visual can make that very easy. Module 75 – Enlighten...
23 October
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 74 – Cylindrical Gauge MAQ Software)

In this module you will learn how to use the Cylindrical Gauge Custom Visual by MAQ Software.  The Cylindrical Gauge can be helpful for visualizing a single metric on your report. Module 74 – Cylindrical Gauge (MAQ Software) Downloads Power BI Custom Visual – Cylindrical Gauge (MAQ...