Skip to content
Chayan Aggarwal Résumé
All case files
Case 01AcademicCompleted April 2026ITKM-548 final project, team of five, University of Bridgeport

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.

42920161,18820171,64920182,01620191,87920201,4982021*
Titles added per year, movies and TV shows, from the public catalog. The 2021 column covers only January to 25 September.

The chart

  1. 01 / Symptom

    A North American content-strategy lead had a raw export of 8,807 titles and no way to turn it into decisions.

  2. 02 / Tests

    Cleaned the catalog in Excel, derived new fields, and built pivot tables and a seven-chart dashboard with slicers.

  3. 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.

  4. 04 / Prescription

    One business decision per chart, each with a note on how the chart could be misread, in a short executive report.

  5. 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

  1. Cleaned a public Kaggle catalog snapshot: removed duplicates, standardized dates and derived new fields with lookup, logical and text functions.
  2. Built pivot tables for genres, ratings and years, then a dashboard with seven charts, KPI tiles and slicers.
  3. 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.

Links

Next case / 02The model that matched the guess