An interactive HR Analytics Dashboard built in Microsoft Power BI to help HR teams monitor workforce metrics, employee performance, promotions, attrition, and department-wise insights through dynamic visualizations.
Note: Update the image paths if your screenshots have different filenames.
The goal of this dashboard is to provide HR managers and decision-makers with a complete overview of employee information, allowing them to:
- Monitor workforce size
- Analyze employee demographics
- Track promotions
- Identify employees at risk of retrenchment
- Measure job satisfaction
- Analyze department performance
- Support HR decision making using interactive dashboards
The dashboard is built using an HR employee dataset containing information such as:
- Employee ID
- Gender
- Age
- Department
- Job Role
- Marital Status
- Job Level
- Years at Company
- Distance from Home
- Job Satisfaction
- Promotion Status
- Attrition Status
Provides a high-level overview of the organization.
- Total Employees
- Male Employees
- Female Employees
- High Rated Employees
- Low Rated Employees
- Employee by Job Satisfaction
- Employee by Department
- Employee by Marital Status
- Employee Working Overtime
- Job Role Summary
- Employees Due for Promotion
- Employees Eligible for Retrenchment
Focuses on employee lifecycle and workforce distribution.
- Due for Promotion
- Not Due for Promotion
- Employees in Service
- Retrenched Employees
- Service Years
- Job Levels
- Distance Status
- Very Close
- Close
- Very Far
Detailed employee-level information.
Includes:
- Employees Due for Promotion
- Employees Eligible for Retrenchment
- Department-wise comparison
- Employee tables with filtering and searching
The dashboard enables users to quickly answer questions such as:
- How many employees are currently working?
- What is the male-to-female ratio?
- Which departments have the highest workforce?
- Which employees are due for promotion?
- Which employees are likely to be retrenched?
- How satisfied are employees with their jobs?
- Which job roles have the highest employee count?
- What is the employee distribution by service years?
- What percentage of employees work overtime?
- Microsoft Power BI Desktop
- Power Query
- DAX (Data Analysis Expressions)
- Data Modeling
HR_Dashboard/
│
├── dataset/
│ └── HR Dataset.xlsx
│
├── Pics/
│ ├── Executive Summary.png
│ ├── Employee Overview.png
│ └── Employee Details.png
│
├── HR Dashboard.pbix
│
└── README.md
- Interactive dashboard
- Dynamic filtering
- KPI cards
- Department analysis
- Promotion tracking
- Retrenchment analysis
- Employee demographic insights
- Professional HR reporting
- Executive Dashboard
- Employee Overview
- Employee Details
- Monthly hiring trends
- Attrition prediction using Machine Learning
- Salary analysis
- Diversity & Inclusion metrics
- Recruitment analytics
- Leave management dashboard
- Employee performance trends
Kadhiravan Arasu
Final Year B.Tech Information Technology Student
Passionate about Data Analytics, Power BI, SQL, Python, and Machine Learning.