Car Sales Dashboard – Key Insights (YTD 2023)

974 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

Sales & Revenue Dashboard – Key Insights (Full Year 2022) Free Sales & Revenue

Sales & Revenue Dashboard – Key Insights (Full Year 2022)

1.1k
ConocoPhillips Oil Pipeline Accidents: Key Patterns (2010–Present) – Key Insights Free Sales & Revenue

ConocoPhillips Oil Pipeline Accidents: Key Patterns (2010–Present) – Key Insights

870
Power BI Christmas Sales & Trends Dashboard Template (Free PBIX Download) Free Sales & Revenue

Power BI Christmas Sales & Trends Dashboard Template (Free PBIX Download)

80

Like this site? Share it