New Power BI Designer Tutorial

When the Power BI Designer Preview was released a few months ago I set out to reproduce a solution I had created using the Excel 2013 Power BI tools and hit a couple of road blocks.  With a little help from my friends, community members and some bull-headed persistence, I’m proud to say that I’ve prevailed and I’m pretty hyped about what this thing can do.  The PBID includes all the goodness of Power Query and a supercharged version on Power View but it currently lacks some of the advanced modeling capabilities of Power Pivot.  Since I’ve been using Power Pivot for a few years now, I’ve figured out how to solve certain problems using DAX but hadn’t really left the shallow part of the pool with the Power Query M language.  Well, there’s nothing like a good challenge to force you into the deep water.  I reached out to some folks in the community and really appreciate the assistance from Chris Webb, and Matthew Roche & Curt Hagenlocher from Microsoft.  I’m certainly not an ‘M’ guru yet but it’s been fun working with this powerful data transformation tool.  The new video uses the UFO sightings data from the National UFO Reporting Center that I used in the Excel tools.

I’ve created another video demo/tutorial from my experience.  It’s on my YouTube channel and embedded into this page on my blog:
https://sqlserverbiblog.wordpress.com/video-tutorials

So far:

  • Power BI Designer Solution (part 1 of 2)
  • Power BI Designer Solution (part 2 of 2)
  • Power BI Complete Demonstration – Part 1 Power Query
  • …Part 2 Power Pivot
  • …Part 3 Power View
  • …Part 4 Data Correlation
  • …Part 5 Publish to Office 365