Car Sales Dashboard – Key Insights (YTD 2023)

958 Downloads
Car Sales Dashboard – Key Insights (YTD 2023)
Share template with others
Description

Overall Performance (YTD)

  1. Total Sales Revenue: $371.2M ↑ +23.59% YoY
  2. Total Cars Sold: 13.3K ↑ +24.57% YoY
  3. Average Selling Price: $28.0K ↓ –0.79% YoY (slight price erosion despite strong volume growth)

Top Performing Brands (by YTD Cars Sold & Revenue)

RankBrandCars SoldAvg PriceRevenue% of Total Sales
1Chevrolet1,043$26.0K$48M7.30%
2Dodge949$26.4K$47M6.74%
3Ford886$28.7K$47M6.85%
4Volkswagen718$25.4K4.91%
5Mercedes-Benz714$26.7K$35M5.13%

Body Style & Color Preferences

  1. Dominant Body Style: SUV is by far the most popular, followed by Hatchback and Sedan.
  2. Top Colors Sold: Pale White, Black, and Red dominate the market.

Sales Trend

  1. Weekly YTD sales show strong, consistent growth from ~$5M/week to a peak of ~$25M in the final weeks — indicating heavy Q4 seasonality and successful year-end push.

Month-to-Date (MTD) Snapshot

  1. MTD Total Sales: $54.28M
  2. MTD Avg Price: $28.26K
  3. MTD Cars Sold: 1.92K

**Key Takeaways

  1. Very strong volume-driven growth (+24.6% units, +23.6% revenue) despite a marginal drop in average price.
  2. Chevrolet, Dodge, and Ford are clear market leaders in unit volume and revenue contribution.
  3. SUVs continue to dominate buyer preference.
  4. Heavy Q4 concentration suggests successful promotional/seasonal campaigns at year-end.

Recommendation

Maintain aggressive Q4 momentum, explore mild price increases on high-demand SUVs, and replicate Chevrolet/Dodge playbook across slower brands (Volkswagen, Toyota) to capture more share.


The dashboard is designed using Flexa Design, Flexa Tables, and Flexa Charts from Flexa Intel.


Other Templates

Power BI Financial Analysis Dashboard Template (Free PBIX Download) Free Finance & Accounting

Power BI Financial Analysis Dashboard Template (Free PBIX Download)

97
Power BI Executive Overview Dashboard Template — Global Sales & Profit Target Tracking (Free PBIX Download) Free Sales & Revenue

Power BI Executive Overview Dashboard Template — Global Sales & Profit Target Tracking (Free PBIX Download)

91
PetroChina Global Energy: Oil Production Report – Key Insights (1991–2024) Free Operations & Production

PetroChina Global Energy: Oil Production Report – Key Insights (1991–2024)

821

Like this site? Share it