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

Power BI Custom Visuals Class (Module 43 – Gantt)

In this module you will learn how to use the Gantt Power BI Custom Visual.  Using the Gantt chart you can easily visualize project timelines and deliverable completion. Module 43 – Gantt Downloads Power BI Custom Visual – Gantt Dataset – Project Progress.xlsx Completed Example – Module 43 –...
14 March
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 42 – Stars)

In this module you will learn how to use the Stars Power BI Custom Visual.  The Stars visual is a great way to visualize ratings data. Module 42 – Stars Downloads Power BI Custom Visual – Stars Dataset – Movie Ratings.xlsx Completed Example – Module 42 – Stars.pbix Key Takeaways The Stars...
07 March
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 41 – Image Viewer)

In this module you will learn how to use the Image Viewer Power BI Custom Visual.  The Image Viewer visual helps in displaying images based on an image URL stored in your data. Module 41 – Image Viewer Downloads Power BI Custom Visual – Image Viewer Dataset – Car Listings.xlsx Completed Example...
06 March
2017
Author: Robert Cain

IT ops and news talk–Episode 3 Secure that Jump Server

I owe everyone an apology, I missed blogging about this at the time it occurred. Last December I was a guest on Don Box’s podcast, “IT ops and news talk”. I appeared on Episode 3, Secure that Jump Server. In the podcast we discuss the testing of PowerShell code with Pester. After that we got...
01 March
2017
Author: BradleyBall

Microsoft: 1 Year in, how's it going?

Hello Dear Reader, one year ago today it was leap year, February 29th 2016. So I'm a year older, the big four zero.... 40.  A little wiser?  Maybe. Despite my New Year's resolution to get fatter and work out less, I've lost 21 pounds and I'm working out 3-5 times a week.  CURSE YOU NEW YEARS...
28 February
2017
Author: BradleyBall

How Do I Add an R Package to SQL Server from In-Database R?

Hello Dear Reader!  I'm working on some really fun stuff with in-database R using SQL Server 2016. I needed to add a couple packages to my R engine so I could use them and call them from an R script. I realized I had not added any external packages to my R instance so this was a perfect...
28 February
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 40 – Long Text Viewer)

In this module you will learn how to use the Long Text Viewer Power BI Custom Visual.  The Long Text Viewer visual helps in displaying longer text fields that you have in your dataset. Module 40 – Long Text Viewer Downloads Power BI Custom Visual – Long Text Viewer Dataset –...
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...