Blog · Board and management reporting
A performance dashboard compares actual results with agreed targets by business unit. Learn which exports to use, how to calculate comparable gaps, and how to assign action when a company total hides a local problem.
A performance dashboard compares actual results with agreed targets and shows where a manager needs to act. The essential comparison is the same measure, period, and business scope on both sides. A company result that meets plan can still conceal a serious shortfall in one unit.
Choose measures around decisions people can make: recover missed sales, clear a delivery constraint, or investigate spending. For each measure, name the person who can explain the gap and authorize a response. A list of attractive charts without these responsibilities is a reporting display, not a management process.
This connection starts above the dashboard. NIST's Baldrige criteria commentary describes organizational purpose as something that should translate into strategy, goals, and metrics. Apply that discipline by asking which business commitment each measure represents before adding it to the view.
A sales leader can use the measures in sales KPIs for B2B sales teams; finance can use the definitions in financial KPIs. This page concerns the target comparison and exception process after those definitions are settled.
Bring the actuals export and the approved plan for the reporting period. Actuals might come from invoiced sales, shipment records, and departmental spending. The plan needs a unit, period, measure, target value, and version. Preserve the original rows behind each summarized amount.
Write a short definition beside every measure. Revenue might mean net invoiced sales posted in September, while delivery might mean orders due in September that arrived by the promised date. Those dates answer different questions, so label them rather than forcing them into an unexplained common cutoff.
Targets also need direction. More revenue may be favorable; more expense may be unfavorable. A service percentage needs a percentage-point gap, while a spending amount needs a dollar gap. Do not turn every result into a percentage and assume the signs carry the same meaning.
Amount variance = Actual amount − Target amount
Target attainment = Actual amount / Target amount
Rate gap = Actual rate − Target rate, expressed in percentage points
If the target is zero, attainment is undefined. Show the actual amount and a plain explanation. Do not replace the missing ratio with a result that looks like successful performance.
A US distributor reviews September 2026. Revenue comes from net invoiced sales, service from orders due in the month, and expense from the same month's operating ledger. These are illustrative internal targets, not industry benchmarks.
| Unit | Revenue actual (USD) | Revenue target (USD) | On-time orders | Orders due | Expense actual (USD) | Expense target (USD) |
|---|---|---|---|---|---|---|
| East | 920,000 | 1,000,000 | 940 | 1,000 | 51,000 | 50,000 |
| West | 1,080,000 | 1,000,000 | 1,140 | 1,200 | 48,000 | 50,000 |
| Company | 2,000,000 | 2,000,000 | 2,080 | 2,200 | 99,000 | 100,000 |
The operating agreement sets an on-time delivery target of 95.0% for each unit. Calculate the results from the source totals before assigning a status:
| Measure and unit | Calculation | Result (% or USD) | Gap or interpretation (USD or percentage points) |
|---|---|---|---|
| East revenue | 920,000 / 1,000,000 | 92.0% attainment | −80,000 |
| West revenue | 1,080,000 / 1,000,000 | 108.0% attainment | +80,000 |
| Company revenue | 2,000,000 / 2,000,000 | 100.0% attainment | 0 |
| East on-time delivery | 940 / 1,000 | 94.0% | −1.0 percentage point |
| West on-time delivery | 1,140 / 1,200 | 95.0% | 0.0 percentage points |
| Company on-time delivery | 2,080 / 2,200 | 94.5% | −0.5 percentage points |
| East expense | 51,000 − 50,000 | 1,000 over | Unfavorable |
| West expense | 48,000 − 50,000 | 2,000 under | Favorable pending explanation |
| Company expense | 99,000 − 100,000 | 1,000 under | Favorable pending explanation |
Percentages and percentage-point gaps are rounded to one decimal place after calculation. The company delivery rate divides summed counts; it is not an unweighted average of unit percentages.
East's revenue shortfall and West's surplus cancel exactly. A company sales card therefore gives no reason to ignore East. Likewise, spending below budget is not automatically good: it could reflect delayed work or a vacant role. Keep the numerical result separate from the business explanation.
Reconcile the $2,000,000 revenue total to the ledger under the stated definition. Tie the $99,000 expense total to the included departments and accounts. Confirm that the order register contains 2,200 distinct due orders and that 2,080 meet the on-time rule.
Then check the bridge between units and company. East's negative $80,000 revenue variance plus West's positive $80,000 must equal the company variance of zero. Expense variances of positive $1,000 and negative $2,000 must equal negative $1,000. Unassigned units must appear explicitly until resolved.
Delivery definitions deserve particular care. An order arriving on time but short of quantity can satisfy an on-time measure while failing an in-full measure. Use OTIF versus fill rate versus on-time delivery to settle that distinction before comparing teams.
Give East's sales manager the revenue exception and its underlying customer rows. Give its operations manager the late-order list. Record the proposed action, responsible person, and next review date alongside the result; do not treat a comment such as “seasonality” as evidence until the relevant rows support it.
Separate target misses from unusual process behavior. NIST's control-chart guidance explains the use of control limits and patterns to identify potential process changes. A management target is a commitment; a control limit answers a statistical question. Neither substitutes for the other.
Use a separate employee performance dashboard when the question concerns individual responsibilities, and a supplier performance dashboard when the accountable party is a vendor. Keep their evidence and ownership distinct from business-unit results.
Bring your actuals export and a compatible target file, with unit and period columns preserved. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See self-service analytics for business teams for the supporting approach.
Include the reporting period, unit, measure definition, actual, approved target, variance, and owner. Add the source cutoff and the next action for exceptions. Keep underlying counts beside rates so readers can distinguish a meaningful miss from a small denominator.
Update it when the source files are complete enough for the decision. Weekly operations reviews may use completed shipment exports, while financial comparisons may wait for the monthly close. Display the cutoff so readers know which activity remains outside the view.
A business performance dashboard usually compares units, processes, or departments with operating targets. An employee scorecard evaluates an individual's responsibilities and outcomes. They may share measures, but company results alone do not establish an individual's contribution or performance.
Yes. Use agreed service measures from completed ticket, incident, or cost exports and compare them with targets for the same period. Define which services and events count, retain the denominators, and assign each exception to the manager responsible for investigation.