Data Cleaning in SQL

Cleaning raw real estate data and transforming it into a usable format using SQL functions like PARSENAME, CASE statement, and self JOIN • I used advanced SQL concepts like self JOIN, PARSENAME, Temp Table, and CTE to clean up the dirty data and automatically fill in missing information

• Was able to identify the best neighborhood areas for real estate investment