Activity
Mon
Wed
Fri
Sun
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
What is this?
Less
More
AI SquadX
9.9k
Free
11 contributions to Power BI Training
Excel VBA Automation
Asslam o aliakum sir session 5 kb upload hoga?
2
0
Assigment 9&10
Excel VBA Automation done
1
0
Excel VBA automation
Aslam o alikum jo class Saturday ko hoe ti uski recording ni mill rhi Kindly koi provide kr sakta hai uska link
3
0
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.
Power BI challenge 1 Completed
1 like • Jul 29
Thanku Sir
1-10 of 11
Atia Zahid
3
37 points to level up
@atia-zahid-1118
Passionate to learn new things

Active 46d ago
Joined May 24, 2026