Overview
This project built a dynamic, interactive Power BI dashboard to track and analyze car dealership sales performance across 2022–2023, enabling data-driven decision-making at every level of the organization.
Key Metrics Tracked
- YTD Total Sales vs PTYD: Year-to-date revenue compared against previous year to measure real growth, not just seasonal spikes
- MTD Sales Monitoring: Month-level granularity for identifying which periods drive or drag performance
- Average Price Analysis: YOY growth in average transaction value — revealing whether growth comes from volume or premium positioning
- Cars Sold Metrics: Unit economics separated from revenue to distinguish pricing power from market demand
Key Findings
- Body Style Impact: SUVs and sedans dominated revenue but hatchbacks showed highest YOY growth rate — a leading indicator of shifting consumer preference
- Regional Variation: Some dealer regions showed strong unit growth but declining average price, indicating aggressive discounting that may erode margins
- Color as Signal: Premium colors (metallic, pearl) correlated with higher transaction values independent of vehicle class — a low-cost upsell opportunity
- Pricing Strategy Split: High-volume dealers outperformed in 3/5 regions; premium-positioned dealers dominated in high-income urban areas
Dashboard Architecture
Two complementary views designed for different user needs:
- Overview Dashboard: Executive-level KPI cards, YTD weekly trend lines, sales by body style/color/region — answers "how are we doing?" in 10 seconds
- Details Grid: Granular transaction-level data with filtering — answers "why?" when executives drill deeper
Methodology
- Data verification for missing values and anomalies (resolved inconsistencies in date formats and dealer codes)
- Ensured data consistency across types, formats, and categorical values
- Built star-schema data model in Power BI for optimal query performance
- Created DAX measures for YOY comparison, running averages, and conditional formatting