8 Compensation, Benefits, Employee Relations, and Retention Metrics

8.1 Why These Function Metrics Matter

The four sub-functions in this chapter share one promise to the workforce — that the deal is fair, the safety net works, the conflicts are heard, and the reasons to stay outweigh the reasons to leave.

The previous chapter measured the sub-functions that build the workforce — workforce planning, recruitment, training. This chapter measures the sub-functions that hold the workforce together once it has been built. Compensation describes the financial deal, benefits describe the safety net, employee relations describe how disputes are handled, and retention describes whether people stay. The four sub-functions share an audience: the executive committee that has to defend the workforce promise to investors, regulators, and employees themselves.

Compensation metrics are unusually exposed. They are read by the workforce, by the regulator, by the talent market, and by the board, often within the same week. As George T. Milkovich et al. (2014) set out in their standard work on compensation, the discipline that separates a defensible compensation programme from a contested one is the willingness to measure pay against four lenses simultaneously — internal equity, external competitiveness, individual differentiation, and statutory compliance. The dashboard that surfaces all four lenses on one page is the dashboard that survives a pay-equity audit.

Retention metrics carry the longest measurement history of any HR sub-function. As Peter W. Hom et al. (2017) documented in their century-spanning review of turnover research, the literature has accumulated more evidence on why people leave than on almost any other workforce question, and the contemporary task is no longer to invent metrics but to render the existing evidence as charts the executive team can act on. The visualisation lens is what closes the gap between a hundred years of turnover theory and a Tuesday-morning conversation about which manager has a retention problem.

The four sub-functions in this chapter together complete the operational core of the HR scorecard. Combined with workforce planning, recruitment, and training from the previous chapter, they cover every place where the function spends money and every place where the workforce experiences the deal. The remaining chapters of this module step back to the design principles that integrate these sub-function dashboards into the enterprise scorecard.

The reward-and-retention contract

Compensation pages surface internal equity, external competitiveness, and statutory compliance side by side, so that no audience reads pay through one lens alone.
Benefits pages report utilisation, value, and cost together, because a benefit nobody uses is a cost without a return and a benefit everyone uses is a programme that has to be redesigned.
Employee-relations and retention pages link to one another, because unresolved disputes show up later as voluntary attrition and the dashboard should make the link visible.

8.2 Compensation Metrics

Compensation metrics describe whether the financial deal the firm offers is fair, competitive, defensible, and compliant. The same compensation event — a salary review, a bonus pool decision, an equity grant — has to be tested against four lenses, and a dashboard that shows only one of the four invites a challenge from whichever lens is missing.

Compensation Metrics by Lens

Lens	Question it answers	Example metric	Visual
Internal equity	Do similar roles receive similar pay across the firm	Compa-ratio by role family, pay-band coverage	Distribution chart with band overlay
External competitiveness	Does the firm pay at, above, or below market	Market index, market-percentile position by role	Bar chart with market reference
Individual differentiation	Are stronger performers paid more than weaker performers in the same role	Pay-for-performance ratio, merit-budget distribution	Scatter or quadrant chart
Statutory compliance	Does pay meet equal-pay and disclosure requirements	Pay-equity gap by gender or other protected attribute	Distribution with target gap

Compa-ratio and the four-lens read

The compa-ratio — actual pay over the midpoint of the pay band — is the workhorse of the compensation dashboard, and the lens through which the other three lenses are usually read. A compa-ratio chart segmented by role family answers internal equity. The same chart paired with a market-index reference line answers external competitiveness. Coloured by performance rating, it answers individual differentiation. Faceted by gender or other protected attribute, it answers statutory compliance. One metric, four pages, four conversations.

8.3 Benefits Metrics

Benefits metrics describe whether the non-cash element of the workforce deal is being used, valued, and delivered at a sustainable cost. The most common failure mode is to measure cost without utilisation, or utilisation without value, or any of the three without the demographic context that determines whether the benefit is reaching the people it was designed for.

Benefits Metrics

Family	Example metric	What it captures	Visual
Utilisation	Take-up rate, claims-per-eligible	Whether the benefit is being used	Bar chart by demographic segment
Value	Employee-rated value, perceived-quality survey	Whether users believe the benefit is worthwhile	Distribution gauge
Cost	Cost per employee, cost per claim, year-over-year change	What the benefit costs the firm	Trend line with target
Equity	Take-up rate by demographic segment, access disparity	Whether the benefit reaches the workforce evenly	Heat map by segment
Outcome	Wellness-claims reduction, return-from-leave rate	Whether the benefit produces the intended workforce effect	Cohort comparison

The triangle of utilisation, value, and cost

A balanced benefits dashboard places utilisation, value, and cost at the corners of one triangle, with each benefit plotted inside it. A benefit with high cost, low utilisation, and low value is a candidate for redesign or retirement. A benefit with low cost, high utilisation, and high value is the programme to defend in the next budget round. The triangle visual is more useful than three separate charts because the audience can see which corner is dragging.

8.4 Employee Relations Metrics

Employee-relations metrics describe how disputes, grievances, and policy violations are surfaced, handled, and resolved. They are quieter on a typical dashboard than recruitment or training metrics, but they are the early warning system for many of the larger workforce problems the executive committee will eventually face. A page that surfaces them well buys the organisation time before a small issue becomes a public one.

Employee Relations Metrics

Metric family	Example metric	What it captures	Visual
Volume	Cases opened per period, cases per business unit	Whether issues are being raised	Trend line with prior-year overlay
Severity	Severity-score distribution, escalations to formal grievance	How serious the issues are	Distribution chart
Resolution	Time to resolve, first-time resolution rate	How quickly and cleanly cases close	Funnel by stage
Recurrence	Repeat-grievance rate, repeat-manager rate	Whether the same issues are returning	Heat map by manager or unit
Outcome	Settlement-cost trend, post-resolution engagement	What the resolution did for the workforce relationship	Combo chart with engagement overlay

Reading employee relations as an early warning

The employee-relations dashboard is most powerful when it is read as an early warning. A spike in case volume in a single business unit, a rising severity distribution, a falling first-time resolution rate, or a clustering of repeat issues under one manager are signals that surface here weeks or months before they appear in attrition or engagement data. The page that connects employee-relations metrics to retention and engagement metrics on the same review cycle gives the organisation time to act before the larger metric moves.

8.5 Retention Metrics

Retention metrics describe whether the people the firm wants to keep are staying, and whether the people the firm wants to leave are leaving cleanly. They are the most-watched HR metrics in most organisations and the most often misread, because aggregate attrition figures hide every nuance that matters: voluntary versus involuntary, regretted versus unregretted, critical role versus easily replaced, early-tenure versus long-tenure.

Retention Metrics with the Detail That Matters

Metric	What it captures	Why aggregate figures mislead	Visual
Voluntary attrition	People leaving by choice	Combined with involuntary, the picture is unreadable	Trend line by reason
Regretted attrition	Voluntary leavers the firm wanted to keep	Headline attrition includes leavers the firm was happy to see go	Bar chart by performance band
Critical-role attrition	Leavers from roles the strategy depends on	A non-critical leaver and a critical leaver are not equivalent	Heat map by role family
First-year attrition	Leavers within twelve months of joining	An indicator of recruitment quality and onboarding effectiveness	Cohort chart
Tenure curve	Survival of joining cohorts over time	Reveals tenure cliffs and seasonal patterns	Survival curve
Manager-level attrition	Attrition concentrated under specific managers	Surfaces leader-driven retention risk hidden in unit-level data	Heat map by manager

The arc of a retention conversation

flowchart LR
  A[Aggregate Attrition<br/>headline number] --> B[Voluntary Split<br/>by choice or not]
  B --> C[Regretted Split<br/>kept or not]
  C --> D[Role-Level View<br/>critical or not]
  D --> E[Manager-Level View<br/>where is it concentrated]
  E --> F[Action<br/>retention plan]
  style A fill:#FCE8E6,stroke:#C5221F
  style F fill:#E6F4EA,stroke:#137333

The aggregate number on its own does not support a decision. Decomposing it through voluntary, regretted, critical-role, and manager-level views turns one stale figure into five conversations, each with its own owner and its own action. The retention dashboard earns its place when it presents these decompositions in sequence rather than competing for attention as separate tiles.

8.6 Visualising the Reward and Retention Story

The four sub-functions in this chapter share one audience and one decision lens, even though their data lives in different systems. A dashboard that lays them out as one story — the deal, the safety net, the dispute resolution, the staying — answers the executive question that all four sub-functions ultimately serve: is the workforce promise being kept.

One Page, Four Sub-Functions

Page region	Sub-function	Headline visual	Decision the region supports
Top-left	Compensation	Compa-ratio with market reference and pay-equity overlay	Is the deal fair, competitive, and compliant
Top-right	Benefits	Utilisation-value-cost triangle with segment heat map	Is the safety net used, valued, and sustainable
Bottom-left	Employee relations	Volume-severity-resolution combo with engagement overlay	Are disputes surfacing and resolving cleanly
Bottom-right	Retention	Decomposed attrition with manager and role-level views	Are the right people staying long enough

The single workforce-promise page

The four-region layout turns four sub-function dashboards into a single workforce-promise page. The chief people officer can open the page and see, in four glances, whether the deal is fair, the safety net works, disputes are handled, and people are staying. The conversation in the executive committee shifts from “show me the latest pay number” to “is the workforce promise being kept overall, and which region is dragging” — which is the question all four sub-functions exist to answer.

8.7 Hands-On Exercise: Building the Reward and Retention Page

Aim, Scenario, Dataset, Deliverable

Aim. Build a four-region workforce-promise page that surfaces compensation, benefits, employee relations, and retention on a single dashboard. The lab takes the four-region layout introduced in Section 5 of this chapter and turns it into a working Excel workbook and Power BI page.

Scenario. You are the HR analytics lead asked to deliver one page that the chief people officer can open each Monday and use to brief the executive committee on the workforce promise. Use the workforce extract for compensation and retention measures, and the performance file for retention decomposition.

Dataset. Two files from the HRMD dataset library:

Random HR Data (Excel) — workforce records including EmployeeID, Department, Status, Salary, PayBandMidpoint, Tenure.
Performance Metrics (Excel) — performance records including EmployeeID, PerformanceRating, Manager, and exit fields where present.

Deliverable. A Reward-and-Retention.xlsx workbook with the compensation and retention pivots and a Reward-and-Retention.pbix Power BI file with the four-region page described in the steps below.

8.7.1 Step 1 — Stage the data and join the two extracts

Load both files into Excel as Tables. Use a VLOOKUP or XLOOKUP to join EmployeeID from the performance table into the workforce table so the joined table carries pay, status, performance, and manager in one row. Confirm date fields are typed as dates and that join keys have no leading or trailing whitespace.

8.7.2 Step 2 — Compute the compensation measures

Build the compensation lens in a Comp sheet using the four-lens table from Section 2 of this chapter.

Code

Excel Formula

Compa-Ratio        = Workforce[Salary] / Workforce[PayBandMidpoint]
Pay-Equity Gap     = AVERAGEIFS(Workforce[Salary], Workforce[Gender], "Female")
                   - AVERAGEIFS(Workforce[Salary], Workforce[Gender], "Male")
Pay-Compression    = Workforce[Salary] - AVERAGEIFS(Workforce[Salary],
                       Workforce[Department], Workforce[Department],
                       Workforce[Tenure], "<2")

Render the compa-ratio as a scatter against tenure to surface compression and inversion patterns visually before promoting to Power BI.

8.7.3 Step 3 — Compute the retention decomposition

In a Retention sheet, compute voluntary attrition, regretted attrition, critical-role attrition, first-year attrition, and manager-level attrition.

Code

Excel Formula

Voluntary Attrition       = COUNTIFS(Workforce[Status], "Exited", Workforce[ExitType], "Voluntary")
                            / COUNTIF(Workforce[Status], "Exited") * 100
Regretted Attrition       = COUNTIFS(Workforce[Status], "Exited", Workforce[PerformanceRating], ">=4")
                            / COUNTIFS(Workforce[Status], "Exited") * 100
First-Year Attrition      = COUNTIFS(Workforce[Status], "Exited", Workforce[Tenure], "<1")
                            / COUNTIF(Workforce[Status], "Active") * 100

8.7.4 Step 4 — Build the pivots for slicing

Insert pivots that surface each measure by Department, Manager, Tenure Cohort, and Performance Rating. Add slicers for Department and Tenure Cohort. The pivots will become the source tiles for the four-region Power BI page.

8.7.5 Step 5 — Promote to Power BI and add the model

Open Power BI Desktop and use Home > Get Data > Excel to load the joined table and the performance file. Confirm relationships through EmployeeID and the date table.

8.7.6 Step 6 — Build the four-region layout

Lay out the page in the order set by Section 5 of this chapter.

Top-left: Compensation. A compa-ratio scatter against tenure with a market-index reference line, surrounded by KPI cards for compa-ratio average, market position, and pay-equity gap.
Top-right: Benefits. A utilisation-value-cost triangle (or three-corner gauge if the triangle visual is unavailable) with a heat map of utilisation by demographic segment.
Bottom-left: Employee relations. A volume-severity-resolution combo chart with engagement score overlaid on the same time axis.
Bottom-right: Retention. A decomposed-attrition stack chart with a separate panel for manager-level and role-level views.

8.7.7 Step 7 — Apply the workforce-promise contract

Title each region with the question it answers — “Is the deal fair, competitive, and compliant?” / “Is the safety net used, valued, and sustainable?” / “Are disputes surfacing and resolving cleanly?” / “Are the right people staying long enough?”. Add a single Department and Tenure-Cohort slicer that controls all four regions. Confirm that hovering on any measure reveals its definition.

8.7.8 Step 8 — Publish and instrument

Publish the report, set a weekly refresh aligned with the Monday morning briefing, and turn on usage metrics so the team can confirm the chief people officer is opening the page at the cadence agreed.

Connect to the Visualisation Layer

This four-region page sits beside the Workforce Pulse dashboard from Chapter 7. Together they form the foundational HR scorecard for an organisation: the recruitment-and-training side from Chapter 7 covers how the workforce is built, and the reward-and-retention side from this chapter covers how it is held together. The two pages share definitions through the same semantic model.

Files and Screen Recordings

Reward-and-Retention.xlsx, Reward-and-Retention.pbix, and ch8-workforce-promise-walkthrough.mp4 will be attached at this point in the published edition. The screen recording walks through Steps 1 to 8 with the Excel workshop and the Power BI showroom shown side by side.

Summary

Concept	Description
Why These Function Metrics Matter
Workforce-promise framing	The four sub-functions together answer whether the workforce promise is being kept
Reward-and-retention page	A single page that lays out compensation, benefits, relations, and retention
Linked sub-function metrics	The four sub-functions reference one another rather than compete for attention
Compensation exposure	Compensation metrics are read by workforce, regulator, market, and board in one week
Compensation Metrics
Internal equity	Whether similar roles receive similar pay across the firm
External competitiveness	Whether the firm pays at, above, or below the market for each role
Individual differentiation	Whether stronger performers receive more than weaker performers in the same role
Statutory compliance	Whether pay meets equal-pay and disclosure requirements
Compa-ratio	Actual pay over the midpoint of the pay band, the workhorse of compensation visuals
Pay-band coverage	Where each role and incumbent sits within the pay band
Benefits Metrics
Utilisation	Whether the benefit is actually being used by eligible employees
Benefits value	Whether users believe the benefit is worth the cost of providing it
Benefits cost	What the benefit costs the firm per employee or per claim
Benefits equity	Whether the benefit reaches the workforce demographics evenly
Benefits outcome	Whether the benefit produces its intended workforce effect
Utilisation-value-cost triangle	A three-corner visual that exposes which corner is dragging
Employee Relations Metrics
Case volume	Are issues being raised by the workforce in the first place
Case severity	How serious the issues that are raised actually are
Resolution time	How quickly and cleanly cases close
Repeat-grievance rate	Are the same issues returning under the same managers
Retention Metrics
Voluntary attrition	People leaving by choice rather than firm decision
Regretted attrition	Voluntary leavers the firm wanted to keep
Critical-role attrition	Leavers from roles the strategy depends on
First-year attrition	Leavers within twelve months of joining
Tenure curve	Survival of joining cohorts over time, exposing tenure cliffs
Manager-level attrition	Attrition concentrated under specific managers, surfacing leader-driven risk