Analyzed layoff events across industries and companies using SQL to discover job market trends. Focused on identifying which sectors were most affected and when layoffs spiked.
- MySQL
- SQL Aggregations, Joins, Date Functions
- Company, Industry, Location
- Date of Layoff
- Total Laid Off
- Workforce Size
- Which industries had the most layoffs?
- When did layoffs peak?
- Which countries and company sizes were most affected?
- Cleaned and imported raw layoff data
- Parsed layoff dates into months/quarters
- Grouped layoffs by industry, company size, country
- Calculated layoffs as % of total workforce
- Tech sector = 60% of layoffs in 2023
- February and October had highest events
- Startups (<500 employees) had highest layoff % by headcount
- U.S. dominated total layoff volume
- Guides recruiters and career advisors on market volatility
- Helps companies model layoffs as a function of macro events
- Enables HR teams to benchmark risk by industry
Made by Deven Mbuyane
📧 devenmbuyane@gmail.com | 🌐 Portfolio