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 February
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 39 – Waffle Chart)

In this module you will learn how to use the Waffle Chart Power BI Custom Visual.  The Waffle Chart visual is most useful for presenting a percentage of data. This chart is a great option to choose over other visuals like Pie Charts, which are not great at showing proportions of data. Module 39 –...
14 February
2017
Author: SteveHughes

T-SQL Tuesday #87 – Fixing Old Problems with Shiny New Toys: STRING_SPLIT

Thanks to Matt Gordon (@atsqlspeed) for hosting this T-SQL Tuesday. Splitting Strings in SQL A problem that has plagued SQL developers through the years is splitting strings. Many techniques have been used as more capabilities were added to SQL Server including XML datatypes, recursive CTEs and...
14 February
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 38 – Mekko Chart)

In this module you will learn how to use the Mekko Chart Power BI Custom Visual.  The Mekko Chart visual is helpful when you need to analyze two different dimensions on a single chart. Module 38 – Mekko Chart Downloads Power BI Custom Visual – Mekko Chart Dataset – Country Sales.xlsx Completed...
09 February
2017
Author: SteveHughes

Consumption Based Architecture for Modern Data Analytics

Throughout many years of working with BI solutions and data warehouse solutions, we have strived to put all the data in one location so it could be easily consumed by reporting and analysis tools from SQL Server Reporting Services to Microsoft Excel. We have followed the dimensional modeling...
08 February
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 37 – Gap Analysis)

In this module you will learn how to use the Gap Analysis Power BI Custom Visual.  The Gap Analysis visual is used to analyze the difference between two different groups of data you have.  For example, you might use it to analyze the gap between two answers people gave in survey response...
07 February
2017
Author: JasonStrate

Not Quite Monday Morning SQL Break – February 7, 2017

It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late and I need to find a better way to ensure that I get this out the published.  If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform...
07 February
2017
Author: JasonStrate

Not Quite Monday Morning SQL Break – February 7, 2017

It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late and I need to find a better way to ensure that I get this out the published.  If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform...
03 February
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 36 – Box and Whiskers (Brad))

In this module you will learn how to use the Box and Whiskers (Brad) Power BI Custom Visual.  This is the second of two Box and Whiskers visuals that we have covered (You can learn more about the first one here). The Box and Whiskers chart is used to show things like data outliers, clusters of...
03 February
2017
Author: BradleyBall

The High Availability Conversation Part 1: Introduction

Hello Dear Reader!  Twitter is a fantastic tool if you use SQL Server.  It is a great way to network, find presentations, interact with experts, and #SQLHelp offers some of the best technical forum conversation on the subject.  I was on Twitter and my friend Kenneth Fisher asked a question....
03 February
2017
Author: Robert Cain

Troy Hunt: A data breach investigation blow-by-blow

This is a fascinating read from security researcher Troy Hunt. In it he describes the process by which he investigates a data breach. Well worth the read. https://www.troyhunt.com/a-data-breach-investigation-blow-by-blow/