HR Analytics on Absenteeism and Health

Goal: Evaluating an HR dataset about absenteeism and health. To determine how to provide a bonus and incentive to healthy employees.

Introduction:

Datasets given by HR: https://absentdata.com/wp-content/uploads/2023/09/Absenteeism_at_work-1.zip

Dashboard (PowerBI)

For interactive visualisation: https://app.powerbi.com/reportEmbed?reportId=571161c0-2747-44d8-91e3-f6f8ae29b242&autoAuth=true&ctid=3a59e355-01e4-45dc-af92-5796b392d9f5

Summary

1. To find the list of healthy employees

Set query as below:

select * from Absenteeism_at_work where Social_drinker = 0 and Social_smoker = 0 and Body_mass_index < 25 and Absenteeism_time_in_hours < (select AVG(Absenteeism_time_in_hours) from Absenteeism_at_work)

Or

select id,Social_drinker,Social_smoker,Body_mass_index,Absenteeism_time_in_hours, (select AVG(Absenteeism_time_in_hours) from Absenteeism_at_work) as average from Absenteeism_at_work where Social_drinker = 0 and Social_smoker = 0 and Body_mass_index < 25 and Absenteeism_time_in_hours < (select AVG(Absenteeism_time_in_hours) from Absenteeism_at_work);

Total we have 111 healthy employees eligible for healthy bonus:

Therefore, each employees entitled for $9 USD bonus for the budget of $1000 USD

2. To find the wage increase for non smoker employees

Set query as below:

select count (*) as nonsmokers from Absenteeism_at_work where Social_smoker =0;

This query found out there are 686 non smoker employees eligible for insurance budget of $983,221 USD. assuming 5 working days with 8 working hour and 52 weeks, per employee entitle for an additional $0.68 wage raise per hour.

3. Create a dashboard with the below approved wireframe

Approved wireframe from HR: