From HRIS export to a clean star schema

Name: From HRIS export to a clean star schema
Description: Turn one wide employee export into dimensions and facts, with slowly changing org units and a headcount snapshot fact table.

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

Power BI01 Data integration, modelling & sample dataAdvanced26 min

The recording for this walkthrough is being published — the files below already contain the full model.

What you will build

01Decide what is a fact and what is a dimension in HR data
02Generate monthly snapshots without exploding the model
03Handle reorganisations and renamed cost centres

Dataset used

A single denormalised HRIS export with 60 columns.