HR Analytics Dashboard (Power BI)

This project presents a comprehensive and interactive HR Analytics Dashboard built using Power BI, leveraging the HRDataset_v14 dataset. The dashboard helps analyze employee attrition, department-wise distribution, salary trends, and hiring sources — enabling data-driven decision-making for HR professionals.

Dashboard Highlights

Total Headcount: 135 employees
Total Salary Paid: ₹70.63K
Total Attritions: 44 employees
Attrition Rate: 32.59%
Average Age: 46.29 years

Dataset Overview

Dataset Used: HRDataset_v14
Key Attributes:

EmployeeID
Department
Position
EmpStatus
Gender
DateofHire
RecruitmentSource
Salary
Age
Attrition

Key Visuals

Headcount by Department
Headcount by Age Bucket & Marital Status with Gender
Attrition Trends by Date of Hire
Recruitment Source Analysis
Cumulative Hiring Curve
Attrition by Time Series

Filters & Interactivity

The dashboard includes interactive slicers to drill down into the data:

Department
Position
Employment Status
State
Gender

These filters allow for customized, slice-and-dice analysis.

Insights Derived

Production has the highest headcount.
Age group 26–35 dominates the workforce.
Majority of employees are married males.
Most hiring happens via LinkedIn and Indeed.
Hiring has steadily increased since 2010, with some attrition spikes around certain years.

These findings can guide recruitment strategies, retention plans, and future workforce planning.

Tools & Technologies Used

Power BI Desktop
DAX Measures & Calculated Fields
Custom Visuals
Color-Themed UI for Clean Layout

How to Use

Clone or download this repo
Open HR-Analytics-Dashboard.pbix in Power BI Desktop
Ensure HRDataset_v14.xlsx is placed in the same directory
Refresh the data → Explore the visuals and insights

Future Enhancements

Attrition Forecasting with ML models
Employee Sentiment Analysis if satisfaction data is added
Integration with Python/R scripts in Power BI

VisvaV/HR-Analytics-Dashboard