Portfolio Project - Data cleaning using SQL Server

This is a SQL portfolio project for data cleaning using sql server for a dataset - NashvilleHousing.

Data cleaning procedure includes these below mentioned functions -

• CONVERT()
• ISNULL()
• CASE WHEN
• SUBSTRING()
• CHARINDEX()
• PARSENAME()
• REPLACE()
• CTEs - Row_Number()

Data Cleaning tasks for this dataset -

1. Standardize date format for SaleDate column
2. Populate Property address data for NULL Values
3. Breaking out Property and Owner address into individual columns (Address, sity ,state)
4. Change Y and N to Yes and No in "Sold as Vacant" field
5. Remove Duplicates
6. Delete Unused Columns

Tools used -

1. SQL Server Management Studio.
2. SQL Server import Export tool.