Hello everyone! My name is JAYA PRAKASH, I have created my first interactive Dashboard on HR Analytics using Power BI with the guidance of an engaging YouTube tutorial by Rishabh Mishra.
Objective: - By using data-driven insights, help an organization by enhancing staff performance, increasing employee retention, and lowering attrition.
Dashboard Overview: - Department Level Filter - Human Resources, Research & Development, Sales. Performance Indicators (KPIs) – Count of employees, attrition figures, attrition rate, average age of employees, average salary of employees, and average year of employees at the company.
Action: -
Data Cleaning: Use Power Query to Clean the irrelevant and unused data such as removing duplicates, renaming columns, and changing data types. Data Processing: Load and Apply the cleaned data into Power BI. Data Visualization: Create Measures and columns Using DAX functions such as count, sum, calculate, etc.
Insights: -
- The attrition rate is higher in Life Sciences Education which is 38%.
- Maximum attrition happening in the age group 26-35.
- The attrition rate is highest for employees who are paid up to 5K.
- The attrition rate seems to be high after working for a year in the company.
- Attrition is directly proportional to job satisfaction as well for different job roles. Hence lower the number, the more chances of attrition.
- A laboratory technician's position has the highest attrition rate, i.e. 62.
- The attrition rate is higher for male employees than for female employees.
- The count of Emplooyee is 1470.
- The Attrition rate is 16.1%.
By providing these insights, the dashboard enables HR managers to take proactive measures to retain top talent, manage attrition, and create a more productive work environment.