World Layoffs Data Analysis Project (2020-2024)

Excited to share my latest data analysis project exploring global workforce reductions using MySQL. Let me take you through a fascinating journey of numbers that reveals how the employment landscape has evolved in recent years.

Key Highlights:

Timeline Analysis:

2023 hit record highs with 264,220 layoffs

Surprisingly, 2021 saw only 15,823 layoffs

2024 already reached 141,467 (until October)

Tech Giants Impact:

Amazon led with 27,840 employees

Meta followed at 21,000 employees

Intel at 16,057 employees

Microsoft and Tesla completing the top 5

Industry Breakdown:

Retail sector topped with 71,703 employees

Consumer sector followed closely at 70,941

Transportation sector at 60,048 Interesting pattern: Traditional tech hardware companies showed significant reductions

Geographic Distribution:

US dominated with 449,229 layoffs

India ranked second with 55,889

Significant impact on European workforce Surprising find: Luxembourg and Ukraine recorded lowest numbers

Technical Implementation:

Rigorous data cleaning process

MySQL for analysis

Handled duplicates and NULL values professionally

Used stored procedures for complex calculations

? What Makes This Analysis Special?

Comprehensive timeline (2020-2024)

Cross-sector insights

Reveals fascinating patterns in company behaviors

Data-driven insights into industry trends

Full project and code available on GitHub: https://lnkd.in/deF9ZgAH