PEOPLE ANALYTICS · EXCEL
HR Analytics in Excel
What do headcount, tenure, and compensation reveal about workforce composition?
9,964 employees · Portfolio case study
Headcount by department
Web visualisation · calculated from supplied dataThe question & data
An Excel dashboard turns employee records into filterable headcount, salary, tenure, and training summaries.
9,964 unique employee IDs in the supplied workbook, distinct from the Power BI HR dataset.
The approach
- Used supporting PivotTables to aggregate workforce measures.
- Built department and location comparisons with charts.
- Added slicers and a timeline for interactive exploration.
What the work reveals
The workbook contains 8,674 employees without an exit date and 1,290 with an exit date.
The recorded average tenure is approximately 4.8 years.
From findings to next steps
Compare workforce composition by department and location, then investigate differences with business context.
Read the results in context
Exit-date status is a dataset classification. The leaver share is not an annual attrition rate without a defined period and denominator.
Based on supplied portfolio materials. Findings describe the dataset and report; recommendations are proposed next steps, not measured business outcomes.