Nashville Housing Data

This data set is composed of 56,000+ rows of housing sale information in the Nashville, Tennessee area in

I completed this project to demonstrate my SQL ability to clean up a dataset to making it more usable for further analysis. The full code of the project can be downloaded and viewed on my GitHub profile.

Setup & context

I downloaded the data set from kaggle.com as a .csv and uploaded the file into Microsoft SQL Server Management Studio on a database hosted on my local machine. I used functions such as case statements, CTE's, and temp tables. Some issues with the original data set were missing values, duplicate values, and dates stored in a sub-optimal format.