Apple: Most reviews are from the past 2–4 yearsīased on these observations and considering how fast these companies are growing and changing every year, I decided to continue my analysis with employee reviews from the last 4 years available (2015 to 2018), since I believe they will be the most relevant.
Amazon: Most reviews are from the past 3–4 years.Google: Most reviews are from the past 4 years.Microsoft: Most reviews are from the past 4–7 years.Interpretation: As we can see, there is a decade worth of employees reviews available, but they only go up to 2018. I began my analysis by visualizing the distribution of employee reviews for each of the 4 companies I selected. Insights & Analysis Which company has the most reviews? Columns containing numeric values were converted to the appropriate data type.Rows with missing values in all columns were dropped.Rows with missing values in the following columns were dropped: “company”, ‘year’, “overall-ratings”, and “job-title”.A new column named “Year” was created containing the different years when the reviews were made.Rows with missing values in the “Date” column were dropped.The “Link” and “Advice to Management” columns were dropped since I didn’t think they would be as insightful as the other columns.Although Facebook and Netflix had a good number of reviews, combined, they represented less than 4% of the dataset, so I decided to exclude them from this analysis for simplicity purposes.
The employee reviews data used for this analysis was downloaded from the Kaggle Datasets and it was sourced from Glassdoor - a website where current and former employees anonymously review companies and their management. I will start by describing how I cleaned and processed the data, and then talk about my analysis with the help of some visualizations. In this article, I will walk you through my analysis of Employee Reviews for Google, Microsoft, Amazon and Apple and try to uncover some meaningful information that will hopefully illuminate us when deciding which company it’s worth working for. Working for a top tech company is many people’s dream, it was certainly mine for a long time, but shouldn’t we be asking ourselves “Is it really worth working for one of these companies?” Well, who better to help us answer this question than their own employees. To put it into perspective, Google alone receives more than two million job applications each year. Whether it is for their ability to offer high salaries, extravagant perks, or their exciting mission statements, it is clear that top companies like Google and Microsoft have become talent magnets. Which company is it worth working for? Overview
0 kommentar(er)
