The Power BI Template has 24 metrics calculated and ready for use.


  1. Skill Needed Employees 
    • Distinct count of employees that are active now and have an expected skill level of not None in at least one skill.
  2. Underskilled Employees
    • # of active Employees with at least one skill at a level less than expected skill level.  
  3. Underskilled Employee %
    • % of employees that are underskilled and need to upskill. [Underskilled Employees/Skill Needed Employees]
  4. Training Seats
    • Number of seats for all Trainings
  5. Available Training Seats
    • Number of Seats available in Ongoing Trainings
  6. Overbooked Training Seats
    • Number of Seats overbooked in Ongoing Trainings
  7. Avg. Rating of Training
    • Average of rating from enrollments with Status 'Completed' with training date during date range
  8. Enrollments per Training
    • Average number of enrollments per training. Enrollments / Count of Trainings.
  9. Completed Trainings
    • Number of enrollments with Status 'Completed' with training date during date range
  10. Completion %
    • % of enrollments that were completed. [Completed Trainings/Enrollments]. Training date should be during the date range selected.
  11. Investment per Employee
    • Average investment for training per active employee.  [Training Cost / Headcount]
  12. Cost per Enrollment
    • Average cost of training per enrollment.  [Training Cost / Enrollments]. Training Date should be during the date range selected.
  13. Enrolled Employees
    • Number of distinct employees with enrollments with Status not 'Cancelled' with training date during date range
  14. Enrollment %
    • % of active employees who enrolled in training during date range. [Enrolled Employees / Headcount]. Headcount represents the headcount at the end of the date range selected.
  15. Enrollments
    • Number of enrollments with Status not 'Cancelled' with training date during date range
  16. Hours Trained
    • Number of hours of training by employees who enrolled during the date range, and Enrollment Status = Completed
  17. Count of Trainings
    • Number of trainings available during the date range
  18. Training Benefits
    • Total Benefits of all enrollments with training date during date range. Only Completed trainings are included.
  19. Training Cost
    • Total Cost of all enrollments with training date during date range. Cancelled enrollments are excluded.
  20. Training Hours per Employee
    • Average hours of training completed per active employee. [Hours Trained/Headcount]
  21. Training ROI
    • Return on Investment for training. (Benefits - Cost) / Cost
  22. Ending Headcount
    • Active Employee Count at the End of the date range. If no date filters are applied, this will be the latest active employee count.
  23. Starting Headcount
    • Active Employee Count at the Beginning of the date range selected.
  24. Average Headcount
    • Average Headcount during the date range selected. (Starting Headcount + Ending Headcount)/2