Goal

Cleaning data in SQL and shows how to manipulate the data once it's actually in the database. This is a really great one to showcase how data cleaning is done more efficiently .

Data

For this project, I have use Nashville Housing Data dataset from Alex The Analyst Github profile.

Process

In order to clean Nashville Housing Data , we followed the a process that looked at the data using:

• Perform various SQL functionalities like ALTER TABLE, CONVERT, JOIN, etc to get the insight.
• We have to standardize data , populate some columns , delete some columns.
• Documentation of this project in Github