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...
11 December
2017
Author: Robert Cain

Creating Azure Resource Groups Safely With PowerShell

A few posts back I mentioned that I had become a SimpleTalk author, and that my first post for them was PowerShell Functions For Reusability and Restartability in Azure (read it at http://bit.ly/acred01) I’ve created a companion video for it, which focuses on creating Resource Groups. You can see...
10 December
2017
Author: Robert Cain

Fixed! PowerPoint 2016 Presenter View Not Showing

I purchased a new laptop earlier this year, a pretty sweet Lenovo ThinkPad. The only thing that annoyed me was PowerPoint 2016 wouldn’t show the presenter view. Well I finally got around to tracking down the issue. I found a post in an MSDN forum that was close, but not quite right in the...
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 –...
30 November
2017
Author: Robert Cain

I’m Now a SimpleTalk Author!

Adding to my other activities, I’m now writing for SimpleTalk, RedGate’s community hub. My first article just went live. PowerShell Functions for Reusability and Restartability in Azure is the title, in it I describe how to implement the concepts of reusability and restartability in PowerShell....
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...