Category Archives: Power Bi


Data Visualization – Microsoft BI tooling 101

Data Visualization – Microsoft BI tooling 101

This is the last episode in the Microsoft BI tooling 101 series where I cover the Microsoft BI platform from the perspective of a Developer / DBA. I recently had to do a deep dive into this subject and therefore decided to put some of my findings into writing. As the title suggests, this part will cover how to visualize data.

Read More →

PowerPivot – Microsoft BI tooling 101

PowerPivot – Microsoft BI tooling 101

Within the first article of this Microsoft business intelligence tooling series I’ve briefly covered some of the basics of Power Query for Excel. However finding, consuming, transforming and sharing data using Power Query is just the first step when it comes to analyzing data within Excel.

Once you have formatted your data correctly, it’s time to start the analysis proses using another excel add-in called PowerPivot . Given that I’m telling my story from an IT perspective, I will include some technical details as well.

Read More →

Power Query – Microsoft BI tooling 101

Power Query – Microsoft BI tooling 101

This is the start of a series wherein I will cover the Microsoft’s Business intelligence toolset from a IT Admin, DBA’s, and Developers perspective. Each post will cover one of the different tools and solution currently available under the Microsoft BI umbrella as well as best practices and common pitfalls. Having a basic grasp of what’s out there is important when it comes to supporting your users and might prevent developers from re-inventing the wheel again.

Read More →