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.

21 June
2017
Author: DustinRyan
DustinRyan

How to Automate Processing of Azure Analysis Services Models

I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache for some data in an Azure Data Warehouse instance. One of the things I’ve been working on is scheduling the automatic processing of the Azure AS database. I did find the following...
20 June
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 56 – Rotating Tile)

In this module you will learn how to use the Rotating Tile Custom Visual.  The Rotating Tile gives you the ability to display multiple metrics on a single visual that rotates through each value you wish to display.  This allows you to save valuable space on your reports! Module 56 – Rotating...
15 June
2017
Author: DustinRyan
DustinRyan

Microsoft Data Insights Summit Day 2 Recap: Timeline Storyteller, Future of Power BI Desktop, and Freakonomics

The theme of day 2 of the Microsoft Data Insights Summit was sessions, sessions, sessions! There were a ton of different sessions for attendees and for us to watch! In total, there are 75 different videos between the keynotes and the individual sessions posted on the Microsoft Power BI YouTube...
13 June
2017
Author: DustinRyan
DustinRyan

Microsoft Data Insights Summit Day 1 Recap: Power BI Visio & PowerApps Integration, Custom Drill Through Actions, Book Marks, What If Analysis, & Data Insights

If you were at the Microsoft Data Insights Summit or were watching the live stream of the keynote, then you know that yesterday was a great day for Power BI! There were numerous announcements regarding new features, capabilities, and integrations coming to Power BI (If you missed it, you can...
12 June
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 55 – Enlighten World Flag Slicer)

In this module you will learn how to use the Enlighten World Flag Slicer Custom Visual.  The Enlighten World Flag Slicer takes a text field from your dataset and if the value uses a country’s name or abbreviation it will display a flag. This flag visual can then be used to filter other report...
12 June
2017
Author: DustinRyan
DustinRyan

Deploying to Power BI Premium

Obviously the big news of the day is the announcement for general availability of Power BI Premium! And if you were at or you watched the Microsoft Data Insights Summit you saw that announcement. But early last month on May 3rd, Microsoft announced Power BI Premium, which allows you purchase...
06 June
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 54 – Route Map)

In this module you will learn how to use the Route Map Power BI Custom Visual.  The Route Map uses latitude, longitude, and time to show the trajectory of an object on a map. Module 54 – Route Map Downloads Power BI Custom Visual – Route Map Dataset – Vessel Tracking.xlsx Completed Example –...
30 May
2017
Author: DustinRyan
DustinRyan

Setting up Cross Database Queries in Azure SQL Database

A question that I answer what seems like all the time is how to run cross-database queries against Azure SQL Database. So rather than answering those questions repeatedly I figured I should blog my response up so from here on out I can just forward the link to this blog on to my customers and...
30 May
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 53 – Play Axis)

In this module you will learn how to use the Play Axis Power BI Custom Visual.  The Play Axis visual works like a dynamic slicer that animates your other report visuals without needing to click every time you want to change your filter value. Module 53 – Play Axis Downloads Power BI Custom...
24 May
2017
Author: DevinKnight
DevinKnight

Power BI – Problem, Design, Solution (Concatenated Tooltip)

Welcome to a new series that I’m starting with a few colleagues at Pragmatic Works. The goal of this series is to document many design practices and solutions to problems that we often run into with customers. Each post will be accompanied by a video (found in the bottom under Resources) that...