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!

 

About lynnlangit

redheaded girl geek (SoCalDevGal), linguist, BigData expert, SQL Server Business Intelligence author, co-founder of "Teaching Kids Programming"
This entry was posted in Big Data, Data Science, Microsoft. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s