HR Analytics Dashboard
Project Overview
This end-to-end Power BI project analyzes a workforce of nearly 60,000 employees to uncover the hidden drivers behind attrition and employee satisfaction. The goal was to transform raw HR data into actionable insights for leadership to improve retention and organizational health.
Dashboard Pages & Key Insights
1. Executive Overview
Purpose: High-level KPIs for leadership.
Metrics: Total Headcount, overall Attrition Rate, Average Salary, and Tenure.
Insight: Provides an immediate snapshot of the company’s stability and scale.
2. Attrition & Retention Analysis
Purpose: Identifying "Why" and "Where" people leave.
Metrics: Attrition by Job Role, Overtime impact, and Distance from Home.
Insight: Highlights high-risk departments and the correlation between work-life balance and turnover.
3. Compensation & Performance
Purpose: Analyzing pay equity and growth.
Metrics: Monthly Income by Gender and Job Level, and the link between Performance Ratings and Promotion frequency.
Insight: Ensures transparency in pay scales and evaluates if the company is "promoting from within" effectively.
4. Demographics & Work Environment
Purpose: Understanding workforce diversity and culture.
Metrics: Remote work adoption, age distribution, and sentiment analysis (Job Satisfaction & Company Reputation).
Insight: Assists in tailoring culture-building initiatives based on actual employee feedback and demographic needs.
Technical Toolkit (DAX & Modeling)
Advanced DAX: Created measures for Attrition % using CALCULATE and DIVIDE to handle dynamic filtering.
Data Transformation: Cleaned and structured 24+ columns for optimized performance.
Visualization: Used a mix of heatmaps, distribution charts, and KPI cards to ensure scannability.