People & Talent AnalyticsLatest project
Project objective
Give HR and leadership a single, trusted view of the workforce of a multi-company consulting group: headcount, hiring and leaving, turnover, age, seniority and absence — consistent month to month and across companies, countries and staff groups.
Behind the dashboard
- Seven-page report: Executive Summary, Headcount, Turnover, Average Age, Seniority, Absence Hours and Data Export
- Semantic model with 30+ tables and 130+ DAX measures built on monthly employee snapshots and hiring/leaving facts
- SAP HR (PPOME) organisational data migration, validated with SQL reconciliation and baseline checks
- Role-based cost visibility, custom SVG navigation and DAX performance tuning
- Developed as a Power BI Project (PBIP / TMDL) with version control
Interactive demo
Fictional companies and employees · try the filters and pagesPortfolio recreation with synthetic information. It reproduces the structure and logic of a client report without any real company or employee data.