Employee/HR Dataset (All In One)
Employee Dataset ( Training, Survey, Performance, Recruitment, Attendance)
@kaggle.ravindrasinghrana_employeedataset
Employee Dataset ( Training, Survey, Performance, Recruitment, Attendance)
@kaggle.ravindrasinghrana_employeedataset
The Synthetic Employee Records Dataset is a simulated dataset created to explore various data analysis and machine learning techniques in the context of human resources and employee management. This synthetic dataset mirrors the structure and characteristics of real employee data, while all the information contained within is entirely fictional and generated for illustrative purposes.
The Training and Development Records Dataset provides a comprehensive overview of training activities and developmental programs within an organization. This dataset is designed to capture the details of employee participation in various training initiatives, helping to assess the impact of professional development efforts and guide strategic decision-making.
The Recruitment Activity Records Dataset offers a comprehensive view of the recruitment process within an organization, encompassing key data points from initial job posting to candidate selection. This dataset aims to facilitate insights into the efficiency of recruitment efforts, candidate profiles, and the effectiveness of sourcing channels.
The Employee Engagement Survey Dataset presents a comprehensive collection of responses obtained through an organization-wide employee engagement survey. This dataset is intended to analyze the levels of employee engagement, satisfaction, and sentiment across various facets of the workplace, facilitating insights into workforce dynamics and guiding strategies for improvement.
Please note that the examples provided are fictional and for illustrative purposes. You can tailor the descriptions and examples to match the specifics of your dataset. You can also reach me via email at: rrana157@gmail.com
CREATE TABLE employee_data (
"empid" BIGINT,
"firstname" VARCHAR,
"lastname" VARCHAR,
"startdate" VARCHAR,
"exitdate" VARCHAR,
"title" VARCHAR,
"supervisor" VARCHAR,
"ademail" VARCHAR,
"businessunit" VARCHAR,
"employeestatus" VARCHAR,
"employeetype" VARCHAR,
"payzone" VARCHAR,
"employeeclassificationtype" VARCHAR,
"terminationtype" VARCHAR,
"terminationdescription" VARCHAR,
"departmenttype" VARCHAR,
"division" VARCHAR,
"dob" VARCHAR,
"state" VARCHAR,
"jobfunctiondescription" VARCHAR,
"gendercode" VARCHAR,
"locationcode" BIGINT,
"racedesc" VARCHAR,
"maritaldesc" VARCHAR,
"performance_score" VARCHAR,
"current_employee_rating" BIGINT
);CREATE TABLE employee_engagement_survey_data (
"employee_id" BIGINT,
"survey_date" VARCHAR,
"engagement_score" BIGINT,
"satisfaction_score" BIGINT,
"work_life_balance_score" BIGINT
);CREATE TABLE recruitment_data (
"applicant_id" BIGINT,
"application_date" VARCHAR,
"first_name" VARCHAR,
"last_name" VARCHAR,
"gender" VARCHAR,
"date_of_birth" VARCHAR,
"phone_number" VARCHAR,
"email" VARCHAR,
"address" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip_code" BIGINT,
"country" VARCHAR,
"education_level" VARCHAR,
"years_of_experience" BIGINT,
"desired_salary" DOUBLE,
"job_title" VARCHAR,
"status" VARCHAR
);CREATE TABLE training_and_development_data (
"employee_id" BIGINT,
"training_date" VARCHAR,
"training_program_name" VARCHAR,
"training_type" VARCHAR,
"training_outcome" VARCHAR,
"location" VARCHAR,
"trainer" VARCHAR,
"training_duration_days" BIGINT -- Training Duration(Days),
"training_cost" DOUBLE
);Anyone who has the link will be able to view this.