HR Analytics Dashboard

Overview

This HR Analytics Dashboard provides a high-level overview of key HR metrics for an organization. It's designed to give insights into employee demographics, attrition rates, job satisfaction, and other crucial HR-related data to support strategic decisions.

Dashboard Features

Count of Employee & Attrition

• Total Employees: Displays the total number of employees in the organization.
• Total Attrition: Number of employees who have left the company.
• Attrition Rate: Percentage of total employees who have left the company.

Demographics and Job Role Insights

• Attrition by Education: Shows the distribution of attrition across different educational backgrounds.
• Attrition by Age: Breakdown of attrition within specific age groups.
• Attrition by Salary Slab: Visualizes attrition rates across different salary brackets.
• Attrition by Years at Company: Demonstrates how attrition rates change with the employee's tenure at the company.
• Job Satisfaction: A table that reflects job satisfaction levels across various job roles.
• Attrition by Job Role: Illustrates which job roles have the highest numbers of attrition.

Average Metrics

• Average Age: The mean age of employees in the organization.
• Average Salary: The average salary of employees, expressed in 'k' (thousands).
• Average Years at Company: The average number of years employees have spent at the company.

Data Source

The dashboard visualizes data sourced from the company's HR information system, covering various departments and job roles.

Usage

The dashboard is interactive and allows for drilling down into specific departments such as Human Resources, Research & Development, and Sales for more detailed analysis.

Business Implications

HR leaders and department managers can leverage this dashboard to:

• Monitor and develop strategies to reduce attrition rates.
• Understand the impact of salary and tenure on employee retention.
• Identify job roles with high turnover for targeted interventions.
• Evaluate job satisfaction and develop programs to enhance employee engagement.

Technical Details

• Tool Used: Created with Power BI.
• Refresh Rate: Data is refreshed monthly to ensure up-to-date analysis.

Installation

To use this dashboard:

1. Ensure you have Power BI Desktop installed.
2. Download the .pbix file from the repository.
3. Open the file in Power BI Desktop.
4. Update data source settings if necessary.

Contributing

I am open to any suggestions! Please fork the repository and submit a pull request for any enhancements you wish to propose.

License

This project is licensed under the MIT License - see the LICENSE.md file for details.

Contact

For any queries or further assistance, please reach out to Inderpreet at inderpreetsingh3108@gmail.com.