This project involves cleaning and preparing a raw housing dataset using SQL. The dataset contained inconsistencies, null values, and formatting issues that were addressed using SQL queries and logic.
- Clean and standardize raw housing data
- Handle missing values
- Remove duplicates
- Prepare clean views for further analysis
- MySQL
- MySQL Workbench
- SQL queries (UPDATE, SELECT, CASE, JOINs)
- Data formatting and standardization
- NULL handling
- Creating views
- Data_Cleaning β contains all the data cleaning queries.