BMW Global Sales Analytics Dashboard

📸 Dashboard Preview

🌍 Sales Overview

📊 Model Performance

🏗️ Project Architecture

• 🔄 Data Extraction: Import BMW global sales CSV
• 🧹 Data Cleaning (Python/Excel): Handle missing records, standardize columns, and preprocess sales data
• 🗃️ Data Modeling (Power BI): Create relationships between sales, regions, models, and dealer networks
• 📊 Visualization (Power BI): Build dashboards for trends, KPIs, and comparisons

✨ Key Features

• 🚗 Model-wise Sales Breakdown: Track revenue, units sold, and growth for each BMW model
• 🌍 Geographic Insights: Regional and country-level performance mapping
• 🏬 Dealer Analysis: Top-performing dealers and market penetration
• 📈 Time-Series Trends: Monthly/quarterly sales trajectory with YoY comparisons
• 🏷️ Profitability & Revenue Insights: Contribution of premium vs. standard models
• ⚡ Interactive Filters: Dynamic drilldowns by year, region, or vehicle model

🛠️ Tech Stack

📂 Dataset Overview

• Sales Figures: Units sold, revenue, profit margins
• Geographical Data: Sales by region, country, and city
• Dealer Information: Dealer locations, sales volume, and rankings
• Model Data: Vehicle categories, model details, and price points
• Time Series: Monthly and quarterly sales records over multiple years

🔗 Useful Links

• GitHub Repository
• Power BI Official
• Pandas Documentation
• Python Official Site