Skip to content

jotstolu/Car-Sales-Analysis---Power-BI-Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 

Repository files navigation

The goal of this project is to create a dynamic and interactive Car Sales Dashboard using Power BI. This dashboard will visualize key performance indicators (KPIs) related to car sales, providing insights into sales performance trends and enabling data-driven decision-making. This project consists of two interactive dashboards:

  • Overview Dashboard
  • Detail Dashboard

Overview Dashboard

The overview Dashboard offers a high-level Visualization of critical KPIs related to car sales using interactive charts and tables. This Provide real-time insights to identify trends, growth opportunities, and areas for improvement, enabling data-driven decision-making.

Screenshot 2025-01-16 032922

1. Sales Overview

The dashboard includes key metrics to track sales performance over different time frames:

  • 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

2. Average Price Analysis

Analyze trends in pricing to evaluate market performance:

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

3. Cars Sold Metrics

Monitor car sales volume to identify demand and growth opportunities:

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

Details Dashboard

The Detail Dashboard focuses on granular data analysis, offering detailed insights into customer name, sales amount, dealer name etc.

Screenshot 2025-01-16 032946

About

The goal of this project is to create a dynamic and interactive Car Sales Dashboard using Power BI. This dashboard will visualize key performance indicators (KPIs) related to car sales, providing insights into sales performance trends and enabling data-driven decision-making.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors