Case Study · Power BI

Pixar by the Numbers

Tools Power BI, DAX
Type Portfolio Dashboard
Pages 4 report pages
Year 2026

The approach

The goal was to build something beyond a class requirement — a dashboard I could actually use in my portfolio. Instead of a generic report, I themed the entire project around Finding Nemo, using a consistent ocean blue and orange palette across all four pages.

The report is structured to tell a cohesive data story. Each page builds on the previous one: starting with a high-level overview, diving into the financial details, then stepping back to ask what actually makes a Pixar film successful beyond just box office numbers.

Data Storytelling Financial Analysis DAX Measures Star Schema UX Design

Key numbers

28
Total Pixar films analyzed
$17.04bn
Total worldwide box office
7.54
Average IMDb score
17
Oscar wins across all films

What the data showed

Inside Out 2 was the single most profitable film in Pixar's history at $1.5bn worldwide. Early films like Toy Story delivered ROI exceeding 1,000% due to modest production budgets — but as costs scaled, returns normalized across the catalog.

Only three films lost money: Onward, Soul, and Luca. All three were COVID-era releases redirected to Disney+ instead of theaters, making them outliers in any ROI analysis rather than signals of creative failure.

On the ratings side, critics consistently score Pixar higher than audiences — Rotten Tomatoes averages 95+ while IMDb averages around 75 to 80 on a scaled basis. Higher ratings do correlate with box office performance, but Oscar wins don't guarantee commercial success. Soul and WALL-E both won two Oscars but underperformed at the box office, suggesting audiences respond more to broad appeal than critical recognition.

Assumptions and data notes

Luca had no budget data available in the source dataset, which was flagged as a gap in the financial analysis. COVID-era films were treated as outliers in ROI calculations given their unconventional release strategy. IMDb scores were scaled by a factor of 10 to allow direct comparison with Rotten Tomatoes scores on the same axis.

View live dashboard Back to portfolio