Pri-OA/RegalEme-Cars-Sales-Dashboard-Business-Intelligence-Project-Aug-2025-

End-to-end BI dashboard built with Power BI and Excel to analyze automotive sales performance across Ghana and Nigeria, delivering actionable insights for data-driven decision-making. # RegalEme-Cars-Sales-Dashboard--Excel & Power BI Project #2 · Built in August 2025 · Data Analysis & Business Intelligence Power BI & Excel | Car Dealership Analytics | Ghana & Nigeria ## 📌 Project Overview An end-to-end business intelligence project analysing car dealership sales performance across Ghana and Nigeria — covering 218 transactions, 10 dealers, 15 car models, and 12 months of data. The goal was to uncover sales trends, regional performance differences, and product insights that could help dealership managers make better decisions. ## 📊 Dashboard Pages PageTitlePurpose1OverviewExecutive KPIs, monthly trend, H1 vs H2 growth2ProductsRevenue by brand, segment, fuel type & top models3RegionsGhana vs Nigeria, city map, dealer rankings ## 🔍 Key Insights - 💰 $9.1M total revenue · $1.1M profit · 350 units sold - 📈 H2 revenue grew +49% vs H1 ($3.7M → $5.5M) — a strong second-half surge - Ghana led all metrics — $5M in revenue, H2 grew a massive +95% vs H1 - Nigeria was consistent — steady performance across both halves (+9% H2 growth) - 🚙 SUVs were the top segment across both markets - ⛽ Petrol vehicles made up 68% of all sales ## 🛠️ Tools & Skills Used ### Excel - Data cleaning and structuring - Formula building and data validation - Source data preparation for Power BI ### Power BI -Star schema data modelling (Sales fact table + Dealers & Models dimension tables) -DAX measures — including: 1. Revenue, Profit, Qty, Total Sales Count 2. Revenue H1, Revenue H2, Revenue H2 vs H1 Growth % 3. Profit H1, Profit H2, Profit H2 vs H1 Growth % 4. MTD, YTD, Running Total - Calendar table for time intelligence - Interactive slicers and cross-filtering - Dark-themed dashboard design (canvas: #0d0d11, accent: #EF9F27) ## 🖼️ Dashboard Preview Page 1 — Overview Page 2 — Products Page 3 — Regions ## 💡 What I Learned - How to structure a proper star schema data model in Power BI - Writing DAX time intelligence measures for within-year anal …