Dan English's BI Blog

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

Posts Tagged ‘movies’

Power BI–Marvel vs DC Movie Analysis

Posted by denglishbi on February 24, 2016

Back in January Microsoft held it’s second community Power BI contest for Best Report Contest. After a few weeks of brainstorming and sifting through data I finally came to a conclusion that I wanted to do some analysis on a couple of items that I like, movies and super heroes, so why not take a look at how Marvel and DC movies have faired over the years:)

This is an interactive report comparing the results of Marvel versus DC movie information with regards to the number of movies, adjusted worldwide gross box office earnings, and includes IMDb ratings. You can get a feel for the shift from the 1960’s through the 1990’s as DC dominated the market and then Marvel stepped in and has dominated the box office since.

Will DC regain its focus and dominance that it once had? Batman v Superman could be a start and that is where its roots are from and then later this year with Suicide Squad it can gain some more momentum. Maybe next year with Justice League and Wonder Woman it will find new life and something to compete with Avengers, Guardians of the Galaxy, and X-Men. You will see in the insights that keeping the movie rating at a PG-13 level is key, these movies will average 4x more than an R rated movie will gross.

Sorry Marvel, Deadpool is not looking good for earnings, but you will make up for it with Captain America Civil War which should make 5x as much! (this comment was made on Jan 29, prior to Deadpool opening up at the box office)

image

This report showcases and highlights a bunch of features in Power BI, integrating multiple data sources, calling a web service, cards, charts, drill down, custom visuals, slicers, color definition, back ground images, and more!

Here were some of the insights I discovered while exploring this data:

– From 1960 to 1990 DC dominated making 86% of movies and grossed $4.54B more than Marvel movies

– From 2000+ Marvel has made 80% of the movies and grossed $15B more than DC

– R rated movies average $446M less than PG-13 movies

– Marvel movies average $60 to $90M more than DC movies

– Marvel/DC: stick to Avengers and Justice League characters! They make more money;)

Another insight that I was curious about was why Iron Man 3 was so popular and grossed so much money.  I mentioned this to my wife and she quickly asked, “Well did it come out after the Avengers movie?”  I switched back to my Power BI report…well “Yes it did, that is brilliant!” So follow up the movies with more spinoffs, kind of like DC will do next year with Wonder Woman.

Here is my video showcasing my Power BI Best Report Contest Entry, unfortunately I did not make it into the Top 10 for the voting process.

If you want to check out the Top 10 finalists they are all posted here and I believe at some point they will be adding all of the entries into the public showcase area as well.

And I guess Deadpool is defying the odds and proving everyone wrong, after two weeks in the box office it has already beat out the best X-Men movie here in the US and has grossed nearly $500M globally. Not bad for a movie they spent $58M on to make, plus it was banned in China.  So I guess maybe making the next Wolverine move Rated R might work out okay.

After Less Than Two Weeks, Deadpool Is Already the Biggest X-Men Movie Ever

After Less Than Two Weeks, Deadpool Is Already the Biggest X-Men Movie Ever

As of February 22, Deadpool has grossed almost $236 million in the United States, according to Box Office Mojo. During its entire run, the previous #1 X-film, X-Men: The Last Stand, grossed just over $234 million.

I hope you enjoyed this, now I have to figure out what else to check out with Power BI!

Advertisements

Posted in Power BI | Tagged: , , | 4 Comments »