Looking at Slideshare data with Excel PowerBI

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.

Using PowerQuery to filter and shape Slideshare data


If you are a scripting kind of person, here’s a look at part of the transformation script generated by PowerQuery.

PowerQuery transformation script

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!

Database people love to tweet!