Car Sales Dashboard – Key Insights (YTD 2023)

976 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

Retail Supply Chain & Sales Analysis dashboard Free Sales & Revenue

Retail Supply Chain & Sales Analysis dashboard

1.4k
ExxonMobil Oil Pipeline Accidents Dashboard (2010–Present) – Key Insights Free Sales & Revenue

ExxonMobil Oil Pipeline Accidents Dashboard (2010–Present) – Key Insights

921
Power BI North America Retail Supply Chain & Sales Analysis Dashboard Template (Free PBIX Download) Free Sales & Revenue

Power BI North America Retail Supply Chain & Sales Analysis Dashboard Template (Free PBIX Download)

81

Like this site? Share it