HR Headcount & Training Analytics
Build a department scorecard from synthetic employee records. Compare active headcount, salary totals and training hours, then explain the limits of a small sample.
Intermediate · 45–60 min
Objectives
- Separate active and inactive employees
- Summarize department cost
- Compare training coverage
- Write a privacy-conscious summary
Project dataset
| Row | A: Employee ID | B: Department | C: Salary | D: Training hours | E: Status |
|---|---|---|---|---|---|
| 2 | E001 | Operations | 30000 | 12 | Active |
| 3 | E002 | Operations | 30000 | 10 | Active |
| 4 | E003 | Operations | 30000 | 8 | Active |
| 5 | E004 | Operations | 30000 | 6 | Inactive |
| 6 | E005 | Finance | 45000 | 12 | Active |
| 7 | E006 | Finance | 45000 | 8 | Active |
| 8 | E007 | Sales | 35000 | 4 | Active |
| 9 | E008 | Sales | 35000 | 0 | Inactive |
Guided checkpoints
Count active staff
Count Active values in E2:E9.
Count active staff
Summarize department salary
Sum Salary for Operations in B2:B9.
Summarize department salary
Compare active training
Average Training hours where Status is Active.
Compare active training
Reconcile headcount
How many active employees are in the guided sample?
Reconcile headcount
Communicate without exposing identities
For a management dashboard, choose department totals or employee identities. Enter department totals.
Communicate without exposing identities
Download sample project .xlsx · All portfolio projects
Interactive practice runs in your browser.