How to Track KPI

by Pallavi Zalawadia; Updated September 26, 2017
...

Key performance indicators (KPI), series of data, tell a story by measuring performance of processes within a firm. The tracking of a KPI in the form of a rate or a percentage can help management determine whether current operations are generating a profit or loss. Management uses analysis drawn from KPIs to make strategic decisions to enhance productivity. For example, tracking voluntary attrition can provide insight into whether the firm is losing its top talent or spending more than it should on recruitment to fill open positions.

Step 1

Gather year-to-date data on permanent employees and voluntary leavers from the HR system database. Base year-to-date employee data on month-end snapshots.

Step 2

Calculate the average number of permanent employees by adding month-end totals and dividing by the number of months. For example, if running the year-to-date average in April, use the following formula:

(Jan+Feb+Mar)/3 = average number of employees

Step 3

Calculate the percentage of voluntary attrition by dividing the average number of employees by the year-to-date number of voluntary leavers.

Tips

  • Work with your firm’s workforce analytics or human resources administration team to gather initial sets of data if you do not have direct access.

    Use the same formula to further dissect the data for additional interpretations, such as breakdown by title, gender, department or location.

Warnings

  • Understand the rules and definitions that the firm has established for all data you retrieve from the HR systems.

About the Author

Pallavi Zalawadia began her writing career in 2002 while working in the finance/banking industries, where she wrote technical specs and executive summaries for reporting. She graduated from the New Jersey Institute of Technology in 2005 with a Bachelor of Science in management information systems.

Photo Credits

  • pen showing diagram on financial report/magazine image by Anton Gvozdikov from Fotolia.com