Attrition Rate Of A Company
Analyze the Attrition Rate of a Company
@kaggle.anujachintyabiswas_attrition_rate_of_a_company
Analyze the Attrition Rate of a Company
@kaggle.anujachintyabiswas_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 -
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
);Anyone who has the link will be able to view this.