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).

PowerQuery

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!