REPORT_VIDEO.mp4
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 KPIs related to our car sales, helping us understand our sales performance over time and make data-driven decisions.
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
Charts Requirement
- YTD Sales Weekly Trend: A line chart illustrating the weekly trend of YTD sales.
- YTD Total Sales by Body Style: Distribution of YTD total sales across different car body styles using a Pie chart.
- YTD Total Sales by Color: 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: Tabular grid that displays the sales trend for each company.
- Details Grid Showing All Car Sales Information: detailed grid that presents all relevant information for each car sale, including car model, body style, colour, sales amount, dealer region, date, etc