MCMourad ChafiqiData Analyst
FREN
← Back to projects

Power BI · HR Analytics · People Analytics

HR 360
Workforce & People Analytics

A Power BI solution dedicated to workforce management. HR 360 consolidates workforce, absenteeism, turnover, performance, compensation, training and employee-journey data into decision-ready insights.

HR 360 dashboard
Main toolPower BI
Data preparationPower Query M
CalculationsDAX
DomainHR & People Analytics

Project context

Business need

Provide HR leadership and managers with a consolidated view of workforce, employee movements, absenteeism, retention, performance and employee development.

BI approach

Build a multi-fact HR Power BI model with shared dimensions, Power Query transformations, DAX measures, multi-page navigation and a detailed individual employee profile.

Key metrics

WorkforceHeadcount
AttendanceAbsenteeism Rate
MovementHires
MovementTerminations
RetentionTurnover Rate
RetentionRetention Rate
CompensationPayroll Cost
PerformancePerformance Score
QualityQuality Score
ProductivityProductivity Score
DevelopmentTraining Hours
CareerPromotion Recommendation

Technical highlights

Data model & calculations

Multi-fact HR model using Employee, Date, Department and Position dimensions, with controlled grains and DAX measures for workforce, turnover, retention, absenteeism, payroll and performance.

User experience & analysis

Employee 360 combines identity, job, manager, contract, work mode, career level, performance, compensation, skills, education, training, evaluations and exit information.

Technical challenges

Managing multiple HR grains

Challenge: monthly data, evaluations, training and job-history records do not share the same grain.
Solution: a multi-fact HR model with shared Employee, Date, Department and Position dimensions.
Result: consistent workforce, turnover, absenteeism, compensation and performance analysis.

Building an Employee 360 view

Challenge: an employee journey is distributed across multiple HR domains.
Solution: an individual profile combining job, manager, contract, career, compensation, performance, skills, training, attendance and exit information.
Result: a consolidated view of the employee journey.

Keeping HR KPIs dynamic

Challenge: HR indicators must remain consistent across time and organisational filters.
Solution: DAX measures and time calculations for headcount, turnover, retention, absenteeism, payroll and performance.
Result: dynamic analysis according to the selected period and HR dimensions.

Analytical insights

Turnover & retention

Combining hires, terminations, exit reasons and retention metrics makes it possible to identify workforce segments requiring deeper HR analysis.

Performance & development

The Employee 360 view connects performance, quality, productivity, skills, training and promotion recommendations so employee development can be analysed in context.

Dashboard pages

Executive Overview — workforce, hires, terminations, turnover, absenteeism and payroll.
Executive Overview — workforce, hires, terminations, turnover, absenteeism and payroll.
Workforce Analysis — workforce structure by department, business unit, position, city, age and work mode.
Workforce Analysis — workforce structure by department, business unit, position, city, age and work mode.
Attendance & Absenteeism — scheduled and worked days, absence, sick leave, paid leave and overtime.
Attendance & Absenteeism — scheduled and worked days, absence, sick leave, paid leave and overtime.
Turnover & Retention — hires, terminations, voluntary and involuntary turnover, retention and exit reasons.
Turnover & Retention — hires, terminations, voluntary and involuntary turnover, retention and exit reasons.
Employee Performance — performance, quality, productivity, evaluations and promotion recommendations.
Employee Performance — performance, quality, productivity, evaluations and promotion recommendations.
Employee Detail — 360° HR profile covering identity, career, compensation, skills, training, attendance and exit information.
Employee Detail — 360° HR profile covering identity, career, compensation, skills, training, attendance and exit information.

Skills demonstrated

Power BIPower Query MDAXData ModelingData QualityHR AnalyticsPeople AnalyticsWorkforce AnalyticsTurnover AnalysisAbsenteeism AnalysisPerformance AnalyticsCompensation AnalyticsKPI Design