Data Cleaning and Manipulation

Project: Data Cleaning & Manipulation using SQL

Tools & Technologies: SQL Server, Draw.io, Data Modeling

• Cleaned and transformed a public housing dataset using SQL Server.
• Standardized SaleDate formats and created a clean date column.
• Populated missing addresses using self-joins on parcelID.
• Normalized address columns using PARSENAME.
• Standardized categorical values like SoldAsVacant.
• Removed duplicates using ROW_NUMBER().
• Documented each transformation step clearly.