Power BI challenge 1 Completed
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
  1. Library Overview: Analyzed a total of 8,807 titles across Netflix's global catalog.
  2. Content Mix Ratio: The content is heavily movie-oriented—comprising 69.60% Movies (6,131 titles) versus 30.38% TV Shows (2,676 titles).
  3. Geographic Dominance: The United States (2.8K+) and India (~1K) lead content contributions by a wide margin.
  4. 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.
  5. 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! 🎯
3
3 comments
Atia Zahid
3
Power BI challenge 1 Completed
powered by
Power BI Training
skool.com/power-bi-training-6284
Power BI community for serious learners | Live sessions | DAX | Power Query | Real projects
Build your own community
Bring people together around your passion and get paid.
Powered by