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.

25 April
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 48 – Time Brush)

In this module you will learn how to use the Time Brush Power BI Custom Visual.  The Time Brush gives you the ability both filter your report and see a graphics representation of your data at the same time. The name Time Brush comes from the behavior used when you select the values you’d like to...
25 April
2017
Author: MitchellPearson

Advanced DAX Webinar

Hey Everyone, Thanks for attending the free 1 hour DAX Webinar by Pragmatic Works. In this blog I am going to focus on the primary question that I saw come up over and over again in the chat logs. The webinar can be found here: How come the totals for Forecast and Dynamic are the same? The Grand...
19 April
2017
Author: SteveHughes

Thoughts about the Microsoft Data Amp Announcements

Microsoft conducted a live event called Microsoft Data Amp to announce a number of key features and releases for SQL Server on premises and data platforms in Azure (such as Azure SQL DB and Azure Data Lake). Some of these include features that I have been waiting to see. Here are some of...
19 April
2017
Author: Robert Cain

What happened to Save-AzureRmProfile?

I’ve been working a lot in the Azure PowerShell area of late. One thing I wanted to be able to do is have my scripts login automatically to Azure. In many examples the cmdlet Save-AzureRmProfile was used to save your Azure credentials, then later you could use Import-AzureRmProfile to import...
18 April
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 47 – Line Dot Chart)

In this module you will learn how to use the Line Dot Chart Power BI Custom Visual.  The Line Dot Chart gives you the ability to make a more engaging line chart that can actually be animated across time. Module 47 – Line Dot Chart Downloads Power BI Custom Visual – Line Dot Chart Dataset –...
14 April
2017
Author: SteveHughes

Power BI and Data Security – Row Level Security (RLS)

As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern. Power BI at its best is deployed to the Power BI service hosted on Microsoft’s Azure platform. Every enterprise should understand the level of security...
13 April
2017
Author: SteveHughes

Power BI and Data Security – Data Classification and Privacy Levels

As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern. Power BI at its best is deployed to the Power BI service hosted on Microsoft’s Azure platform. Every enterprise should understand the level of security...
13 April
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 46 – Table Sorter)

In this module you will learn how to use the Table Sorter Power BI Custom Visual.  The Table Sorter allows you to rapidly re-sort and rank values by within a table. Module 46 – Table Sorter Downloads Power BI Custom Visual – Table Sorter Dataset – NFL Data.xlsx Completed Example – Module 46 –...
12 April
2017
Author: SteveHughes

Power BI and Data Security – On-premises Data Gateway

As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern. Power BI at its best is deployed to the Power BI service hosted on Microsoft’s Azure platform. Every enterprise should understand the level of security...
11 April
2017
Author: SteveHughes

Power BI and Data Security – Sharing Data

As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern. Power BI at its best is deployed to the Power BI service hosted on Microsoft’s Azure platform. Every enterprise should understand the level of security...