Housing Dataset Analysis with SQL
In this project I analyzed a Housing Dataset with SQL.
This project involved importing a dataset from Excel to SQL Server and then
cleaning and analyzing the data to identify trends and insights.
To begin, I standardized the date format, populated property address data, broke out the address into individual columns for the address, city, and state, changed the "Sold as Vacant" field to "Yes" and "No" instead of "Y" and "N", removed duplicates, and deleted unused columns.
These cleaning steps were critical for preparing the data for analysis and ensuring the accuracy of the insights.
Visualizations
Once the data was cleaned, I used SQL queries and functions to analyze the data and identify patterns and trends.
I then presented the results with PowerBi through charts and graphs, which allowed us to communicate our findings in an engaging and easy-to-understand format.
Code
All the files used for this project can be found Here