🚗 Car Sales Dashboard – Tableau Project

🎯 Project Objective:

The objective of this project is to design and develop a dynamic and interactive Car Sales Dashboard using Tableau. The dashboard visualizes critical KPIs related to car sales, helping stakeholders understand performance trends over time and make informed, data-driven decisions.The dashboard should provide real-time insights into key performance indicators (KPIs) related to our sales data.

📊 Key Insights Visualized:

1. Total YTD Sales: $371.19M with 23.59% YoY growth
2. Average Car Price: $27.99K
3. Total Cars Sold: 13.26K units with 24.57% YoY growth

Sales Breakdown by:

1. Weekly Sales Trend
2. Body Style (e.g., SUV, Sedan, Hatchback)
3. Car Color (e.g., Pale White, Black, Red)
4. Dealer Region (Manual vs Auto transmission)
5. Company-wise Sales Trends

🔍 Filters & Interactivity:

1. Date Range Selector 2.Transmission Type
2. Body Style
3. Engine Type
4. Customer Gender

💡 Purpose:

This dashboard provides a consolidated view of car sales performance and customer preferences. It supports sales managers, analysts, and business decision-makers in identifying:

a) High-performing vehicle types and regions

b) Market trends and seasonality

c) Opportunities for improving sales strategies

🛠️ Tools Used:

Tableau Public (for dashboard creation)

Excel/CSV (for data preparation & cleaning)

Dashboard link: https://public.tableau.com/views/CarSales_dashboard/Dashboard1?:language=en-GB&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link