People Analytics for HR controllers
Turn HR data into decisions
Step-by-step how-to videos in advanced Excel and Power BI, plus ready-to-use XLSX and PBIX templates for the questions HR controllers really get asked.
Everything here is free — no account, no paywall. The complex XLSX and PBIX files are sent by email.
9
Videos
12
Templates
Built for the daily work of HR controlling
Real controlling problems
Headcount vs. FTE, absence rates, turnover cohorts, personnel cost forecasts — modelled the way auditors and CFOs expect.
Advanced, not beginner
Dynamic arrays, LET/LAMBDA, Power Query, star schemas, DAX time intelligence and row-level security.
Take the file with you
Every video ships with the workbook or PBIX file and a short PDF that explains the logic.
Featured how-tos
View all →Popular downloads
View all →Auditable headcount & FTE reporting
XLSX · 1.2 MB
Age structure & retirement wave
XLSX · 0.7 MB
Absence rate calculator
XLSX · 0.3 MB
Learning units
HR KPI cockpit in Power BI — 5 steps
From a raw HRIS export to a one-page cockpit with headcount, cost, absence, turnover and recruiting KPIs.
Open →Learning units
Audit-proof headcount reporting in Excel
Build one headcount and FTE model that HR, finance and the works council can all sign off.
Open →Seminars
Prefer learning live?
I run German-language seminars and a certified programme on HR controlling, workforce planning and HR analytics.