HR Operations Dashboard
HR Analytics Dashboard – Power BI Project
This interactive HR dashboard was developed in Power BI to provide a unified, data-driven view of human resources performance across key areas: demographics, employee attrition, and individual satisfaction. It enables HR teams to move from reactive reporting to proactive workforce planning.
📍 The Problem
In many organizations, HR data is siloed and managed manually across tools like Excel or legacy systems. This creates several challenges:
- ❌ No centralized view of workforce structure and dynamics
- ❌ Slow, manual demographic and attrition analysis
- ❌ Lack of visibility into employee satisfaction over time
- ❌ Difficult to detect early attrition risks or diversity imbalances
✅ What This Dashboard Solves
| Problem | Solution Provided |
|---|---|
| Fragmented employee data | Unified interactive dashboard in Power BI |
| No real-time attrition insights | Dynamic visualizations by role, travel, tenure |
| Hidden DEI issues | Ethnicity breakdowns paired with average salary |
| Hard to assess satisfaction trends | Individual performance tracker by year |
| Static reports | Slicers and filters for on-demand exploration |
📊 1. Demographics Overview
This page outlines the composition of the workforce by age, gender, marital status, and ethnicity, with salary comparisons included.
Highlights:
- Most employees are aged 20–29.
- Balanced gender representation across all age groups.
- White employees dominate headcount; Native Hawaiian group shows the highest average salary.
- Age diversity ranges from 18 to 51 years old.
📉 2. Attrition Analysis
The organization’s overall attrition rate is 16.1%, with detailed breakdowns to uncover underlying causes.
Visuals Include:
- Attrition by job role and department: Sales Reps and Recruiters face the highest turnover.
- Attrition by travel frequency: Frequent travelers are more likely to leave.
- Attrition by overtime: Those required to work overtime show over 2x attrition compared to others.
- Attrition by tenure: Highest risk in the first 1–2 years of employment.
- Attrition by hire year: Notable spikes in 2016 and 2020 cohorts.
📈 3. Performance Tracker
This module lets HR review individual employee journeys in terms of satisfaction, work-life balance, and management perception.
Case Example – Estelle Chung:
- Joined: 07/15/2018
- Last review: 03/24/2022
- Satisfaction metrics (Job, Manager, Environment) have declined since 2018.
- Indicates potential disengagement or role misalignment.
Tracked Metrics:
- Job satisfaction
- Manager rating
- Relationship satisfaction
- Work-life balance
- Environment satisfaction
- Self-rating
📅 4. Attrition Trends Over Time
An extended view of attrition rates over time provides longitudinal analysis:
- Employees hired in 2016 and 2020 show higher-than-average attrition.
- Most departures occur within the first 2 years, stressing the need for improved onboarding or early engagement strategies.
🛠️ Tools & Technologies Used
- Power BI: Visualization, DAX calculations, data modeling
- Dataset: Simulated HR dataset including demographics, performance, and exit data
- Features: Custom slicers, KPI cards, bar & line charts, drill-through filters
🎯 Business Impact
This HR dashboard transforms workforce management by:
- Enabling real-time, interactive analysis for stakeholders
- Supporting diversity and inclusion initiatives
- Reducing attrition through early detection
- Helping HR and executives make informed, strategic decisions