Onboarding Metrics Dashboard and Effectiveness Diagnosis

Design a onboarding metrics dashboard structure for [COMPANY NAME], which hires [NUMBER] people monthly, using [TOOL: Factorial/Gupy/Power BI/Google Sheets].\\\\\\\\n\\\\\\\\n**Primary KPIs (required):**\\\\\\\\n\\\\\\\\n1) **Time to Productivity:**\\\\\\\\n- Definition: time until the employee reaches [PRODUCTIVITY CRITERION]\\\\\\\\n- Industry benchmark: [NUMBER] days\\\\\\\\n- Target: [NUMBER] days\\\\\\\\n- Data source: [SYSTEM]\\\\\\\\n\\\\\\\\n2) **Early Turnover (0-90 days):**\\\\\\\\n- Formula: (separations 0-90 days / hires in period) × 100\\\\\\\\n- Voluntary vs. involuntary (separate these)\\\\\\\\n- Estimated cost per early separation: $[AMOUNT]\\\\\\\\n\\\\\\\\n3) **Onboarding NPS:**\\\\\\\\n- Survey administered at days 7, 30, and 90\\\\\\\\n- Suggested questions (10 questions, 0-10 scale)\\\\\\\\n- Segment by: department, manager, mode (in-person/remote)\\\\\\\\n\\\\\\\\n4) **Program Completion Rate:**\\\\\\\\n- % of steps completed on schedule\\\\\\\\n- Steps with highest dropout/delay rates\\\\\\\\n\\\\\\\\n**Secondary KPIs (for deeper analysis):**\\\\\\\\n\\\\\\\\n5) **Buddy Satisfaction Score:**\\\\\\\\n- Bidirectional evaluation (new employee → buddy and buddy → new employee)\\\\\\\\n\\\\\\\\n6) **Manager Readiness:**\\\\\\\\n- Did the manager complete the preparation checklist? (yes/no per hire)\\\\\\\\n\\\\\\\\n7) **Compliance Rate:**\\\\\\\\n- Pre-employment medical exam completed on time\\\\\\\\n- Required safety training completed\\\\\\\\n- Payroll/HR system without pending items\\\\\\\\n\\\\\\\\n8) **90-Day Engagement:**\\\\\\\\n- Engagement score (pulse survey) for new hires vs. overall average\\\\\\\\n\\\\\\\\n**Dashboard visualizations:**\\\\\\\\n\\\\\\\\n- Overview: traffic light (green/yellow/red) for all KPIs\\\\\\\\n- Funnel: candidate → hired → 30 days → 60 days → 90 days (survival rate)\\\\\\\\n- Heatmap: NPS by department × month\\\\\\\\n- Scatter plot: time to productivity by seniority level\\\\\\\\n- Manager ranking: highest and lowest onboarding NPS\\\\\\\\n\\\\\\\\n**Automated alerts:**\\\\\\\\n- New employee without 1:1 meeting in week 1\\\\\\\\n- Pre-employment medical exam not recorded within 48 hours\\\\\\\\n- NPS below [SCORE] at any point\\\\\\\\n- Early turnover above [%] in any department\\\\\\\\n\\\\\\\\n**Monthly report:**\\\\\\\\n- One-page template with key insights\\\\\\\\n- Recommended actions based on data\\\\\\\\n- Month-over-month comparison\\\\\\\\n\\\\\\\\nConsider integration with [HRIS: FACTORIAL/GUPY/SYSTEM] via API or CSV export.