Reading a streaming library as a strategy
An Excel dashboard that reads 8,807 Netflix catalog titles as evidence of content strategy, with a business decision attached to each chart.
The chart
01 / Symptom
A North American content-strategy lead had a raw export of 8,807 titles and no way to turn it into decisions.
02 / Tests
Cleaned the catalog in Excel, derived new fields, and built pivot tables and a seven-chart dashboard with slicers.
03 / Diagnosis
Movies are 69.6% of the library, but TV's share of yearly additions rose from 25% in 2018 to 34% in 2021. An apparent 2021 drop was the data ending in September, not a real decline.
04 / Prescription
One business decision per chart, each with a note on how the chart could be misread, in a short executive report.
05 / Outcome
An interactive dashboard and executive report, presented live in April 2026. The data shows supply, not viewing, so no revenue impact is claimed.
How the tests ran
- Cleaned a public Kaggle catalog snapshot: removed duplicates, standardized dates and derived new fields with lookup, logical and text functions.
- Built pivot tables for genres, ratings and years, then a dashboard with seven charts, KPI tiles and slicers.
- Paired each chart with a recommendation and a note on how it could be misread, in a short executive report and a live presentation.
Tools
- Microsoft Excel
- Pivot tables
- Slicers
- PowerPoint
Findings
69.6%
of titles are movies
25% → 34%
TV share of yearly additions, 2018 to the first nine months of 2021
Additions look like they fall in 2021, but the data stops on 25 September. At that pace, 2021 was close to 2019.
Limits
- The dataset is a catalog snapshot with no viewing, subscriber or revenue data. It shows what Netflix offers, not what audiences watch.