The Pixar Dataverse: Insights Beyond the Screen

Pixar has created some of the most beloved animated films, but how do they perform beyond the big screen? This project analyzes box office revenue, ratings, awards, and trends to uncover what makes a Pixar movie successful.

🔍 Key Insights:

• Do sequels generate higher revenue? Comparing the budget vs. gross earnings of originals vs. sequels to identify trends in profitability.
• Budget Efficiency: Are sequels more cost-effective, or do they require significantly higher budgets than their original counterparts?
• Award Performance: Which Pixar films and directors have won the most awards, and does critical acclaim impact revenue?
• Pixar’s Revenue Over Time: Analyzing Pixar’s box office trends, identifying peak years, and understanding its downfall in recent years.
• Handling Missing Data: The budget for Luca was missing in the dataset. Instead of ignoring it (which could impact analysis), I conducted market research to impute a reasonable estimate, ensuring data accuracy.

📊 Power BI & DAX Implementation:

To create an insightful and dynamic report, I used key DAX functions in Power BI, including:

• CALCULATE – For dynamic filtering and aggregations.
• SELECTEDVALUE – To allow users to filter movies interactively.
• FILTER – To segment movies into originals vs. sequels based on predefined logic.
• RANKX – To rank movies based on box office earnings and awards won.
• SUMX & AVERAGEX – To compute aggregated financial performance.
• DIVIDE – To calculate profit margins while handling division errors.
• ALL – To remove filters and compare trends across all Pixar films.
• CONCATENATEX – To list all awards won per movie in a single field.

🚀 Impact:

This interactive report provides data-driven insights into Pixar’s storytelling evolution, highlighting whether sequels outperform originals financially and critically. It helps studios, marketers, and analysts understand trends that influence movie success.