TRAINING & DEVELOPMENT · FIVE-DAY PROGRAM

HR Data Analytics
Turning people data into people decisions

Five days from spreadsheet user to people analyst - foundations to prediction, closing with a capstone you present to the room.

EXCEL · POWER BI · PYTHON 20 HANDS-ON EXERCISES CAPSTONE + 3 COACHING SESSIONS
5

days, each one deeper than the last

60%

hands-on, at your own laptop

2

realistic case organisations

3

coaching sessions after the course

THE FIVE-DAY JOURNEY

One climb, six stages

DAY 1

Foundations

The metrics that matter, clean data, Excel with PivotTables and formulas, and your first Power BI dashboard.

YOU LEAVE WITH

A one-page people dashboard and a verdict on a gut-feel claim

DAY 2

Data modelling and executive dashboards

Power Query, the data model, DAX and time intelligence - reports that update themselves.

YOU LEAVE WITH

A refreshable model and an executive attrition dashboard

DAY 3

Statistics and diagnostics

Beyond the average: distributions, correlation, segmentation, significance and driver analysis.

YOU LEAVE WITH

A written diagnosis of a turnover spike

DAY 4

Prediction with Python

Python from zero in the browser: pandas, an attrition model judged honestly, and the ethics of predicting people.

YOU LEAVE WITH

An attrition model and a responsible flight-risk report

DAY 5

The capstone

One dataset end to end - clean, analyse, model, visualise, recommend - presented to the room.

YOU LEAVE WITH

A five-minute recommendation to a CEO, graded

AFTER

Three coaching sessions

One hour each over three months, coaching you through a real people-data project at your organisation.

YOU LEAVE WITH

A data analytics project delivered at work

Join the way that fits. Take the complete five days, take Day 1 on its own as a foundations workshop, or join from Day 2 if you are already fluent with PivotTables.

Who it's for. HR professionals, business partners and managers who want evidence behind people decisions. No statistics or coding background is needed to start.

THE PROGRAM IN DETAIL

Day by day

1

Foundations

Speak the language of HR metrics, clean a messy 500-person export, analyse it with PivotTables and formulas, and build your first Power BI dashboard. Ends with a realistic case study: testing a manager's gut-feel claim against six months of absence data.

2

Data modelling

Stop rebuilding reports by hand. Power Query records your cleaning; the data model connects tables; DAX measures recalculate for every filter, with time intelligence for period comparisons. Close the day with an executive attrition dashboard.

3

Diagnostics

The honest analysis day. Distributions over averages, correlation without overreach, segmentation and cohorts, significance in plain terms, and driver analysis. Then diagnose a turnover spike hiding inside a healthy company number.

4

Prediction

Python from zero in the browser. pandas, then a working attrition model judged on precision and recall, and a full session on the ethics of prediction: bias, explainability, and keeping a human in the loop.

5

The capstone

Meridian Health is losing people faster than it can hire. The CEO asks where, why, who is next, and what to do. One dataset, the full journey, a five-minute presentation, and structured feedback against a clear rubric.

+

Coaching: implement it at work

After the five days, three one-hour coaching sessions over three months. Each participant chooses a real people-data project at their organisation - a dashboard, a turnover diagnosis, an attrition model - and we coach them from scoping to a result their leaders can act on.

BY THE END, YOU CAN
  • ▸Clean, model and connect people data so reports refresh themselves
  • ▸Build dashboards leaders actually read
  • ▸Diagnose the real cause behind a number, not the average
  • ▸Build a prediction and judge it honestly
  • ▸Name the limits of what data can claim, and say so to a CEO
HOW A DAY RUNS
09:00

Welcome, objectives and a short pre-test - no grades

09:30

Concepts in short bursts, each followed by an exercise

13:30

The Big Build - the day's anchor exercise, coached at your screen

15:30

Case study or capstone work, then a group debrief

16:15

Test yourself, answers, and back to your own question

EVERY PARTICIPANT TAKES HOME

Yours to keep

Five participant handbooks

Textbook-style, one per day, with worked solutions to every exercise

Every working file

Workbooks, Power BI data, notebooks and datasets, ready to rerun

A presented capstone

Your proof of skill, with structured feedback against the rubric

Excel · Power BI · Python

Three tools, one workflow - clean, analyse, model, present

Glossaries, checklists and formula cards

Every term and formula spelled out, ready to reuse at work

Two realistic case studies

A 500-person staff export and a 2,000-person capstone dataset

LOGISTICS
FORMAT
Five days, then three one-hour coaching sessions over three months
GROUP
8 to 15 participants
BRING
A laptop with Excel and Power BI Desktop, plus a free Google account for the Python day
DELIVERY
In-house at your site, or open enrolment
MATERIALS
Handbooks, files and datasets are yours to keep; all data is fictitious
LANGUAGE
English; Arabic edition on request