The EMPOWER360 HR Analysis Dashboard delivers a detailed overview of the organization’s workforce, including employee demographics, hiring and termination trends, performance metrics, and salary insights.
The dashboard supports HR teams in identifying workforce patterns and making data-driven decisions around employee retention and resource planning.
| Tool / Technology | Purpose |
|---|---|
| Power BI Desktop | Visualization & dashboard development |
| Power Query | Data cleaning, shaping, and preparation |
| DAX | KPI calculations & custom measures |
| Data Modeling | Relationship building & schema optimization |
- Total employees analyzed: 200
- 157 Active employees
- 43 Terminated employees
- Workforce distributed across Alexandria, Giza, and Cairo
- Includes multiple departments: Finance, IT, HR, Sales, Marketing
- Year-by-year view of new hires and terminations
- Department-level termination patterns
- Identification of HR areas needing attention
Comparison between Active and Terminated employees:
- Overtime hours
- Training hours
- Performance rating
- Sick days
These metrics help highlight trends connected to employee engagement and turnover.
Breakdown of salary metrics:
- Gross Salary
- Net Salary
- Base Salary
- Total Deductions
Includes comparison between Active and Terminated groups to understand compensation patterns.
Terminated employees show slightly higher overtime and sick days, which may suggest workload pressure or early disengagement.
Higher average salaries among terminated employees point toward the loss of more experienced or senior talent.
Overall retention sits at 78%, but certain departments show noticeably higher turnover.
- Improve workload management to reduce employee strain.
- Focus retention efforts on departments with high turnover.
- Reassess compensation structures to retain key talent.
- Monitor performance signals (overtime, sick days) to predict turnover risks early.
- Power BI data visualization
- DAX for advanced KPIs
- HR & workforce analytics
- Data cleaning and preparation
- Interactive dashboard design
- Data modeling and relationship management
🚀 How to Use
Download PowerBI_Report.pbix
Open the file in Power BI Desktop
Explore the dashboard using filters, slicers, and charts
📬 Contact
Anwaar Raafat
📧 Email:rafatanwaar@gmail.com
🔗 LinkedIn: https://www.linkedin.com/in/anwaar-raafat-590451204/
