I’ll admit it, I am really hooked on PowerBI in Excel 2013 – in particular, I find many uses for PowerQuery (shown below).
To that end, I was playing around with my Slideshare analytics data in PowerBI and I learned a thing or two. Below is a screen of my data as I was filtering and shaping it in PowerQuery. You may note some of the transformation steps to the right of the screen below.
If you are a scripting kind of person, here’s a look at part of the transformation script generated by PowerQuery.
I also made a short screencast, showing the process I used in more detail.
In case you don’t want to watch the video, here’s what I found – database people tweet!