Analyzing IBM Employee Data With Tableau

Explore Factors That Lead To Employee Attrition

Image for post
Image for post
Image Source: Wikimedia Commons

International Business Machines (IBM)Corporation is an American multinational information technology company. Tableau Software is a software company that produces interactive data visualization products. In this article we want to uncover the factors that lead to employee attrition and explore important factors of attrition like comparing the average monthly income by education and attrition. If you would like to download a free version of Tableau check out this video.

Get The IBM Employee Data Set

We can get the IBM data set from kaggle. You can find the data set here. This is a fictional data set created by IBM data scientists.

The data set contains the following features / columns:

Age
Attrition
BusinessTravel
DailyRate
Department
DistanceFromHome
Education
EducationField
EmployeeCount
EmployeeNumber
EnvironmentSatisfaction
Gender
HourlyRate
JobInvolvement
JobLevel
JobRole
JobSatisfaction
MaritalStatus
MonthlyIncome
MonthlyRate
NumCompaniesWorked
Over18
OverTime
PercentSalaryHike
PerformanceRating
RelationshipSatisfaction
StandardHours
StockOptionLevel
TotalWorkingYears
TrainingTimesLastYear
WorkLifeBalance
YearsAtCompany
YearsInCurrentRole
YearsSinceLastPromotion
YearsWithCurrManager

Image for post
Image for post
A Sample Of The IBM Data Set

Now that we have Tableau, and our IBM data set, let’s dive into the data with visualizations !

Which department has the most employee attrition ?

Image for post
Image for post

From the Bar Graph, it looks like Research & Development has the most employee attrition, followed by Sales, and then Human Resources, but does this tell the whole story. Research & development has more employees than the other two so let’s see how the departments stack up percentage wise.

Human Resources Attrition percentage = 12/ 63 = 0.19 = 19 %

Research & Development percentage = 133/ 961 = 0.138 = 13.8%

Sales percentage = 92/ 446 = 0.206 = 20.6%

So it looks like the sales department has a higher attrition percentage then the other two departments followed by human resources and then research & Development. So maybe IBM should focus on the Sales department attrition.

At what age are people most likely to leave ?

Image for post
Image for post

Looks like ages 29 and 31 both have the highest attrition rate of 18 employees. More interesting though is that the number of attrition seems to go down around the age of 36, we no longer see attrition rates in the double digits. So maybe IBM should look at employees who are under the age of 36 to reduce there employee attrition. Yet I wonder if age has a correlation with an employees monthly salary.

What’s the sum of all of the Monthly Rates by age ?

Image for post
Image for post

This is interesting because this graph looks like the one before it. Maybe there is something more with the Monthly Rate and an employees attrition and possibly not just their age.

Does An Employees Attrition Decrease The Longer They Are At The Company?

Image for post
Image for post

From the graph above, it seems that the longer the employee is at the company the less likely they are to leave.

Conclusion

Looks like it’s likely for employees to leave the company if they have less than 10 years with the company, are under the age of 37, and are not in the Resource & Development department. If you are interested in learning Data Analysis with Tableau and creating charts like the ones in this article, then Tableau Your Data!: Fast and Easy Visual Analysis with Tableau Software is a great book to learn how and get started !

Image for post
Image for post
Tableau Your Data!: Fast and Easy Visual Analysis with Tableau Software

Thanks for reading this article I hope its helpful to you all ! Keep up the learning, and if you would like more computer science, programming and algorithm analysis videos please visit and subscribe to my YouTube channels (randerson112358 & compsci112358 )

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store