Car-Sales-Dashprd

Car Sales Dashboard in Power BI

Background

Our company is a car dealership that sells various car models. To effectively track and analyse our sales performance, we need 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 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 will include various charts to visualize the sales data effectively.

YTD Sales Weekly Trend: A line chart illustrating the weekly trend of YTD sales.

YTD Total Sales by Body Style: A pie chart visualizing the distribution of YTD total sales across different car body styles.

YTD Total Sales by Color: A pie chart presenting the contribution of various car colors to the YTD total sales.

YTD Cars Sold by Dealer Region: A map chart to visualize the sales distribution geographically, based on different dealer regions.

Company-Wise Sales Trend in Grid Form: A table displaying the sales trend for each company, including company name and YTD sales figures.

Details Grid Showing All Car Sales Information: A detailed table presenting all relevant information for each car sale, including car model, body style, colour, sales amount, dealer region, date, etc.