INTRODUCTION

This project aims to create an interactive dashboard for car sales analysis. The main objective is to provide an overview of business performance using various key performance indicators (KPIs) and charts. This dashboard allows users to track sales in real time, analyze weekly, monthly and annual trends, and compare results to the previous year.

The analysis focuses on three main aspects: sales overview, average price analysis, and metrics related to cars sold. Each section provides essential insights to understand overall sales performance, price variations, and sales distribution by region, body style, and car color

DASHBOARD 1 : OVERVIEW

KPI'S REQUIREMENT

• 1. 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 (PYTD)

• 2. Average Price Analysi:

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

• 3. Cars Sold Metrics:

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

CHART'S REQUIREMENT

• 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 colors to the YTD total sales throught a pie chart.
• 4. YTD Cars Sold by Dealer Region: Showcase the YTD sales data based on different dealear regions using a map chart to visualize the sales distribution geographically.
• 5. Company-Eise 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.
• 6. 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, colour, sales amount, dealer region, date, etc...

SKILL

• Connecting to excel file
• Data cleaning
• Data Modelling
• Data processing
• Power Query
• Date Tables
• DAX
• Time Intelligence Func
• MAX, MAXX, RANK
• Date Function
• Custom Charts
• Text Function
• Filter Function
• Calculate
• SUM/ SUMX
• Conditional Formatting's
• Maps * Custom Maps
• Creating Charts
• Formatting visuals
• Creating Functions
• Navigations

SOFTWARES USED

• 1. MS OFFICE / EXCEL
• 2. POWER BI

SCREENSHOTS

Home

Details

VIDEO DEMO