Investigating SQL Techniques for Cleaning Nashville Housing Data

About

Credits

This project is based on the following YouTube tutorial:

• Title: Data Analyst Portfolio Project | Data Cleaning in SQL
• Creator: Alex the Analyst (Alex Freberg)
• Link: https://youtu.be/8rO7ztF4NtU?si=ltp7CHPuxGfiHbT_

Aim of the Project

About the Data

_____ Tab le:

Column	Description	Data Type
menu_item_id	Unique ID of a menu item	BIGINT
item_name	Name of a menu item	VARCHAR(50)
category	Category / type of cuisine of the menu item	VARCHAR(30)
price	Price of menu item in USD	VARCHAR(30)

Method

1. Data Prepration and Database setup:

1. Create a database
2. Find and Replace blanks in Excel and change to "NULL"
3. Import data with Data Import Wizard

2. Data Cleaning:

SQL techniques employed: 1.
2.
3.

Data Cleaning Plan

1. Standardize the date format