Power BI Portfolio – Turning raw data into stunning, interactive stories!
Showcasing end-to-end skills in data cleaning, transformation, advanced modeling, DAX wizardry, and colorful dashboard magic. 🌟
"What’s Netflix really watching us watch?" 🕵️♂️
- Dataset: A massive 4,227-title Netflix catalog (2,687 movies 🎞️ + 1,540 TV shows 📺) from 2015–2020.
- Data Magic Performed ✨:
- Cleaned messy fields: tackled 1,538 missing directors, ~480 missing casts, and 391 missing countries 🧹
- Parsed dates, split genres, and normalized durations (minutes vs. seasons) ⏱️
- Transformed raw CSV into a polished analytical model with Power Query superpowers ⚡
- Juicy Insights & Eye-Candy Visuals 🔥:
- Explosive growth timeline of content additions 📈
- Movies vs. TV Shows showdown 🥊
- Top countries dominating the scene: 🇺🇸 USA, 🇮🇳 India, 🇬🇧 UK leading the pack 🌍
- Rating breakdown – TV-MA reigns supreme 😈
- Movie length trends & TV season counts 📏
- Genre explosion: Comedies, Dramas, International hits, and hidden combos 🔍
- Tools & Tricks: Power Query ETL, DAX measures, slicers that feel like Netflix browsing, vibrant cards, bar/line charts, and world maps 🌈
"From kitchen chaos to business brilliance" 👨🍳📊
- Mission: Built a rock-solid star schema for restaurant orders to unlock lightning-fast insights ⚡
- Modeling Mastery 🏗️:
- Central Fact Table (Orders) surrounded by shiny Dimension Tables: Customers 👥, Menu Items 🥗, Date/Time 🗓️, Dietary Preferences 🌱, Staff & Branches 🏪
- Perfect one-to-many relationships with full integrity ✅
- DAX measures for averages, trends, and KPIs 💪
- Delicious Insights Served Hot 🔥:
- Prep time deep dive by diet type (vegan 🌿 vs. gluten-free 🚫🌾)
- Peak rush hours and busiest days ⏰
- Top-selling dishes and category winners 🏆
- Dietary trends over time – is kale still king? 🥬
- KPIs galore: average prep time, order volume, revenue breakdowns 💰
- Tools & Tricks: Star schema design, time intelligence, drill-through pages, tooltips, conditional formatting, and color themes that pop! 🎉
These projects prove I can take messy data, sprinkle some Power BI magic, and deliver beautiful, insightful, and interactive dashboards that drive real decisions! 🚀
If these dashboards made you smile 😄, inspired your next project, or you need custom Power BI solutions – I'm here to help!
- Buy Me a Coffee (or Data!) ☕: Donate via PayPal → [email protected]
- Need Insights, Dashboards, or Training? 📩: Hit me up on WhatsApp → +254702896107
Your support fuels more colorful dashboards and free knowledge sharing! 🌍✨ Thank you! 🫶