📌 Car Sales Dashboard Project

🧠 Background

The company is a car dealership that sells various car models. To effectively track and analyze our sales performance, we require a comprehensive Car Sales Dashboard in Power BI.

🦪 Objective

The objective of this project is to design and develop a dynamic and interactive Car Sales Dashboard using Power BI. The dashboard will visualize critical Key Performance Indicators (KPIs) related to our car sales, helping us understand our sales performance over time and make data-driven decisions.

📝 Problem Statement 1: KPI’s Requirement

The dashboard should provide real-time insights into key performance indicators (KPIs) related to our sales data. This will enable us to make informed decisions, monitor our progress, and identify trends and opportunities for growth.

⌛ Sales Overview:

• Year-to-Date (YTD) Total Sales
• Month-to-Date (MTD) Total Sales
• Year-over-Year (YOY) Growth in Total Sales
• Difference between YTD Sales and Previous Year-to-Date (PTYD) Sales

⌛ Average Price Analysis:

• YTD Average Price
• MTD Average Price
• YOY Growth in Average Price
• Difference between YTD Average Price and PTYD Average Price

Cars Sold Metrics:

• YTD Cars Sold
• MTD Cars Sold
• YOY Growth in Cars Sold
• Difference between YTD Cars Sold and PTYD Cars Sold

📝 Problem Statement 2: Charts Requirement

The dashboard include various charts to visually represent sales data and trends.

• YTD Sales Weekly Trend: Display a line chart illustrating the weekly trend of YTD sales. The X-axis represent weeks, and the Y-axis show the total sales amount.
• YTD Total Sales by Body Style: Visualize the distribution of YTD total sales across different car body styles using a Pie chart.
• YTD Total Sales by Color: Present the contribution of various car colors to the YTD total sales through a pie chart.
• YTD Cars Sold by Dealer Region: Showcase the YTD sales data based on different dealer regions using a map chart to visualize the sales distribution geographically.
• Company-Wise Sales Trend in Grid Form: Provide a tabular grid that displays the sales trend for each company. The grid should showcase the company name along with their YTD sales figures.
• Details Grid Showing All Car Sales Information: Create a detailed grid that presents all relevant information for each car sale, including car model, body style, color, sales amount, dealer region, date, etc.

🤝 Conclusion

This Car Sales Dashboard project aims to provide a comprehensive overview of our sales performance, allowing us to make informed decisions and drive business growth. By visualizing key metrics and trends, we can identify areas for improvement and capitalize on opportunities in the market.