JOSHUA GREENHALGH

AUSTRALIAN HOUSING PRICE MOVEMENTS

Data Cleaning, Aggregating, Visualisation, Power BI, DAX

Using the mean residential price values from the ABS 'Total Value of Dwellings' release I calculated percentage changes across years and quarters, visualising this on a choropleth map and line chart to provide comparison of price movements between Australian states.

ONLINE CAR SALES 2023

Data Cleaning, Aggregating, Dashboard, Excel

This Excel dashboard serves as a valuable tool for both car buyers (and sellers) in the competitive automotive market. By analysing average sale prices across different states, kilometer ranges, transmission types, and vehicle conditions, users can make more informed decisions about their car transactions.

SQL CLEANING - INDUSTRY LAYOFFS

Data Cleaning, Standardising, SQL

This project involved cleaning null values, duplicates, standardising categories for a set of data containing number of layoffs across major US companies. Link provided to github repository.