Eno Orogun PORTFOLIO

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

Data Manipulation using Python

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