NASHVILLE HOUSING
Organizing raw housing data for strategic insights
The scope of the project is to transform raw housing data into standard format for further examination. The SQL script was written to provide a deeper and more detailed framework for the general format and to facilitate the next steps of data analysis and modeling.
This project includes steps; updating data types, removing duplicate records, properly formatting data required for analysis, optimizing performance using CTEs, and ensuring data integration.
The script ensures a clean, structured, and optimized dataset for reliable insights and visualization using data standardization, CTEs and Window Functions, address parsing, data imputation and column optimization.