Image 1 of 1
Image 1 of 1
Image 1 of 1
Image 1 of 1
Training investment without measurement is activity without accountability. This dashboard gives HR and L&D teams a complete picture of training effectiveness across every program.
Training Log: records each training event — program, category, delivery method, department, participants, completion rate, pre and post assessment scores (score improvement calculates automatically), manager rating, participant rating, cost, and whether skills were applied on the job.
Program Summary: automatically aggregates total participants, average completion rate, average score improvement, average rating, total cost, and cost per participant for each program.
Dashboard: seven YTD KPIs and a six-category breakdown (Leadership, Compliance, Technical, DEI, Wellbeing, Other) with participants, average rating, and total cost per category.
FAQS
Q How does the pre/post assessment score improvement calculation work?
The Training Log sheet includes a Pre-Assessment Score column and a Post-Assessment Score column. The Score Improvement column is a formula (Post minus Pre) that calculates automatically when you enter both scores — no manual calculation needed. Scores are typically on a 0–100 scale. The Program Summary sheet then averages score improvement across all sessions of each program, giving a reliable measure of knowledge gained.
Q What does the dashboard show at the category level?
For each training category (Leadership, Compliance, Technical, DEI, Wellbeing, Other): total number of programs delivered, total participants, average participant rating, and total cost. This allows HR and L&D leads to see at a glance where training investment is concentrated and where participant satisfaction is highest or lowest — enabling better budget allocation decisions.
Q How is cost per participant calculated?
Total cost for a program divided by total participants across all sessions of that program. This is automatically calculated in the Program Summary sheet. Comparing cost per participant across programs and delivery methods — for example, comparing a facilitated in-person workshop at £200 per head against an e-learning module at £0 per head — helps optimize L&D investment for impact and efficiency.
Q Does the dashboard track whether training was applied on the job?
Yes. The Training Log includes an 'Applied on Job?' column (Yes / Partial / No) that is typically populated by the manager at the 30-day follow-up after training. This is the most important metric for demonstrating real training ROI — whether knowledge gained in training actually changed on-the-job behaviour. The Program Summary sheet aggregates this by program.
Training investment without measurement is activity without accountability. This dashboard gives HR and L&D teams a complete picture of training effectiveness across every program.
Training Log: records each training event — program, category, delivery method, department, participants, completion rate, pre and post assessment scores (score improvement calculates automatically), manager rating, participant rating, cost, and whether skills were applied on the job.
Program Summary: automatically aggregates total participants, average completion rate, average score improvement, average rating, total cost, and cost per participant for each program.
Dashboard: seven YTD KPIs and a six-category breakdown (Leadership, Compliance, Technical, DEI, Wellbeing, Other) with participants, average rating, and total cost per category.
FAQS
Q How does the pre/post assessment score improvement calculation work?
The Training Log sheet includes a Pre-Assessment Score column and a Post-Assessment Score column. The Score Improvement column is a formula (Post minus Pre) that calculates automatically when you enter both scores — no manual calculation needed. Scores are typically on a 0–100 scale. The Program Summary sheet then averages score improvement across all sessions of each program, giving a reliable measure of knowledge gained.
Q What does the dashboard show at the category level?
For each training category (Leadership, Compliance, Technical, DEI, Wellbeing, Other): total number of programs delivered, total participants, average participant rating, and total cost. This allows HR and L&D leads to see at a glance where training investment is concentrated and where participant satisfaction is highest or lowest — enabling better budget allocation decisions.
Q How is cost per participant calculated?
Total cost for a program divided by total participants across all sessions of that program. This is automatically calculated in the Program Summary sheet. Comparing cost per participant across programs and delivery methods — for example, comparing a facilitated in-person workshop at £200 per head against an e-learning module at £0 per head — helps optimize L&D investment for impact and efficiency.
Q Does the dashboard track whether training was applied on the job?
Yes. The Training Log includes an 'Applied on Job?' column (Yes / Partial / No) that is typically populated by the manager at the 30-day follow-up after training. This is the most important metric for demonstrating real training ROI — whether knowledge gained in training actually changed on-the-job behaviour. The Program Summary sheet aggregates this by program.
