Baselight

Attrition Rate Of A Company

Analyze the Attrition Rate of a Company

@kaggle.anujachintyabiswas_attrition_rate_of_a_company

Loading...
Loading...

About this Dataset

Attrition Rate Of A Company

Analysing the Attrition Rate of a Company
A large company named XYZ, employs, at any given point of time, around 4000 employees. However, every year, around 15% of its employees leave the company and need to be replaced with the talent pool available in the job market. The management believes that this level of attrition (employees leaving, either on their own or because they got fired) is bad for the company, because of the following reasons -

  1. The former employees’ projects get delayed, which makes it difficult to meet timelines, resulting in a reputation loss among consumers and partners
  2. A sizeable department has to be maintained, for the purposes of recruiting new talent
  3. More often than not, the new employees have to be trained for the job and/or given time to acclimatize themselves to the company
    Hence, the management has contracted an HR analytics firm to understand what factors they should focus on, in order to curb attrition. In other words, they want to know what changes they should make to their workplace, in order to get most of their employees to stay. Also, they want to know which of these variables is most important and needs to be addressed right away.
    Since you are one of the star analysts at the firm, this project has been given to you.
  • Goal of the case study
  • Exploratory Analysis
  1. Ratio of Attrition based on the following factors
    a. Gender
    b. Job Satisfaction Level
    c. Work Life Balance
  2. Which age group shows a higher attrition rate
  • Predictive Analysis
  1. You are required to model the probability of attrition using an analytical technique.
  2. Identify the technique and why you are using that technique.
  3. Analyse the given data to identify the major reasons for attrition
  4. Advise suggestions to curb the attrition
  5. The results thus obtained will be used by the management to understand what changes they should make to their workplace, in order to get most of their employees to stay

Tables

General Data

@kaggle.anujachintyabiswas_attrition_rate_of_a_company.general_data
  • 88.68 KB
  • 4410 rows
  • 29 columns
Loading...

CREATE TABLE general_data (
  "employeeid" BIGINT,
  "age" BIGINT,
  "attrition" VARCHAR,
  "businesstravel" VARCHAR,
  "department" VARCHAR,
  "distancefromhome" BIGINT,
  "education" BIGINT,
  "educationfield" VARCHAR,
  "employeecount" BIGINT,
  "gender" VARCHAR,
  "joblevel" BIGINT,
  "jobrole" VARCHAR,
  "maritalstatus" VARCHAR,
  "monthlyincome" BIGINT,
  "numcompaniesworked" DOUBLE,
  "over18" VARCHAR,
  "percentsalaryhike" BIGINT,
  "standardhours" BIGINT,
  "stockoptionlevel" BIGINT,
  "totalworkingyears" DOUBLE,
  "trainingtimeslastyear" BIGINT,
  "yearsatcompany" BIGINT,
  "yearssincelastpromotion" BIGINT,
  "yearswithcurrmanager" BIGINT,
  "environmentsatisfaction" DOUBLE,
  "jobsatisfaction" DOUBLE,
  "worklifebalance" DOUBLE,
  "jobinvolvement" BIGINT,
  "performancerating" BIGINT
);

Share link

Anyone who has the link will be able to view this.