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.

29 August
2016
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 14 – Tornado)

In this module you will learn how to use the Tornado Power BI Custom Visual.  The Tornado allows you to compare two categories of data vertically similar to a bar chart. Module 14 – Tornado Downloads Power BI Custom Visual – Tornado Dataset – Pay by Job Title.xlsx Completed Example – Module...
29 August
2016
Author: BradleyBall

SQL Azure, Hekaton, and Bob Dorr is Awesome

Hello Dear Reader!  I had recently written a blog for the PFE blog, "How Many Tables Can I Have In SQL Azure DB & SQL Server".   It was a fun blog that I had written during a very long layover when traveling home.  It covers the maximum number of objects that you can create in SQL Server.In this...
24 August
2016
Author: DevinKnight
DevinKnight

This Week in Data – Episode 1 (The Value of Certifications)

We know you you’ve been dying to know, what is TWID?  Drumroll please…. We’re excited to announce the launch of This Week In Data!  This Week In Data is a weekly video podcast hosted by Adam Jorgensen and Devin Knight that discusses important news and topics within the data world. The goal of...
23 August
2016
Author: kmyer

C# 6 Programming with Visual Studio 2015 – Part 1

Hi all, I must say that I haven’t blogged in a while and even that is an understatement. But I’m back! For now anyways… Let’s move on from that. I should preface the rest of this blog with some expectations I would like to instill into you as the reader. This is a big boring book. If you don’t...
23 August
2016
Author: DustinRyan
DustinRyan

Power BI NFL Fantasy Football 2016 Reports

If you have followed my blog for the past year or so you may remember when I posted a Power BI workbook I created to analyze the previous season’s NFL player stats to help me with my fantasy football draft. I know, its nerdy, but I like Power BI and I like fantasy football so I thought why...
22 August
2016
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 13 – Aster Plot)

In this module you will learn how to use the Aster Plot Power BI Custom Visual.  The Aster Plot is a twist on the standard Pie or Donut Chart.  What sets the Aster Plot apart from these visuals is that it has the ability to use a second measure to drive the sweep angle. Module 13 – Aster...
19 August
2016
Author: DustinRyan
DustinRyan

Introduction to Power BI Desktop – Session Materials Available

For my second time, I was afforded the great opportunity to present virtually to the great people of the Madison Power BI User Group. I’m always really excited when someone invites me back a second time to speak because that means that the first time wasn’t completely awful! We had a great time...
19 August
2016
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 12 – Bullet Chart)

In this module you will learn how to use the Bullet Chart Power BI Custom Visual.  The Bullet Chart serves as a replacement for poorly designed dashboard gauges and meters you might be using now. Typical gauges do not show very much information and require a lot of space on a dashboard.  The...
18 August
2016
Author: DustinRyan
DustinRyan

SQL Server 2016 Rundown – Session Materials Available

Yesterday evening I had the distinct pleasure of presenting at the Jacksonville SQL Server Users Group on some of the new features of SQL Server 2016. We had delicious pizza, lots of great networking, and a lot of fun talking about SQL Server. The group had a ton of great questions, too! Thank...
10 August
2016
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 11 – Calendar Visualization)

In this module you will learn how to use the Calendar Visualization Power BI Custom Visual.  The Calendar Visualization is a very unique visual that allows you to show the distribution of values across a calendar. Module 11 – Calendar Visualization Downloads Power BI Custom Visual – Calendar...