Car Sales Data Analysis

Project Overview

This data analysis project aims to provide insights into the sales performance of a Car selling company over the year 2022 to 2023.By analysis various aspects of the sales data, I want to identify monthly trends, make data-driven recommendations and gain deeper understanding of the company's performance.

Cleaning involved:-

1. Data loading and Inspection

2. Handling missing values

3. Removing duplicates

4. Formatting

Exploratory Data Analysis Involved answering key questions:-

1. Year To Date total sales and sales growth.

2. Month To Date total sales and each monthly sales growth

3. Total Cars Sold and the most sold type of Car

4. Monthly Trend of the sales

Findings:-

1. The Company's sales have been increasing over the past year.

2. The Porche Cayenne has been the best sold car

3. Cars of colour Pale White have the highest Sales/Demand.

4. Cars with Automatic Transmission are mostly sold.