SQL-Based Data Cleaning and Transformation Project
About Dataset This dataset contains information about housing sales in Nashville, TN such as property, owner, sales, and tax information. Purpose The purpose of this data cleaning project is to enhance the quality, consistency, and usability of the dataset by implementing a structured and comprehensive data cleaning procedure. Through these cleaning procedures, the project aims to enhance the integrity, accuracy, and usability of the dataset, enabling more reliable and insightful analysis, reporting, and decision-making processes. Note : I’ll be using PostgreSQL as the tool to carry out these data cleaning tasks. Data Cleaning Procedure 1) Standardize Date Format : The goal is to ensure uniformity in date representation across the dataset, eliminating variations in date formats that might cause confusion or inaccuracies during analysis. Before After 2) Populate Property Address Data : The aim is to fill in missing or incomplete property address da...