One Course
Every lesson, project and mock exam in HR analytics.
Billed monthly. Cancel any time.
Level 1: Newcomer
0 points
Sign in to save your progress across devices.
Courses / Business and operations
Build people reports on original fictional records. Calculate headcount, FTE, turnover and retention, analyze recruiting and salary bands, and check engagement survey results in Excel, SQL and Python.
Unit 1, People, positions and snapshots: 5 lessons and 24 checked exercises, with no account or card.
Start the free unitThe rest of the course opens with a One Course or All Access plan. See plans and prices
Choose access here. Your course is already selected.
Distinguish application-to-acceptance time from requisition-to-acceptance time.
8 steps · 30 minProject · AdvancedCohorts and exposureCompare people who had the same chance to experience an outcome.
8 steps · 30 minProject · ExpertWorkforce reportProduce a query pack that another analyst can rerun.
6 steps · 35 minProject · ExpertRecruiting reportBuild a recruiting report with distinct hiring clocks, offer acceptance and open requisition age.
6 steps · 35 minCase study · ExpertSalary comparisonInvestigate salary position using normalized pay, band measures and the median.
6 steps · 35 minProject · ExpertSurvey reportPrepare a survey report with valid participation, item scoring and small-group suppression.
6 steps · 35 minMock exam · ExpertHR analyst job test AComplete a forty-minute HR analyst job test covering workforce, recruiting, compensation and surveys.
12 questions · 40 minMock exam · ExpertHR analyst job test BComplete a second forty-minute HR analyst job test on fresh records and different metric combinations.
12 questions · 40 minPractice HR analytics on original fictional people data. Define headcount and FTE, calculate turnover and retention, measure recruiting time, compare salary bands and analyze engagement surveys. You work in Excel, a SQL editor and a pandas notebook. Each answer is checked on the visible data and a hidden second copy, with feedback that names a likely mistake. Projects build report queries, interviews test the reasoning, and two timed job tests bring the measures together. The course teaches analysis and metric definitions, without claiming an HR certification or a legal assessment.
Beginner
Count the population before you calculate a rate.
Build a spreadsheet calculation that survives a changed input.
Find duplicates, missing values and records that cannot be reconciled.
Intermediate
Define the exits, period and population behind a turnover rate.
Distinguish application-to-acceptance time from requisition-to-acceptance time.
Compare equivalent salary amounts with the correct band.
Advanced
Keep invitations, respondents and answered items separate.
Reproduce people metrics in a pandas notebook.
Compare people who had the same chance to experience an outcome.
Expert
Reconcile totals and investigate differences before making a claim.
Produce a query pack that another analyst can rerun.
Apply the definitions without relying on a remembered answer.
No. The spreadsheet, SQL editor and pandas notebook run in your browser. The data is fictional.
Each exercise states its definition. For example, the turnover tasks use average opening and closing headcount; the retention tasks follow the people present at the start.
No. The course teaches practical HR analysis and includes original hiring-style tests. It does not award an HR credential.
The first unit is free. The pricing page explains access to the rest of the course.