DATASET

Data - Job layoff data comprising 2362 rows from 2020 to 2023. Data cleaning and analysis - Postgres Data Visualization - Microsoft Power BI

The following questions were answered using SQL

Total number of layoffs by company

Total layoffs

Number of companies

Average layoffs per company

Total number of layoffs by industry

Average percentage of layoffs by industry

Total number of layoffs by country

Total funds raised by companies that had the biggest layoffs. 9.Correlation between funds raised and layoffs

Layoffs trend.

Top 20 companies by percentage laid off.

Distribution of layoffs by company stage.

Top 5 locations by total layoffs

Most affected industries by country

10 Most affected industries by USA

Percentage of layoffs at various stages

INSIGHTS AND RECCOMMENDATION

The 383159 thousand layoffs across 1616 companies represents 20% of the total workforce. That's about 237 layoffs per company.

The year 2022 recorded the highest layoffs with 160661 people losing their jobs.

Consumer, retail transport and finance are among the worst hit industries.

3 of the 5 worst affected cities are in the United States: SF Bay Area, Seattle and New York City. The other two are Bengaluru and Amsterdam.

Majority of companies which laid off workers are established post-IPO firms.

The United States is by far the worst hit country accounting for a whopping 66.8% (256059) of the total layoffs.

There's no direct relationship between the number of job layoffs and funds raised.