Car Sales Data Analytics
This is the Power Bi, SQL and Python exploration of car sales for both new and used cars from 1990 to 2022 and the dataset includes brand, model, condition, mileage, price, year and more. Click on the image below to be taken to the report.
Querying the Dataset using SQL
The query below shows the top 1000 records of new cars sold from 2009
The query below calculates the average price of cars and groups them by brand and model
The query below shows car sales at the price between the ranges of 20,000 to 40,000
The code below filters and retrieves all cars with the year 2022
Below shows the cars with Mileage that are 40,000 or below
Below is the results for cars with the price 30,000 or less and with the condition as ‘New’
Below is the Histogram showing the prices of cars and how frequency of their occurrences