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 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 –...
02 January
2018
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 84 – ChartAccent – BarChart)

In this module you will learn how to use the ChartAccent BarChart Custom Visual. This visual is a custom bar chart that allows you to annotate individual data points, data series and ranges. Module 84 – ChartAccent – BarChart Downloads Power BI Custom Visual – ChartAccent – LineChart Dataset –...
27 December
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 83 – ChartAccent – LineChart)

In this module you will learn how to use the ChartAccent LineChart Custom Visual. This visual is a custom line chart that allows you to annotate individual data points, data series and ranges. Module 83 – ChartAccent – LineChart Downloads Power BI Custom Visual – ChartAccent – LineChart Dataset...
19 December
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 82 – Text Filter)

In this module you will learn how to use the Text Filter Custom Visual. This visual allows you to filter all the other visuals on your report by typing in a value into the Text Filter. Module 82 – Text Filter Downloads Power BI Custom Visual – Text Filter Dataset – All Product...
18 December
2017
Author: DevinKnight
DevinKnight

Power BI – Problem, Design, Solution (Folder Source Option for JSON files)

Hello Everyone! In this episode of  the “Problem, Design, Solution” series we will be talking about the “Folder” option inside the sources display for Power BI Desktop. This is a fantastic feature that works so very well with your standard Delimited/CSV (Comma Separated Value) files, making life...
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 –...