I’m excited to share my latest Business Intelligence project with the community! 📊
This assignment was all about adopting an Executive Analyst mindset—exploring raw data, handling data transformations, uncovering key insights, and designing an intuitive two-page dashboard without relying on predefined specs. I approached it as a real-world case: analyze first, then deliver what truly drives decision-making.
🧠 Executive Summary & Key Insights
- Library Overview: Analyzed a total of 8,807 titles across Netflix's global catalog.
- Content Mix Ratio: The content is heavily movie-oriented—comprising 69.60% Movies (6,131 titles) versus 30.38% TV Shows (2,676 titles).
- Geographic Dominance: The United States (2.8K+) and India (~1K) lead content contributions by a wide margin.
- Maturity & Audience Targeting: TV-MA and TV-14 constitute the vast majority of the catalog, showing a strong strategic tilt toward young adult and mature audiences.
- Historical Growth Trend: Catalog additions surged exponentially post-2015, reaching peak expansion between 2018 and 2020.
🛠️ Data Engineering & Power Query Transformations
Before building visuals, I focused on rigorous data preparation:
- Attribute Splitting: Split the duration column into numerical duration_value and text duration_unit (e.g., Minutes vs. Seasons) to enable flexible filtering and accurate table aggregation.
- Missing Value Handling: Replaced null values across key dimensions (director, country, cast) with descriptive placeholders like Unknown Country to maintain reporting integrity.
- Dedicated Measures Table: Created a dedicated DAX measure repository to maintain clean model organization.
📊 Dashboard Architecture
I structured the solution into a 2-Page Executive Dashboard:
Page 1: Executive Summary & Growth Trends
- KPI Cards: Instant high-level metrics (Total Titles, Movies, TV Shows).
- Interactive Slicers: Dynamic toggles for seamless cross-filtering by content type.
- Geographic & Category Distribution: Horizontal bar charts highlighting top contributing countries and genres (Dramas, Documentaries, Comedies).
- Historical Trendline: A dual-line chart tracing content additions from 1925 to 2021.
Page 2: Category Breakdown & Granular Data Grid
- Genre Dominance: A structured Treemap visualizing genre proportions by volume.
- Content Split KPIs: Distinct Percentage Cards reflecting the precise Movie vs. TV Show ratio.
- Rating Distribution: A Donut Chart breaking down content maturity ratings.
- Detail Data Grid: A clean, un-summarized tabular layout featuring exact titles, release years, ratings, durations, and genres for deep-dive investigation.
💬 Feedback Welcome!
I would love to hear feedback from Teacher Muhammad Asif and the community, particularly on:
- Dashboard visual hierarchy and storytelling flow
- Color harmony and spatial alignment
- KPI selection and DAX modeling choices
Thank you to everyone in the community for the continuous inspiration and support. Onto the next challenge! 🎯