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!