Tabellab

Lessons in this course

  1. The Headcount Question: Heads vs FTE for 24 PositionsLabFree
  2. Turnover Question: Average Headcount and the Leaver RateLab Locked
  3. Early Leaver Question: First-Year Leavers by Hire QuarterLab Locked
  4. Recruiting Question: Time-to-Fill and Offer AcceptanceLab Locked
  5. Cost per Hire Question: Pooled Cost by SourceLab Locked
  6. Pay Range Question 1: Compa-Ratio and Range PenetrationLab Locked
  7. Pay Range Question 2: Range Spread and Catch-Up CostLab Locked
  8. Merit Budget Question: Guideline Rates and a Scaled SplitLab Locked
  9. Absence Rate Question: Lost Days by TeamLab Locked
  10. Survey Question: Response Rates, Favourability, Small GroupsLab Locked
  11. Overtime Question: Overtime % and Premium Cost by TeamLab Locked
  12. Workforce Cost Question: Fully Loaded Cost per FTELab Locked
  13. Workforce Cost Forecast: FTE Plan, Pay Rise, Budget GapLab Locked
  14. Data Cleaning Take-Home 1: Duplicate Employee IDsLab Locked
  15. Data Cleaning Take-Home 2: Missing and Impossible DatesLab Locked
  16. Headcount Bridge Question: Opening to ClosingLab Locked
  17. Hiring Funnel Question: Applicants Needed per RoleLab Locked
  18. Rates Trap: Pooled Turnover vs Average of Hotel RatesLab Locked
  19. Presenting Results: KPI Table, Targets and StatusLab Locked
  20. Final Project: Timed Mock Case – Which Teams Need a Review?Lab Locked