Project - 1

CAR  SALES DASHBOARD

Problem Statement – 1

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.

1. Sales Overview:

  • Year-to-Date (YTD) Total Sales
  • Year-over-Year (YOY) Growth in Total Sales

2. Average Price Analysis:

  • YTD Average Price
  • YOY Growth in Average Price

3. Cars Sold Metrics:

  • YTD Cars Sold
  • YOY Growth in Cars Sold

Solution -1

1. Sales Overview:
I. Year-to-Date (YTD) Total Sales
SUM(IF 
YEAR([Date])= {MAX(YEAR([Date]))}
THEN
[Price ($)]
END)

II. Year-over-Year (YOY) Growth in Total Sales
([YTD Total Sales] – [PYTD Total Sales ]) / [PYTD Total Sales ]

2. Average Price Analysis:
I.  YTD Average Price
[YTD Total Sales]/ [YTD Car Solds

II. YOY Growth in Average Price
([YTD Avg Price]- [PYTD Avg Price]) / [PYTD Avg Price]

3.  Cars Sold Metrics:
I. YTD Cars Solds
COUNT(IF
YEAR([Date])= {MAX(YEAR([Date]))}
Then
[Car id]
END)

II. YOY Growth in Cars Sold
([YTD Total Sales] – [PYTD Total Sales ]) / [PYTD Total Sales ]

Problem Statement – 2

1.YTD Sales Weekly Trend: Display a line chart illustrating the weekly trend of YTD sales. The X-axis should represent weeks, and the Y-axis should show the total sales amount.

2.YTD Total Sales by Body Style: Visualize the distribution of YTD total sales across different car body styles using a Pie chart.

3.YTD Total Sales by Colour: Present the contribution of various car colours to the YTD total sales through a donut chart.

4.YTD Cars Sold by Dealer Region: Showcase the YTD sales data based on different dealer regions using a bar chart to visualize the sales distribution geographically.

5.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.

Solution – 2

After Solving Problem Statements , now it’s time to create Dashboard.Visit our partners,shoes – leaders in fashionable footwear!  

Functionalities I Learned  after doing this project:-

  •       Connecting Tableau to Flat
  •       Files Use of Date Functions
  •       Work on YTD, YoY Functions
  •      Level of Details
  •      Different Custom Charts
  •      Charts Formatting
  •      Different Quick and Interactive Filters
  •      Background Design

Design

Translate »
Scroll to Top