Employee Attrition Problem

Click here to download the Project Data File.

Description:

The data is for company X which is trying to control attrition. There are two sets of data: “Existing employees” and “Employees who have left”. Following attributes are available for every employee.
Satisfaction Level
Last evaluation
Number of projects
Average monthly hours
Time spent at the company
Whether they have had a work accident
Whether they have had a promotion in the last 5 years
Departments (column sales)
Salary
Whether the employee has left
 
Objective
What type of employees are leaving? Determine which employees are prone to leave next. Present your results in the presentation sheet’s presentation area.

EXISTING EMPLOYEE TABLE: (HEAD)

Emp IDsatisfaction_
level
last_
evaluation
number_
project
average_
montly_
hours
time_
spend_
company
Work_
accident
promotion_
last_
5years
deptsalary
20010.580.744215300saleslow
20020.820.672202300saleslow
20030.450.695193300saleslow
20040.780.825247300saleslow

EX-EMPLOYEE TABLE : (HEAD)

Emp IDsatisfaction_
level
last_
evaluation
number_
project
average_
montly_
hours
time_
spend_
company
Work_
accident
promotion_
last_
5years
deptsalary
10.380.532157300saleslow
20.80.865262600salesmedium
30.110.887272400salesmedium
40.720.875223500saleslow

OUTPUT OF THE PROJECT:

  1. CREATE A MS-PRESENTATION (MAXIMUM 12 SLIDES) EXPLAINING THE REASONS EMPLOYEE ARE PRONE TO LEAVE AFTER ANALYSING THIS DATA SET.
  2. EXPLAIN WHAT TYPE OF EMPLOYEE ARE PRONE TO LEAVE THE COMPANY.
  3. PREDICT THE FUTURE EMPLOYEE WHO WOULD TEND TO LEAVE THE COMPANY.