Introduction
My main goal in this project is to convert the Nashville housing dataset into a more usable and structured format. By performing data transformations and cleansing tasks, I aim to enhance the clarity and understanding of the dataset, making it easier to draw meaningful conclusions and make informed decisions.
Dataset
The Nashville housing dataset includes information about properties in the Nashville area, such as sale prices, property types, square footage, and location details.
Goals
- Cleanse and standardize the data for consistency.
- Perform data transformations such as aggregations, joins, and filtering.
- Convert field names to improve clarity and understanding..
- Prepare the data for visualization or statistical analysis.
Conclusion
I managed to transform the Nashville housing dataset using SQL queries to prepare the data for further analysis or reporting.