Box Office Profitability

Description

The goal of this analysis is to inform a mock production company on what strategy to adopt when making a new movie. We looked at box office data of successful movies in the past 10 years to identify trends to guide our recommendations.

External Links

arrow

Tasks

  • Addressed missing data in a public movie dataset by collecting and preparing 2,000+ The Movies Database records with Python (Pandas) to support teammates' analyses.
  • Analyzed profitability trends across film genres, using Excel's pivot tables and Tableau's scatterplots to uncover relationships between budget, revenue, and ROI.
  • Presented on optimal genres for varying budget levels, projecting an ROI increase of 40% for low-budget films and 20% for high-budget films.

Tools

Microsoft Excel
Tableau
Python

View Media

Report

Explore the Data!

For the best experience, please use a desktop to see the dashboard!

View Deliverables!

slide