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.