This project presents a Tableau dashboard that visualizes and analyzes car sales performance (2020–2021) across multiple business dimensions — including time, region, body style, color, and manufacturer.
The goal is to provide a clear, interactive view of overall sales performance, help stakeholders monitor YoY growth, and identify the key contributors driving total revenue.
Below is the main view of the Tableau dashboard:
| Metric | Value | Insight |
|---|---|---|
| YTD Total Sales | $371.19 M | Represents total revenue; 23.59 % YoY growth shows strong recovery post-pandemic. |
| YTD Cars Sold | 13.26 K units | Indicates 24.57 % YoY increase — volume growth aligns with revenue trend. |
| YTD Avg. Price | $27.99 K | Slight -0.79 % YoY dip, suggesting higher unit sales achieved through moderate discounting or shift toward lower-priced models. |
- The weekly trend shows consistent growth, peaking near week 48 ($15.53 M) — suggesting strong year-end sales activity (holiday promotions or clearances).
- The lowest sales (~$0.30 M) occur early in the year, possibly reflecting early-quarter slowdowns or pandemic impact.
- Overall, the trend indicates sustained market recovery and effective demand generation.
| Body Style | Total Sales |
|---|---|
| SUV | $99.89 M |
| Hatchback | $82.77 M |
| Sedan | $73.69 M |
| Passenger | $63.44 M |
| Hardtop | $51.40 M |
Insight: SUVs lead with the highest revenue share (~27%), showing a clear preference among customers. Hatchbacks and Sedans perform steadily as value-focused options.
| Color | Total Sales |
|---|---|
| Pale White | $174.53 M |
| Black | $125.24 M |
| Red | $71.41 M |
Insight: Neutral colors dominate the market, accounting for over 80% of total sales — indicating customer preference for classic tones.
Top-performing regions by sales:
| Region | Manual Sales | Automatic Sales | Total |
|---|---|---|---|
| Austin | $31.04 M | $34.00 M | $65.04 M |
| Janesville | $28.72 M | $30.01 M | $58.73 M |
| Scottsdale | $25.88 M | $27.54 M | $53.42 M |
| Aurora | $23.71 M | $25.49 M | $49.20 M |
Insight: Austin leads in both sales volume and total revenue, followed closely by Janesville and Scottsdale — indicating high-performing markets.
| Company | Cars Sold | Avg. Price | Total Sales | % of YTD Total |
|---|---|---|---|---|
| Chevrolet | 1.04 K | $25.99 K | $27.11 M | 7.30 % |
| Ford | 0.89 K | $28.70 K | $25.43 M | 6.85 % |
| Dodge | 0.95 K | $26.36 K | $25.02 M | 6.74 % |
| Oldsmobile | 0.62 K | $31.56 K | $19.53 M | 5.29 % |
| Mercedes-B | 0.71 K | $26.65 K | $19.03 M | 5.13 % |
| (Others: Mitsubishi, Volkswagen, Toyota, Chrysler) | — | — | — | — |
Insight: Chevrolet dominates overall sales, while Ford and Dodge maintain competitive performance. Luxury brands like Mercedes and Oldsmobile have higher average prices but smaller volumes.
- Focus on SUVs and Hatchbacks as they contribute most to total revenue.
- Capitalize on regional leaders such as Austin and Janesville through targeted marketing campaigns.
- Monitor pricing trends to avoid erosion of average selling price while maintaining growth.
- Invest in high-margin models and expand the product mix for growing demand in electric and hybrid categories.
| Category | Tools Used |
|---|---|
| Data Source | Microsoft Excel |
| Visualization | Tableau Desktop & Tableau Public |
| Data Preparation | Excel Power Query |
| KPIs | Total Sales, Units Sold, Average Price, YoY Growth, Regional Performance |
You can interact with the live dashboard here:
🌐 View on Tableau Public
Shubham Kulkarni
Data Science & ML | Business Analytics | Visualization
🔗 LinkedIn • GitHub
This project is released under the MIT License — feel free to use or extend it for learning and research.
⭐ If you found this dashboard useful, give it a star on GitHub! 🌟