Portfolio sample. Locations, people and numbers are fictional; the report design and logic are the real ones.
Location (filters the whole report)
Target counts Supervisor appointments only. The Academy pipeline counts every promotion, including Sales Agent to Senior Sales Agent.

Risk zones

Zone

Target progress by location

Supervisor appointments Jul–Dec 2026 against each target.

Follows the Location filter

Locations compared

Talent Academy candidates

Everyone who has entered a stream, and where they stand today.

Status
Stream

Supervisor appointments · Jul–Dec 2026

These are what count towards each location's target.

Follows the Location filter only

Academy pipeline

Everyone who entered a stream, how many the committee approved, and how many reached a role above their own.

Follows the Location filter only

Academy success by location

Of everyone who entered a stream, how many the committee approved.

Academy success

Of everyone who entered a stream, how many the committee approved. Whether they are still employed does not change this figure.

Promotions from the Talent Academy vs outside

Year

Academy candidates who took a different route

Approved candidates now in a leadership role other than Supervisor.

Data to fix in the global file

Gaps in the source files, not calculation errors. Until they are fixed the figures above understate what is happening.