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 August
2017
Author: DustinRyan
DustinRyan

Building Your Brand and Becoming a Thought Leader Session Materials

Thank you to everyone that attending my session today at SQL Saturday #649 in Jacksonville, Florida! It was a packed room with over 70 people attending my session and the audience was lively! We had lots of great questions and tons of awesome interaction! If you want to download my slide deck...
10 August
2017
Author: DustinRyan
DustinRyan

What-If Analysis in Power BI Desktop

One of the most talked about features previewed during the Microsoft Data Insights Summit in the previous June was the What-If Analysis capabilities. Today, this capability was finally released as part of the August update to Power BI Desktop. New to Power BI? Start here! The What...
09 August
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 63 – Quadrant Chart)

In this module you will learn how to use the Quadrant Chart Custom Visual.  The Quadrant Chart is used to show a distribution of data across separate quadrants. Module 63 – Quadrant Chart Downloads Power BI Custom Visual – Quadrant Chart Dataset – NFL Offense.xlsx Completed Example – Module 63...
08 August
2017
Author: DevinKnight
DevinKnight

Power BI – Problem, Design, Solution (Text Search Slicer)

There is a video that walks you through the solution in depth, please find the video at the end of this post along with the completed solution. In this installment of the Problem, Design, Solution series we are going to show you how to perform a text search using slicers in Power BI, this...
07 August
2017
Author: SteveHughes

Power BI and Data Security – App Workspaces and Power BI Apps

Shortly after I published the Power BI Security Sharing Data post in April, Power BI Premium, Power BI Apps, and Power BI App Workspaces were released. These changes impacted that post in many ways. As part of the follow up, I also did an updated webcast with Pragmatic Works. This is a follow up...
04 August
2017
Author: MitchellPearson

Power BI–Problem, Design, Solution (Text Search)

  At the end of this blog there will be a video that walks you through the solution in depth. In this installment of the Problem, Design, Solution series we are going to show you how to perform a text search using slicers in Power BI, this simulates a “LIKE” type search. In the following...
04 August
2017
Author: SteveHughes

Power BI and Data Security – Free User’s Cannot Share, Read Only in Premium

As part of the Power BI Premium release, Microsoft changed how the “free users” in Power BI work within the platform. There are two key changes that affect the data security within your organization. Power BI Free Users Cannot Share One of the key areas of concern around the free user accounts...
04 August
2017
Author: BradleyBall

Day of Data Science with SQL Server, Azure ML, Spark, Hadoop, and R

Hello Dear Reader!  Next week in Jacksonville, Friday August 11th,  I will be presenting a Day of Data Science: With SQL Server 2016/2017, Azure ML, Spark, Hadoop, & R.  We will also be working in some Power BI, and may even be building something like what you see on the page.  Here's the...
31 July
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 62 – Beyondsoft Calendar)

In this module you will learn how to use the Beyondsoft Calendar Custom Visual.  The Beyondsoft Calendar displays a single metric across a month calendar. Module 62 – Beyondsoft Calendar Downloads Power BI Custom Visual – Beyondsoft Calendar Dataset – Daily Sales Results.xlsx Completed Example...
29 July
2017
Author: MitchellPearson

SSIS Performance Tuning

This is my much overdue follow-up blog from the presentation I gave to the New York SQL Server User Group. In this post, I am going to provide some additional resources to supplement the presentation, check out the following blog post on different performance tuning techniques that can be used...