Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
07-25-2023 10:02 AM - last edited 08-01-2023 12:32 PM
#metalayoffs analysis - November 2022 - using #powerbi
A brief analysis of the November 2022 Meta layoffs, examining which departments and levels of seniority were impacted the most.
Layoffs are a somber and saddening subject. Each data point making up this analysis represents someone who is currently in a tough situation, and I hope that everyone affected can find strength and land on their feet.
For the sake of anonymity of those impacted, I've removed all PII (Personal Identifiable Information) in the cleaned dataset that I've pushed to #powerbi
About:
On November 9, 2022, Meta announced that it was laying off 11,000 employees, which translates to ~13% of its total headcount. What wasn't publicized, however, was the distribution of the layoff across different departments. It was speculated that Recruiting and Business teams were impacted the most, but what do the actual numbers look like? How much was Engineering affected? How many juniors were affected compared to seniors?
Following the announcement on Wednesday, a public self-reporting MetaMates Talent Directory (public Google Sheets file) was created and shared on layoffs.fyi
At the time of writing, this dataset contains over 2000 entries (nearly 20% of total layoffs, a decent sample to draw from). We can clean and compile this data to help answer some of these questions.
Observations:
Recruiting was impacted the most, but Engineering isn't too far behind; together, these 2 departments comprise nearly 50% of all self-reported layoffs
Engineering layoffs targeted mainly junior employees, whereas Product, Marketing, and Sales layoffs consisted mainly of senior employees
The department that will need the most visa support is Engineering (46% of laid-off engineers will require visa support)
Although Recruiting makes up the largest percentage of layoffs (26%), only 8% of them will require visa support
Assumptions and Limitations:
This analysis assumes minimal selection bias in our sample, which likely isn't true. Some departments might be more/less likely to report their layoffs in the dataset, so our sample probably isn't perfectly representative of the true population (all 11,000 layoffs).
There is no validation/verification when contributing to this dataset. This is evidenced by "troll" records like "Rahul Ligma" (row 1723) and "Elon Musk" (row 1710). Luckily, data points like this are rare and unlikely to skew our insights.
<Only for learning purposes>
Data Source: layoffs.fyi
eyJrIjoiYjhmY2UwNDQtZGNiMy00MDA0LTk1OTYtNzA5NjQyNzQ2ODY2IiwidCI6IjVkNWM5YTUwLWM4NTQtNGVhMy1iMDVkLTE2Mzg4YjE0ZDViMyIsImMiOjZ9
Hi there,
Would you please share the PBIX file that I can learn from it?
Thanks a lot
Please, could you share a copy of the .pbix with me?
Hello,
Great work. Could you please share the pbix file?
Thanks.
Hi
Can you please share pbix file
Thank you
Hi Pavan Girjapure , Can you please share the .pbix file?
Thanks