Key takeaways
- Define headcount consistently: people, full-time equivalents, or filled roles.
- Track attrition by department and tenure, not just a company-wide rate.
- Connect workforce data to cost and capacity.
- Review HR metrics alongside business activity, not in isolation.
On this page
Define headcount
Headcount can mean people, full-time equivalents, filled roles, or budgeted positions. Choose the definition that matches the decision and use it consistently.
A monthly trend is more useful than a single number. Show joiners, leavers, and the closing headcount so the movement is visible.
Measure attrition with context
A company-wide attrition rate can hide problems in one team. Break it down by department, tenure, and manager where the data allows.
Separate voluntary and involuntary attrition. A high voluntary rate in a critical team is a different problem from planned restructuring.
Connect people to cost
Show salary cost, contractor cost, and cost per role alongside headcount. A team can grow while cost grows faster because of seniority or overtime.
For service businesses, connect capacity to billable or productive hours. Headcount alone does not show whether the team can deliver the work.
Track hiring and vacancies
Report open roles, time to hire, and vacancy age. A role that has been open for months has a cost even if no salary is being paid.
Show the hiring plan against actual starts. It helps the business see whether capacity will arrive when expected.
Review with the business
HR metrics should be reviewed with finance and operations. A rising headcount may be appropriate if revenue and workload are rising; it may be a problem if they are not.
Keep the dashboard small: headcount, joiners, leavers, attrition, open roles, and cost. Add detail only when a decision requires it.
Frequently asked questions
What is the best headcount definition?+
Use full-time equivalents for cost and capacity, and people for workforce planning. Label the measure clearly.
How should attrition be calculated?+
Use a consistent formula, usually leavers divided by average headcount for the period. Break it down by department and voluntary/involuntary.
Do small businesses need an HR dashboard?+
A simple monthly view is useful once the team is large enough that headcount, turnover, and cost are difficult to track in a spreadsheet.
Need help applying this?
Improve your bi dashboards & reporting.
Review the service scope or tell us what you are trying to improve. We will reply with a clear next step.
Free KPI definition templateRelated reading
A data quality checklist before starting a BI project
The checks that prevent a dashboard from failing after launch: ownership, definitions, completeness, duplicates, and reconciliation.
When to move from spreadsheets to a database
The signals that a spreadsheet has become a database, and the simplest path to a more reliable system.