Move over Winter Olympics at Sochi—it’s time for the 86th Academy Awards! While we roll out the red carpet, what better time to step behind the scenes and into Microsoft Power BI to create some visual effects on the most significant movie awards of the year?
We tapped into Wikipedia data for historic nominees and winners over the years, The Numbers for budget and box office information, Bing for search data, and IMDb for ranks and ratings. When it came to importing, merging, and shaping data from so many sources, Power Query was our trusty assistant.
From all of that, here are some interactive Power View dashboards that you can explore.
Now, we’ll feature some interesting points related to search volume for movies, actors, and actresses:
Because our audience may be interested in the financial side of movies, we wanted to answer the question: “How much does an Oscar cost?” By relating budget data to historic performances, we created a dashboard that shows the average price of an Oscar by decade since the 1920s and how it’s going up. With a few exceptions, it is becoming quite expensive to make a winner!
Before we cut to a Power Map tour that shows the history of the award for Best Foreign Film since 1947, the merit award for Best Business Intelligence Tool goes to….
Nice, anonymous access to power view sheets? Any idea when this functionality / type of user will be available?
+1 on Ian's question. Would love to embed one of these in our corporate blog....
Judging by the source code, they've embedded an iFrame to pull from a PowerBI site.
<p><iframe style="border-width: 1px; border-color: #bbb; border-style: solid;" src="www.microsoft.com/.../template.html" frameborder="" scrolling="no" align="middle" width="696" height="588"></iframe></p>