Practiced a wide range of SQL queries including Aggregate Functions, Joins, Window Functions, CTEs, and Views to clean this dataset.
Queries: https://github.com/DablewCodes/Nashville-Housing-Data-Cleaning/blob/main/Queries.sql
This project was created by following this tutorial: https://www.youtube.com/watch?v=8rO7ztF4NtU&list=PLUaB-1hjhk8H48Pj32z4GZgGWyylqv85f&index=3
Technologies used:
• SQL/SSMS
• Excel
Cleaning Process:
• Download the dataset
• Load into SSMS
• Perform Cleaning