N. Okoro
← All projects

PEOPLE ANALYTICS · EXCEL

HR Analytics in Excel

What do headcount, tenure, and compensation reveal about workforce composition?

Excel

9,964 employees · Portfolio case study

Headcount by department

Marketing1,033
Finance1,015
Sales1,012
Operations1,009
Product1,009
IT1,004
Web visualisation · calculated from supplied data

The 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

  1. Used supporting PivotTables to aggregate workforce measures.
  2. Built department and location comparisons with charts.
  3. 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.

Next case study Sales Performance in Excel ↗