Administration


  • 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.
  • Average Headcount
    • Average Headcount during the date range selected. (Starting Headcount + Ending Headcount)/2
  • Average Tenure
    • Average of Tenures of Active Employees



  • Median Tenure
    • Median of Tenures of Active Employees as of end of selected period
  • Median Tenure at Exit 
    • Median tenure of employees who exited during date range. Tenure measured as of exit date.
  • Median Age
    • Median of Age, as of end of selected period, of Active Employees
  • Voluntary Exits
    1. Distinct count of employees who exited during the date range with exit type Voluntary (ID 1)
  • Involuntary Exits
    1. Distinct count of employees who exited during the date range with exit type ID 2 (involuntary).
  • Voluntary Turnover Rate
    1. Voluntary Exits during date range / Average Headcount during date range. Average headcount =  [(Active employees at start + Active employees at end)/2]
  • Involuntary Turnover Rate
    • Involuntary Exits during date range / Average Headcount during date range. Average headcount = [(Active employees at start + Active employees at end)/2]
  • Maximum Annual Salary
    • Maximum of Actual Salaries of Active Employees as of End of selected period
  • Minimum Annual Salary
    • Minimum of Actual Salaries of Active Employees as of end of selected period
  • Median Salary at Review
    • Median of salaries of employees as of the performance review date based on reviews conducted during the review periods selected.
  • Median Annual Salary
    • Median of salaries of employees active at end of period selected
  • Total Annual Salary
    • Sum of salaries of employees active at end of period selected
  • Average Annual Salary
    • Average of Annual Salaries of active employees at any point of time
  • Total Exits
    •  Distinct count of employees who exited during the date range.
  • Retention Rate
    • Out of Employees who were active at start of date range, how many were active as of end of date range. Expressed as %.  Should have started prior to date range.
  • Turnover Rate
    • Total Exits during date range / [(Active employees at start + Active employees at end)/2]; Employees at start will be employees as of start date of range.
  • Starting Headcount
    • Active Employee Count at the Beginning of the date range selected.
  • Total Starts
    • Distinct Count of employees who started during the date range.
  • Regrettable Exits
    • Number of employees who exited voluntarily the company during date range with a regrettable exit
  • Regrettable Exits %
    • % of regerettable exits out of all voluntary exits during date range


  • Headcount Change MOM
  •   Headcount Change YOY
  • New Joiners
  • Eligible Joiners
  • 90 Day Leavers
  • 90 Day Churn Rate
  • Being Onboarded
  • Onboarding Completions
  • Onboarding Completed %
  • Avg. Onboarding Time

 


Recruitment


  1. Hired Positions
    • Number of applications hired during the date range. Applications with HIRED status and Hire date during the date range.
  2. Hiring Cost
    • Sum of costs of applications received with Hire date during the date range
  3. Cost per Hire
    • Average cost of hiring a candidate for a job. [Hiring cost / Hired Positions]
  4. Avg Days to Fill
    • Average number of days between Job Posted and Employee Join Date (+1) for applications with Hire date during the date range
  5. Avg Days to Hire
    • Average number of days between Application date and Candidate Hire date (+1) for applications with Hire date during the date range
  6. Percent of All Hires
    • % of Hires coming from a selected application source out of all Hired applications regardless of source. [Number of Hired Positions with selected application source / All Hired Positions]
  7. Avg Days taken for each stage
    • Number of days taken from one stage of recruitment to next. 1 day is added only for the first stage (application)
  8. Avg Days Hire to Join
    • Average number of days taken from HIRE DATE to JOIN DATE for hired applications during date range
  9. Applications
    • Number of applications received during the date range. Application Received date is the Stage 1 (of Recruitment) Date.
  10. Offer %
    • % of Applications reaching Offer Stage (or Hire Stage) out of all Applications Received. Offer Stage is the penultimate stage. Application received date during the date range selected.  
  11. Offer Acceptance %
    • % of Applications hired out of all applications reaching offer stage. Application received date during the date range selected.  
  12. Conversion %
    • % of Applications received that got Hired. [Number of Applications Hired/ Number of Applications Received]
  13. Applications reaching a stage
    • Count of Applications reaching a specific recruitment Stage.
  14. Open Jobs
    • Number of jobs currently in open status.
  15. Avg Days in Market
    • Average Number of days in market for all jobs with status OPEN.
  16. Pending Applications
    • Number of Applications which have not been decided on yet. Applications with blank Application status, received for jobs with OPEN status.
  17. Applications per Open Position
    • Average Number of Applications pending per Open Job. [Pending Applications / Open Jobs]
  18. # of Recruitment Stages
    • Number of Stages in Recruitment or Hiring process
  19. Applications Hired
    • Number of Applications which were received during the date range and got HIRED at any point of time
  20. Offers given
    • Number of applications received during the date range selected and reaching Offer Stage.


Training



  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



Performance


  1. 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.
  2. Average Headcount
    • Average Headcount during the date range selected. (Starting Headcount + Ending Headcount)/2
  3. Average Tenure
    • Average of Tenures of Active Employees
  4. Performance Reviews
    • Number of performance reviews during the date range
  5. 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.
  6. Underskilled Employees
    • # of active Employees with at least one skill at a level less than expected skill level.  
  7. Underskilled Employees %
    • % of employees that are underskilled and need to upskill. [Underskilled Employees/Skill Needed Employees]
  8. High Performers %
    • % of employees with High performance score for the period chosen or the date range. (High Performers/ Total number of Performance Reviews)
  9. Low Performers %
    • % of employees with Low performance score for the period chosen or the date range. (Low Performers/ Total number of Performance Reviews)
  10. Median Tenure
    • Median of Tenures of Active Employees as of end of selected period
  11. Median Tenure at Exit 
    • Median tenure of employees who exited during date range. Tenure measured as of exit date.
  12. Median Age
    • Median of Age, as of end of selected period, of Active Employees
  13. Voluntary Exits
    1. Distinct count of employees who exited during the date range with exit type Voluntary (ID 1)
  14. Involuntary Exits
    1. Distinct count of employees who exited during the date range with exit type ID 2 (involuntary).
  15. Voluntary Turnover Rate
    1. Voluntary Exits during date range / Average Headcount during date range. Average headcount =  [(Active employees at start + Active employees at end)/2]
  16. Involuntary Turnover Rate
    • Involuntary Exits during date range / Average Headcount during date range. Average headcount = [(Active employees at start + Active employees at end)/2]
  17. Maximum Annual Salary
    • Maximum of Actual Salaries of Active Employees as of End of selected period
  18. Minimum Annual Salary
    • Minimum of Actual Salaries of Active Employees as of end of selected period
  19. Median Salary at Review
    • Median of salaries of employees as of the performance review date based on reviews conducted during the review periods selected.
  20. Median Annual Salary
    • Median of salaries of employees active at end of period selected
  21. Total Annual Salary
    • Sum of salaries of employees active at end of period selected
  22. Average Annual Salary
    • Average of Annual Salaries of active employees at any point of time
  23. Total Exits
    •  Distinct count of employees who exited during the date range.
  24. Retention Rate
    • Out of Employees who were active at start of date range, how many were active as of end of date range. Expressed as %.  Should have started prior to date range.
  25. Turnover Rate
    • Total Exits during date range / [(Active employees at start + Active employees at end)/2]; Employees at start will be employees as of start date of range.
  26. Starting Headcount
    • Active Employee Count at the Beginning of the date range selected.
  27. Total Starts
    • Distinct Count of employees who started during the date range.
  28. Regrettable Exits
    • Number of employees who exited voluntarily the company during date range with a regrettable exit
  29. Regrettable Exits %
    • % of regerettable exits out of all voluntary exits during date range


Time Management

  1. Availability %

    • % of Total Capacity that is actually available. Calculated as (Available Capacity Man Days / Total Capacity Man days)

  2. Total Capacity (Man Days)

    • Total # of Man Days of capacity during the date range selected. For example, in a week of 5 working days (excluding weekends and holidays) where 10 employees are employed, the total capacity is 10*5 = 50 Man days.

  3. Leave (Man Days)

    • Total # of Man Days of leave planned/taken during the date range selected. For example, in a week of 5 working days (excluding weekends and holidays) where 2 employees are taking leave every day, the total Leave Man days is 5*2 = 10.

  4. Available Capacity (Man Days)

    • Total # of Man Days of Capacity Available to use during the date range selected. For example, in a week of 5 working days with 10 employees, with 2 employees taking leave every day, Total capacity is 5*10 = 50, Leave is 5*2 = 10 and hence Available capacity is 50 - 10 = 40 Man Days.

  5. Employees on Leave

    • Distinct count of Employees who are on leave on working days during date range selected.

  6. Starting Headcount

    • Active Employee Count at the Beginning of the date range selected.

  7. 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.

  8. Average Headcount

    • Average Headcount during the date range selected. (Starting Headcount + Ending Headcount)/2

  9. Calendar Days

    • Number of Calendar days during the date range selected.  

  10. Working days

    • Number of Working Days during the date range selected. Number of Calendar days excluding days which are either weekend and/or holidays.  

  11. Non-Working Days

    • Number of non-working days (holidays and weekends) during the date range selected

  12. Weekend Days

    • Number of days that fall in the weekend days during the date range selected. Weekend days are selected in the Weekend table according to company policies.

  13. Holidays

    • Number of Holidays during the date range selected.