Back to Portfolio
Power BI · Case Study
Car Sales Analysis
An automotive sales performance dashboard tracking vehicle sales by model, region, dealer, and time period — enabling data-driven inventory and pricing decisions.
📋 Project Overview
Developed a comprehensive car sales dashboard for an automotive dealership network. The solution replaced disconnected regional Excel files with a unified Power BI model tracking sales velocity, inventory age, and dealer performance.
🎯 Objectives
- Unify sales data from 8 regional dealerships into one model
- Track sales by vehicle model, color, trim level, and dealer
- Build inventory aging analysis to flag slow-moving stock
- Compare actual sales vs monthly targets by dealer
📊 Key Findings
🚗
3
Slow Models
3 vehicle models had 90+ day inventory with zero sales traction.
🏆
Top Dealer
2.3x Average
#1 dealer outperformed network average by 130%.
📉
18%
Margin Gap
Luxury segment margin 18% below economy segment.
⚡
30-Day
Avg. Sell Time
Fast-moving SUV models averaging 28 days from arrival to sale.
⚙️ My Process
1
Data Integration
Consolidated 8 Excel files using Power Query append and standardized dealer codes.
2
Inventory Model
Built inventory age calculation using TODAY() minus arrival date DAX measure.
3
Sales Velocity
Created rolling 30-day sales rate per model to forecast stockout risk.
4
Dealer Scorecard
Ranked dealers by revenue, units, and margin on a leaderboard visual.
5
Alert System
Configured conditional formatting to flag inventory >90 days old in red.
💻 DAX Highlights
-- Inventory Age
Inventory Age (Days) =
DATEDIFF('Inventory'[Arrival Date], TODAY(), DAY)
-- 30-Day Sales Velocity
Sales Velocity 30D =
CALCULATE([Units Sold],
DATESINPERIOD('Date'[Date], LASTDATE('Date'[Date]), -30, DAY)
)🏆 Outcomes & Impact
Results Delivered
8
Dealerships
12%
Stock Age Reduction
20%
Performance Lift
- Identified 3 slow-moving models — promotions launched within 1 week
- Dealer benchmarking drove 20% improvement in bottom-quartile performance
- Inventory rebalancing reduced average stock age by 12 days
Interested in Similar Work?
Open to data analyst and dashboard roles. Let's build something impactful together.