HR Analysis Case Study
Datasets used for learning Purpose
@kaggle.shivan118_hranalysis
Datasets used for learning Purpose
@kaggle.shivan118_hranalysis
This is the HR datasets. In our dataset 50000 rows and 14 columns. Every year, around 5% of its employees have promoted in the company. so, we have the check employee is promoted or not?
Good luck and enjoy the learning!
CREATE TABLE test (
"employee_id" BIGINT,
"department" VARCHAR,
"region" VARCHAR,
"education" VARCHAR,
"gender" VARCHAR,
"recruitment_channel" VARCHAR,
"no_of_trainings" BIGINT,
"age" BIGINT,
"previous_year_rating" DOUBLE,
"length_of_service" BIGINT,
"kpis_met_80" BIGINT -- KPIs Met \u003e80%,
"awards_won" BIGINT -- Awards Won?,
"avg_training_score" BIGINT
);CREATE TABLE train (
"employee_id" BIGINT,
"department" VARCHAR,
"region" VARCHAR,
"education" VARCHAR,
"gender" VARCHAR,
"recruitment_channel" VARCHAR,
"no_of_trainings" BIGINT,
"age" BIGINT,
"previous_year_rating" DOUBLE,
"length_of_service" BIGINT,
"kpis_met_80" BIGINT -- KPIs Met \u003e80%,
"awards_won" BIGINT -- Awards Won?,
"avg_training_score" BIGINT,
"is_promoted" BIGINT
);Anyone who has the link will be able to view this.