World Layoffs SQL Project

About the Dataset

• Source: Kaggle
• Tracks global layoffs in tech companies from March 2020 to July 2024.

Project Goals

• Clean messy real-world data
• Standardize formats
• Handle null and blank values
• Perform exploratory data analysis (EDA)

Techniques Used

• CTEs (Common Table Expressions)
• Window Functions (ROW_NUMBER, DENSE_RANK)
• Aggregate Functions (SUM, COUNT)
• Date Functions (YEAR, SUBSTRING)

Key Findings

• Top companies and industries impacted by layoffs
• Monthly trends of layoffs
• Country-wise layoffs

Tools

• MySQL Workbench
• SQL

Author

• Nivedha Sankaran