Dan English's BI Blog

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

Archive for January, 2014

Voting is now live! Please vote for Power BI Contest

Posted by denglishbi on January 20, 2014

Voting is now open for the Power BI Contest, please go out and vote today!  You can vote from today, Jan 20, through next Thursday, Jan 30 (once per day).

If you go to my entry you can click below the video (big blue section that says ‘VOTE FOR THIS ENTRY’ between Previous and Next).

click here to vote

https://fb-3785439.strutta.com/entry/5476486

Don’t forget to vote once per day and appreciate any help you can do in sharing this with family, co-workers, and friends!

Thanks again for your support!

Posted in News and politics | Tagged: , , | Leave a Comment »

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!

Posted in Data Explorer, Power BI, Power Query | Tagged: , , | 2 Comments »