Scenario: HR & Operations

Headcount, payroll prep, timesheet cleanup, employee data hygiene, and the dozen small reports that pile up.

Scenarios 7 lessons ~80 min

Meet Tomas, an HR coordinator. He's drowning in spreadsheets — exports from the HRIS, manager surveys, timesheet dumps. Here's how Python turns each one into a quiet five-minute job.

Lessons in this module

1. User story: monthly headcount report · 10 min
   Active employees by department, with hires/leavers.
2. User story: payroll prep · 11 min
   Take the timesheet dump, validate it, output the payroll-ready file.
3. User story: employee data hygiene · 9 min
   Names with stray spaces, missing managers, duplicate IDs.
4. User story: build the org chart programmatically · 9 min
   From a flat employee table to a parent-child hierarchy.
5. User story: engagement survey analysis · 10 min
   Turn 800 free-text + Likert responses into one summary file.
6. User story: PTO accrual and balances · 9 min
   How much vacation does each employee have, with the accrual rules baked in?
7. User story: new-hire onboarding tracker · 10 min
   Generate per-hire onboarding sheets from a master checklist.