Image 1 of 1
Image 1 of 1
Image 1 of 1
Image 1 of 1
Tracking HR metrics across disconnected spreadsheets costs time and produces inconsistent data. The HR Analytics Kit gives HR teams a complete, pre-built measurement infrastructure — six Excel dashboards covering the metrics that matter most, with formulas already built, sample data included, and a consistent design throughout.
The HR KPI Dashboard tracks 14 monthly metrics with automated YTD summary cards and a headcount trend chart. The Turnover Analysis Template combines a leaver log with an automated exit reason breakdown and turnover rate calculations. The Headcount Planning Dashboard connects current headcount, open roles, and hiring plan in a single view. The Diversity Metrics Dashboard tracks workforce composition by gender, level, and promotion equity — with a GDPR data protection notice included. The Recruiting Metrics Dashboard covers the full hiring funnel with source effectiveness and monthly trend reporting. The Training Effectiveness Dashboard tracks completion rates, pre and post assessment scores, participant ratings, and cost per head.
Every dashboard is delivered as a fully editable Excel file with pre-built formulas, sample data to illustrate the structure, and instant download access. No setup required.
What's included
– HR KPI Dashboard (14 metrics)
– Turnover Analysis Template
– Headcount Planning Dashboard
– Diversity Metrics Dashboard
– Recruiting Metrics Dashboard
– Training Effectiveness Dashboard
FAQs
Q Do I need to know Excel to use these dashboards?
Intermediate Excel skills are sufficient — you need to be comfortable entering data into cells and navigating between sheets, but you do not need to know how to write formulas. All formulas are pre-built. The dashboards are designed to work by entering your data in the clearly labelled input sheets; the calculations, summaries, and charts update automatically. Sample data is included in every dashboard so you can see how each one works before entering your own figures.
Q What HR metrics do the six dashboards cover between them?
The six dashboards cover: monthly headcount, new hires, leavers, open roles, days to fill, offer acceptance rate, eNPS, and absenteeism (HR KPI Dashboard); leaver exit reasons, voluntary vs involuntary turnover rates, and regrettable attrition (Turnover Analysis); current headcount by department and open role tracking by priority (Headcount Planning); workforce composition by gender, level representation, promotion equity, and disability disclosure (Diversity Metrics); application-to-hire funnel conversion, source effectiveness, and cost per hire (Recruiting Metrics); training completion rates, pre and post assessment scores, participant ratings, and cost per head (Training Effectiveness). Together they cover the full range of people metrics that HR teams and boards typically require.
Q Can I use these dashboards alongside the Word documents in the suite?
Yes — several dashboards are specifically designed to connect to the Word documents. The Turnover Analysis Dashboard connects to the Employee Offboarding Guide (both address exit data). The Training Effectiveness Dashboard connects to the L&D Strategy & IDP Template. The Diversity Metrics Dashboard connects to the DEI Audit & Action Plan. The Headcount Planning Dashboard connects to the Workforce Planning Framework. Buying the Complete Suite gives you both the documentation infrastructure and the measurement infrastructure as a unified system.
Q What is the difference between buying the HR Analytics Kit and buying dashboards individually?
Buying all six dashboards individually at $25 each costs $150. The HR Analytics Kit at $99 saves $51 — a 34% saving. The dashboards are also designed as a cohesive set using a consistent format, colour scheme, and data structure, so they work better as a complete measurement system than as individual tools. If you only need one specific dashboard, individual purchase makes sense; if you need three or more, the kit is the more efficient purchase.
Tracking HR metrics across disconnected spreadsheets costs time and produces inconsistent data. The HR Analytics Kit gives HR teams a complete, pre-built measurement infrastructure — six Excel dashboards covering the metrics that matter most, with formulas already built, sample data included, and a consistent design throughout.
The HR KPI Dashboard tracks 14 monthly metrics with automated YTD summary cards and a headcount trend chart. The Turnover Analysis Template combines a leaver log with an automated exit reason breakdown and turnover rate calculations. The Headcount Planning Dashboard connects current headcount, open roles, and hiring plan in a single view. The Diversity Metrics Dashboard tracks workforce composition by gender, level, and promotion equity — with a GDPR data protection notice included. The Recruiting Metrics Dashboard covers the full hiring funnel with source effectiveness and monthly trend reporting. The Training Effectiveness Dashboard tracks completion rates, pre and post assessment scores, participant ratings, and cost per head.
Every dashboard is delivered as a fully editable Excel file with pre-built formulas, sample data to illustrate the structure, and instant download access. No setup required.
What's included
– HR KPI Dashboard (14 metrics)
– Turnover Analysis Template
– Headcount Planning Dashboard
– Diversity Metrics Dashboard
– Recruiting Metrics Dashboard
– Training Effectiveness Dashboard
FAQs
Q Do I need to know Excel to use these dashboards?
Intermediate Excel skills are sufficient — you need to be comfortable entering data into cells and navigating between sheets, but you do not need to know how to write formulas. All formulas are pre-built. The dashboards are designed to work by entering your data in the clearly labelled input sheets; the calculations, summaries, and charts update automatically. Sample data is included in every dashboard so you can see how each one works before entering your own figures.
Q What HR metrics do the six dashboards cover between them?
The six dashboards cover: monthly headcount, new hires, leavers, open roles, days to fill, offer acceptance rate, eNPS, and absenteeism (HR KPI Dashboard); leaver exit reasons, voluntary vs involuntary turnover rates, and regrettable attrition (Turnover Analysis); current headcount by department and open role tracking by priority (Headcount Planning); workforce composition by gender, level representation, promotion equity, and disability disclosure (Diversity Metrics); application-to-hire funnel conversion, source effectiveness, and cost per hire (Recruiting Metrics); training completion rates, pre and post assessment scores, participant ratings, and cost per head (Training Effectiveness). Together they cover the full range of people metrics that HR teams and boards typically require.
Q Can I use these dashboards alongside the Word documents in the suite?
Yes — several dashboards are specifically designed to connect to the Word documents. The Turnover Analysis Dashboard connects to the Employee Offboarding Guide (both address exit data). The Training Effectiveness Dashboard connects to the L&D Strategy & IDP Template. The Diversity Metrics Dashboard connects to the DEI Audit & Action Plan. The Headcount Planning Dashboard connects to the Workforce Planning Framework. Buying the Complete Suite gives you both the documentation infrastructure and the measurement infrastructure as a unified system.
Q What is the difference between buying the HR Analytics Kit and buying dashboards individually?
Buying all six dashboards individually at $25 each costs $150. The HR Analytics Kit at $99 saves $51 — a 34% saving. The dashboards are also designed as a cohesive set using a consistent format, colour scheme, and data structure, so they work better as a complete measurement system than as individual tools. If you only need one specific dashboard, individual purchase makes sense; if you need three or more, the kit is the more efficient purchase.
