HR Analytics: Case Study
Understand the factors influencing employee attrition and job satisfaction.
@kaggle.bhanupratapbiswas_hr_analytics_case_study
Understand the factors influencing employee attrition and job satisfaction.
@kaggle.bhanupratapbiswas_hr_analytics_case_study
Analyzing HR Data for Improved Workforce Management: A Case Study
INTRODUCTION
HR analytics, also known as people analytics, is a data-driven approach to managing human resources. It involves gathering and analyzing data related to employees, such as recruitment, performance, engagement, and retention, to derive insights and make informed decisions. This case study explores the application of HR analytics in a hypothetical organization and showcases its benefits in optimizing workforce management.
CASE STUDY OVERVIEW
Organization Description:
Let's consider a medium-sized technology company called "TechSolutions Inc." The company specializes in software development and has a diverse workforce across different departments, including engineering, marketing, sales, and customer support.
Objectives:
The main objectives of this case study are as follows:
DATA COLLECTION AND ANALYSIS
Data Sources:
To conduct HR analytics, the following data sources can be utilized:
Data Analysis Steps:
RESULTS AND RECOMMENDATIONS
Based on the analysis conducted in the previous steps, let's assume the following findings and corresponding recommendations:
Attrition Analysis:
Job Satisfaction Analysis:
Performance Prediction:
Employee Engagement Analysis:
By implementing these recommendations, TechSolutions Inc. can enhance employee satisfaction, engagement, and retention, leading to a more productive and motivated workforce.
CREATE TABLE wa_fn_usec_hr_employee_attrition (
"age" BIGINT,
"attrition" VARCHAR,
"businesstravel" VARCHAR,
"dailyrate" BIGINT,
"department" VARCHAR,
"distancefromhome" BIGINT,
"education" BIGINT,
"educationfield" VARCHAR,
"employeecount" BIGINT,
"employeenumber" BIGINT,
"environmentsatisfaction" BIGINT,
"gender" VARCHAR,
"hourlyrate" BIGINT,
"jobinvolvement" BIGINT,
"joblevel" BIGINT,
"jobrole" VARCHAR,
"jobsatisfaction" BIGINT,
"maritalstatus" VARCHAR,
"monthlyincome" BIGINT,
"monthlyrate" BIGINT,
"numcompaniesworked" BIGINT,
"over18" VARCHAR,
"overtime" VARCHAR,
"percentsalaryhike" BIGINT,
"performancerating" BIGINT,
"relationshipsatisfaction" BIGINT,
"standardhours" BIGINT,
"stockoptionlevel" BIGINT,
"totalworkingyears" BIGINT,
"trainingtimeslastyear" BIGINT,
"worklifebalance" BIGINT,
"yearsatcompany" BIGINT,
"yearsincurrentrole" BIGINT,
"yearssincelastpromotion" BIGINT,
"yearswithcurrmanager" BIGINT
);
Anyone who has the link will be able to view this.