Analytics for the Holidays: The Top 30 Christmas Movies in Tableau

Data

Analytics for the Holidays: The Top 30 Christmas Movies in Tableau

“Which is your favorite Christmas movie?” is a question often asked during the holiday season. And an even more convoluted question, “Is Die Hard really a Christmas Movie?” I decided to try and answer those exact questions by quantifying fan sentiment around movie rankings and juxtaposing that against a widely viewed list ranking those films.

IMDv: Internet Movie Data Viz

To start, I used IMDb’s list of the Top 100 Christmas movies and culled those titles down to a top 30. From there, I pulled IMDb’s titles and ranking datasets to build my quantitative comparison. These two sources were joined by Tableau’s data source tool and further refined the top 30 titles to be compared against IMDb’s authored list. By refining the data extract using a data source filter, I was able to drastically improve performance and limit the size of the dataset to the information relevant for my purpose below:

Tableau Viz Christmas movies

After that, I needed an accurate representation of overall fan sentiment and voting engagement by each title. Within the ranking dataset, there are fields for number of votes cast and average rating across the population of votes. By using Average Rating = Total Gross Votes/Number of Votes Cast, I was able to isolate Total Gross Votes in order to give a better representation of both fan engagement and sentiment rather than just total votes or average rating:

Tableau viz Christmas movies

Now that we have our data point, we can now visually arrange the information to see how the fan-sentiment data from IMDb compares to their Top 30 Movies list curated by one of their authors. As you can see, Die Hard wins the day! Maybe it really is the best Christmas movie.

More About the Author

Brooks Barth

Analytics Consultant
Analytics for the Holidays: The Top 30 Christmas Movies in Tableau “Which is your favorite Christmas movie?” is a question often asked during the holiday season. And an even more convoluted ...
Making a Case for Tableau Tooltips As purveyors of analytics, we often come against the buttresses of change aversion. Nowhere is this more prevalent than in the lack of ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072