📊 A Power BI dashboard for the HR department showing employee count, gender ratio, service years, promotion eligibility, retrenchment analysis, job satisfaction, and more – built with DAX, Power Query, and interactive navigation.
This Power BI project presents a complete HR Department Dashboard that helps visualize and analyze key HR metrics including employee demographics, service years, promotion eligibility, retrenchment risks, job satisfaction, and more.
https://github.com/daxesh38/HR-Dashboard/blob/main/HR%20Dashboard.pbix
This report is designed to help HR teams and management make data-driven decisions by providing:
- ✅ Total Employees count
- 👨💼 Male and 👩💼 Female distribution
- 📅 Service years breakdown
- 🟢 On-service vs 🔴 Retrenched employees
- 🎯 Due for Promotion vs Not Due
- 📊 Job Level and Satisfaction visualizations
- 🧭 Distance from office
- ⏰ Overtime Analysis
The report contains 3 pages:
- Key metrics summary
- Bar chart of Service Years
- Job Level distribution
- Pie chart of Distance from Office
- Promotion eligibility and retrenchment overview
- Table showing employees who are:
- Due for Promotion
- Will be Retrenched
- Stacked Bar Chart by Department (Retrenchment & Promotion)
- Job Satisfaction by Level (High, Medium, Low)
- Pie Chart for Overtime status
- Table of Job Roles with:
- Total Employees
- Promotion Due
- Retrenchment Count
- Cards, Bar Charts, Pie Charts, Donut Charts, Tables
- Page Navigation using buttons + bookmarks
CALCULATEDIVIDE- Basic measures for percentage calculations and counts
- Conditional Columns for data transformation and labeling
- Video Tutorial by Data with Decision
- https://www.youtube.com/watch?v=gFKNSmO8oyA
---
- Data with Decision for the tutorial
- ChatGPT (by OpenAI) for guiding on Power BI navigation buttons
📧 Email: [[email protected]]
🌐 LinkedIn: [https://www.linkedin.com/in/daxesh-patel-0a451a294/]