Turning employee data into executive insights for smarter workforce decisions
Modern organizations generate vast amounts of workforce data — but without clear insights, it’s just numbers.
This project transforms raw HR data into an executive dashboard that answers critical questions:
Who is at risk of leaving, who is ready for promotion, and where should HR focus next?
The dashboard provides a 360° view of the workforce, helping leaders understand employee distribution, satisfaction, promotions, layoffs, and departmental trends.
| Metric | Count |
|---|---|
| Total Employees | 1,470 |
| Due for Promotion | 66 |
| Laid Off | 104 |
| Job Levels | 5 |
- 60% Male and 40% Female employees
- Majority of employees are concentrated in Level 1 and Level 2 roles
- Indicates a pyramid-shaped workforce structure
- Only 4.49% of employees are due for promotion
- Over 95% are not yet promotion-ready
Implication: Potential bottlenecks in career progression or strict promotion cycles.
- 7.07% overall layoff rate
- Managers show the highest layoff count
- Research & Development department has the largest combined layoff and promotion numbers
Implication: Possible restructuring or performance-based adjustments in critical departments.
- Largest group of employees falls under “No Satisfaction”
- Fewer employees report high satisfaction
Implication: Potential retention risks and need for engagement initiatives.
- Highest employee counts in 1–5 years of service
- Sharp decline in long-tenure categories
Implication: Workforce is relatively young, with fewer long-term employees.
- Workforce is heavily concentrated in entry-level roles
- Promotion readiness is very low across the organization
- Layoffs are focused in managerial and R&D roles
- Employee satisfaction levels may impact retention
- Organization has a predominantly early-career workforce
- Review promotion criteria and career pathways
- Investigate satisfaction drivers in low-score groups
- Monitor managerial attrition trends
- Implement retention programs for high-risk roles
- Track promotion pipelines quarterly
- Address satisfaction gaps in teams
- Monitor tenure-based attrition risks
- Focus on engagement for mid-level employees
| Page | Purpose |
|---|---|
| Home | Executive overview of workforce KPIs |
| Details | Department, role, and satisfaction analysis |
| Action | Lists of employees due for promotion or layoffs |
| Tool | Purpose |
|---|---|
 |
Dashboard development |
| DAX | KPI measures and calculations |
| Data Modeling | Relationship and metric design |
| Interactive Visuals | Executive storytelling |
⭐ Star this repo if you found it useful!
Built to turn HR data into smarter workforce decisions