Pixar Films Performance Dashboard
The Pixar Films Performance Dashboard was designed to analyze and visualize the financial performance, critical reception, and audience response of Pixar movies. The dashboard serves both as an exploratory tool for data enthusiasts and as a visually engaging presentation for Pixar fans and stakeholders. The report is fully interactive and includes custom visuals, KPI cards, drilldowns, tooltips, and storytelling elements based on real Pixar films' data.
🎯 Project Overview
In this project, I analyzed Pixar Studios' movie data to uncover patterns in financial performance, production trends, and audience reception. The main goal was to deliver actionable insights regarding the studio's movie successes, production strategies, and market positioning over time.
💡 Result
The purpose of a dashboard is to view the most important KPIs and results at a glance. Dashboards are an interactive way to see how the company or project perform.
📁 Dataset
The dataset contains information about Pixar's full-length movies:
- 🎬 Movie Title
- 📅 Release Year
- 💰 Production Budget
- 💸 Box Office Revenue (Domestic & Worldwide)
- ⭐ IMDb Rating
- 🍅 Rotten Tomatoes Scores (Critics & Audience)
- ⏰ Running Time
- 🟣 Calculated ROI (Return on Investment)
🧩 Additional Information
This project delivers a comprehensive performance analysis of Pixar films, combining financial, audience, and award data into a unified interactive dashboard. The solution offers valuable insights through dynamic charts, KPI indicators, and filterable data tables. It not only highlights Pixar's box office success and audience reception patterns but also showcases the ability to transform complex datasets into meaningful, business-oriented visualizations.
📊 Dashboard Overview
The interactive Power BI dashboard presents an insightful analysis of Pixar films' financial performance, showcasing:
- Total Profit, Budget, ROI, and Box Office Gross (KPI cards).
- Worldwide Box Office Trends Over Time (line chart), highlighting changes in film profitability.
- Top 5 Most Profitable Pixar Films (bar chart), clearly identifying best-performing titles.
- The design is inspired by Pixar's vibrant visuals, ensuring clarity and engagement.
Test
Lorem Ipsum
is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
🏆 Awards&Oscars
This dashboard showcases Pixar's historical performance at the Oscars, featuring:
- Key metrics: Best nomination year, total Oscars won, and total nominations.
- Awards Won by Category (Donut Chart) – visualizes the distribution of Oscar wins by award category.
- A detailed table of award nominations and outcomes enables a more profound exploration of each film's history of recognition.
- Timeline of Total Awards Won vs. Nominations – illustrating Pixar's award trajectory over time.
- This visualization highlights Pixar's critical success and recognition patterns within the film industry.
🎟️ Box Office Analysis
This dashboard delivers a comprehensive analysis of Pixar’s financial performance at the box office, including:
- Total Revenue by Director – highlighting the directors whose films achieved the highest gross revenues.
- Film Profitability Ranking – identifying top-performing Pixar films by total profit.
- ROI Metrics – showcasing Return on Investment, including the film with the highest ROI.
- Budget vs Profit Analysis – visualizing each film’s financial efficiency, clearly comparing production budgets against earned profits.
- These insights reveal Pixar's strongest financial performers and highlight trends that have influenced the studio's strategic decisions over the years.
🎬 Public Response
This dashboard analyzes audience reactions to Pixar films, featuring:
- Top 10 Pixar Films ranked by IMDb and Rotten Tomatoes Audience Scores.
- Audience CinemaScore Ratings – a visual summary of initial audience impressions, showcasing strong positive feedback.
- Key Average Scores – IMDb, Rotten Tomatoes Audience, and Metacritic ratings to indicate overall public perception.
- The insights clearly demonstrate Pixar's consistent success in audience engagement and highlight films such as Toy Story, Coco, and Up as standout favorites.
💡 Recommendations
Based on insights derived from the analysis, several strategic recommendations were formulated to guide Pixar's future projects:
Budget Optimization
Invest in story-driven films that historically achieve high ROI, balancing production costs and audience expectations.
Audience Engagement
Continue leveraging beloved franchises (Toy Story, Coco) that consistently receive high audience ratings across various platforms.
Award Strategy
Focus promotional efforts and campaigns during peak award seasons to maximize nominations and wins.
These recommendations aim to maintain Pixar's strong market position and enhance future film performance.