HR Analytics Dashboard

Overview

This project is an HR Analytics Dashboard designed to provide insights into workforce trends, employee performance, attrition rates, salary distribution, and other key HR metrics. Built using Power BI, this dashboard enables HR professionals to make data-driven decisions efficiently.

Features

• Interactive Power BI dashboard with dynamic filtering capabilities
• Visual analysis of employee demographics, attrition trends, and performance
• Salary distribution and compensation insights
• Hiring and retention trends
• Correlation analysis of factors affecting employee satisfaction and attrition

Dataset

The dataset includes information on employees from multiple departments and contains the following features:

• Employee ID, name, department, and tenure
• Salary details and compensation structures
• Employee performance ratings
• Attrition status and retention factors
• Demographic information such as gender, age, and experience

Project Structure

HR-Analytics-Dashboard/
├── HrDashboard.pbix        # Power BI project file
├── README.md               # Project documentation
└── datasets/               # Raw and processed datasets
    ├── employees.csv       # Employee data file
    ├── attrition.csv       # Attrition-related data
    └── salary.csv          # Salary details

Exploratory Data Analysis

The analysis covers:

• Employee Demographics: Distribution by age, gender, experience, and department.
• Attrition Trends: Identifying factors that contribute to employee turnover.
• Salary Insights: Distribution and comparisons of salaries across different job roles.
• Performance Metrics: Analyzing trends in employee performance ratings.
• Hiring & Retention Trends: Recruitment patterns and employee retention insights.

Key visualizations include:

• Attrition vs. Experience trend analysis
• Salary distribution histograms
• Performance rating heatmaps
• Department-wise employee breakdown
• Correlation matrix for attrition factors

Interactive Dashboard

The Power BI dashboard includes five main sections:

1. Employee Overview: Summary of employee demographics.
2. Attrition Analysis: Identifying key trends in employee turnover.
3. Salary Distribution: Insights into compensation trends.
4. Performance Metrics: Employee ratings and performance evaluations.
5. Recruitment & Retention: Hiring trends and retention patterns.

Installation and Usage

Prerequisites

• Power BI Desktop (Download from Microsoft Power BI)

Setup Instructions

1. Clone this repository:

   git clone https://github.com/yourusername/HR-Analytics-Dashboard.git
   cd HR-Analytics-Dashboard
   

2. Open HrDashboard.pbix in Power BI Desktop.

3. Interact with the dashboard by exploring different pages and using filters.

Insights

Some key findings from the analysis:

• Employees with 26-35 years of experience have the highest attrition rates.
• Salary disparities exist between different job roles and experience levels.
• Employees with higher performance ratings are more/less likely to leave the company.

Future Improvements

• Integration with real-time HR data for live analytics
• Predictive modeling for attrition and employee satisfaction
• Inclusion of sentiment analysis from employee feedback
• Automated reporting for HR teams

About the Author

Created by Rahul - Connect with me on LinkedIn!

License

This project is open source and available under the MIT License.