People Analytics for HR controllers

Video library

How-to walkthroughs for advanced Excel and Power BI, sorted by the challenge you are solving.

Tool

Topic

WatchExcel (advanced)03 Headcount and FTE

Headcount vs. FTE with dynamic arrays

One formula block that returns headcount, FTE and part-time share per month, per org unit — without a single helper column.

18 minAdvanced

02Excel (advanced)05 Attendance and sickness

Absence rate that survives partial months

Explode absence intervals into calendar days in Power Query, then report a target-hours based absence rate that reconciles with the time system.

24 minAdvancedWatch

03Power BI07 Turnover and retention

Turnover cohorts and 12-month survival in DAX

Move beyond the annual turnover ratio: cohort retention curves, early-leaver rates and a BDA-compliant turnover measure in one model.

31 minExpertWatch

04Excel (advanced)13 Personnel cost planning and scenarios

Personnel cost forecast with scenario switches

A driver-based bottom-up model: base pay, collective agreement increases, vacancy timing, employer contributions and provisions — with three scenarios on one switch.

38 minExpertWatch

05Power BI14 Dashboards and reporting

An HR KPI cockpit the board actually reads

Layout, drill paths and conditional formatting for a one-page cockpit: headcount, cost, absence, turnover and recruiting on a single canvas.

29 minAdvancedWatch

06Power BI01 Data integration, modelling & sample data

From HRIS export to a clean star schema

Turn one wide employee export into dimensions and facts, with slowly changing org units and a headcount snapshot fact table.

26 minAdvancedWatch

07Power BI06 Recruiting, preboarding & onboarding

Time-to-hire and funnel conversion done right

Why your time-to-hire looks too good, and how to measure stage duration, drop-off and source quality without double counting.

21 minIntermediateWatch

08Excel (advanced)04 Demographics and diversity

Age structure and retirement wave in one chart

A population pyramid plus a five-year retirement projection, driven entirely by formulas so it refreshes with the next export.

17 minAdvancedWatch

09Excel (advanced)01 Data integration, modelling & sample data

Reusable HR metrics with LAMBDA

Wrap your turnover, absence and FTE logic into named LAMBDA functions so every report in the company uses the same definition.

23 minExpertWatch