Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

IMDb Analysis with Microsoft Power BI

Posted by denglishbi on January 15, 2014

The Microsoft Power BI Contest entry submission ended today and this morning I worked on my video and got my entry posted.  For my entry I ended up going with the Top 250 rated movies on IMDb.  Last year when I was testing out “Data Explorer” (now called Power Query) I did a blog posting that highlighted this set of data along with some Power View reports here – Installing Data Explorer Preview Demo with IMDb Data

Since that post, which was back in March 2013, the data on the web page has changed (ratings of course, but the data available).  Like now the vote counts were not included in the table on the web page.  Also, I was using an external site to get some XML data to reference for additional information about the movies, well that changed to, so I did get to freshen up the demo a bit.  I also had to prepare some additional items for the Office 365, Power BI, Q&A, and I did setup a Windows 8 Power BI demo.

For our entries we were limited to only 10 minutes, so by no means are these going to be an end-to-end instruction guide.  I didn’t go into a deep analysis of the data, what I was trying to demonstrate was the ability to go from a basic web page of data to a fully decked out analysis tool.  I used Excel 2013, Power Query, Power Pivot, Pivot Charts and Tables, Power View, Office 365, Power BI, and the latest Q&A, so I was trying to show off as much as I could and stay within the timeframe provided.  I also had a demo to show off the Windows 8 Power BI app, but I wasn’t sure the Camtasia video capture software would capture the app demo since it was running on my desktop (will need to test that).

Here is the entry on Facebook (view in full screen to get better resolution – also turn the volume up) – IMDb Analysis with Microsoft Power BI.

PowerBI Facebook Demo

Action Item (please help and vote – Jan 20 thru 30)

Starting next week on Monday, January 20 the entries will be open for public voting.  I would appreciate all of the support you could provide (please vote, and pass it on to co-workers, family, relatives, family, etc.).  The voting will run through Thursday, January 30.  Then 10 out of the 61 entries will move on the semi-finals!  So I need all of the support you can provide.  Thanks so much!

Advertisements

2 Responses to “IMDb Analysis with Microsoft Power BI”

  1. Paul Purington said

    Great job on this video Dan!

    • denglishbi said

      Thanks. My first attempt at the video was like 20 minutes long and the requirement was 10 minutes or less. The second time I went quite a bit faster, less detail instructions, and with a few edits got it to work for the contest. Made it into the semi-final round, so I was happy. About time to make a few more videos and detail each portion a bit more:)

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

 
%d bloggers like this: