Skip to content

Blank-Page Reconstructions

Attempt each from a blank page before reading the key.

1 — Fit-for-Purpose Chain

Draw PURPOSE → REQUIREMENT → DQ DIMENSION → DQ RULE → MEASURE → THRESHOLD → RESPONSE.

Key: consumer/business purpose must lead to measurable requirement; measurement means nothing without a threshold and response. Source: pp. 424–435.

2 — Nine-Dimension Wheel

Put DATA QUALITY in center; draw nine spokes.

Key: Validity, Completeness, Consistency, Integrity, Timeliness, Currency, Reasonableness, Uniqueness/Deduplication, Accuracy. Source: pp. 429–432.

3 — Four High-Risk Dimension Pairs

Rebuild Validity/Accuracy; Timeliness/Currency; Completeness/Integrity; Consistency/Uniqueness.

Key: allowed/real; availability/currentness; presence/relationship; agreement/one-per-entity. Source: pp. 429–432.

4 — PDCA Data Quality Loop

Draw PLAN → DO → CHECK → ACT and annotate.

Key: Plan scope/requirements/causes/options; Do implement; Check monitor conformance; Act respond/restart. Source: pp. 434–436.

5 — Five-Cause Fishbone

Draw five bones feeding poor DQ.

Key: Lack of Oversight; Data Entry; Processing; System Design; Fixing Previous Issues. Add examples such as missing quality incentives, poor UI/edit checks, downstream blindness, weak RI, risky patches. Source: pp. 436–441.

6 — Seven-Activity Spine

Write all seven activities; put five operations sub-activities under Activity 7.

Key: Framework → High Quality → Dimensions/Rules → Initial Assessment → Prioritize → Improvement Goals → DQ Operations. Under Operations: Manage Rules; Measure/Monitor; Manage Issues; SLA; DQ Response. Source: pp. 441–450.

7 — Assessment-to-Improvement Funnel

Draw CRITICAL NEED → CRITICAL DATA → RULES/DIMENSIONS → PROFILE/ASSESS → CONFIRM WITH STEWARDS → PRIORITIZE → GOALS/PLAN.

Key: profiling reveals facts; business-impact analysis turns facts into priorities; goals mix quick hits and strategic prevention. Source: pp. 442–445.

8 — Issue and SLA Workflow

Draw DETECT → RECORD/CLASSIFY → ASSIGN → IMPACT/URGENCY → ESCALATE → DIAGNOSE/RCA → OPTIONS → OWNER DECISION → IMPLEMENT → VERIFY/CLOSE → REPORT.

Key: SLA overlays rules/measures/thresholds, notification, response/remediation deadlines, escalation, possible rewards/penalties. Source: pp. 447–450.

9 — DQ Tool Pipeline

Draw PROFILE → PARSE/FORMAT → STANDARDIZE/TRANSFORM → ENRICH → MONITOR/INCIDENT.

Key: discovery → decomposition → target form → added context → operational handling. Source: pp. 451–455.

10 — Prevention–RCA–Correction Triangle

Draw the three corners and explain their relationship.

Key: Prevention stops future defects; RCA finds/removes cause; Correction repairs existing data. Correction alone treats symptoms. Source: pp. 455–460.

11 — Implementation and Readiness Map

Draw TOP-DOWN + BOTTOM-UP → HYBRID and add readiness lenses.

Key: top-down sponsorship/resources/consistency; bottom-up actual defects/incremental wins. Readiness = pain/understanding, actual data state, process/use risks, cultural/technical scalability. Source: pp. 460–463.

12 — Cross-Knowledge-Area and Standards Map

Put DQ center; connect Modeling, Metadata, Master/Reference, Integration, Governance; add ISO 8000 and SPC outside.

Key: models express constraints; Metadata stores rules/results; MDM/RDM supports domains/identity; Integration is control point; Governance sets priorities/action. ISO 8000 = stated requirements/portable data; SPC = common vs special variation. Source: pp. 463–470.

← Recall Keys · Classification Drill →