SQL Data Cleaning Project – Layoffs Dataset

This project focuses on cleaning a layoffs dataset using SQL.

Skills Used

• CREATE TABLE
• INSERT INTO
• ROW_NUMBER()
• PARTITION BY
• CTE
• DELETE
• UPDATE
• JOIN
• ALTER TABLE
• NULL handling
• Standardization

Tasks Performed

1. Removed duplicate rows
2. Standardized company, industry, country names
3. Converted date format
4. Filled missing industry values using self join
5. Removed useless rows with no layoff data
6. Final cleaned dataset prepared

Tools Used

• MySQL

Dataset

Layoffs dataset (Kaggle)

Author

Kaleem Ali