Chapter 01

The audit

Trace metrics back to sources, compare definitions, and review the checks that precede a decision.

roles represented: 3
materials examined: 3
analysis sequences: 8
priorities identified: 3

Audit walkthrough · four phases

Phase 1 Listen

Sequence 1Identify decisionsManagement

Connect each metric to a concrete decision.

Example approach

Sequence 2Gather definitionsSite managers

Compare what the same field means at each site.

Example approach

Phase 2 Map

Sequence 3Trace back to sourcesData owner

Document the origin and frequency of exports.

Example approach

Sequence 4Run through a consolidationData owner · Sites

Observe manual corrections and reconciliations.

Example approach

Phase 3 Analyze

Sequence 5Assess discrepanciesData owner

Distinguish quality issues from differences in definitions.

Example approach

Sequence 6Specify checksManagement · Sites

Define behavior when a source is missing.

Example approach

Phase 4 Present findings

Sequence 7Design the target dashboardManagement

Show definitions, sources, and freshness alongside metrics.

Example approach

Sequence 8Prepare validationAll roles

Compare a result with its details and original data.

Example approach

People involved

Management

Make decisions using metrics

Site managers

Document business activity

Data owner

Consolidate and check sources

Materials reviewed

Business exports

Site activity

Different formats

Consolidation spreadsheet

Data reconciliation

Manual checks

Dashboard

Reading metrics

Freshness to clarify