HR Analysis Case Study

Datasets used for learning Purpose

@kaggle.shivan118_hranalysis

Table List

2 tables(907.65 KB)

Train

@kaggle.shivan118_hranalysis.train

635 KB
54808 rows
14 columns

employee_id Employee Id	department Department	region Region	education Education	gender Gender	recruitment_channel Recruitment Channel	no_of_trainings No Of Trainings	age Age	previous_year_rating Previous Year Rating	length_of_service Length Of Service	kpis_met_80 KPIs Met \u003e80%	avg_training_score Avg Training Score
65438	Sales & Marketing	region_7	Master's & above	f	sourcing	1	35	5	8	1	49
65141	Operations	region_22	Bachelor's	m	other	1	30	5	4		60
7513	Sales & Marketing	region_19	Bachelor's	m	sourcing	1	34	3	7		50
2542	Sales & Marketing	region_23	Bachelor's	m	other	2	39	1	10		50
48945	Technology	region_26	Bachelor's	m	other	1	45	3	2		73
58896	Analytics	region_2	Bachelor's	m	sourcing	2	31	3	7		85
20379	Operations	region_20	Bachelor's	f	other	1	31	3	5		59
16290	Operations	region_34	Master's & above	m	sourcing	1	33	3	6		63
73202	Analytics	region_20	Bachelor's	m	other	1	28	4	5		83
28911	Sales & Marketing	region_1	Master's & above	m	sourcing	1	32	5	5	1	54


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,
  "awards_won" BIGINT,
  "avg_training_score" BIGINT,
  "is_promoted" BIGINT
);