Rapid Recall Key 32–61
- Completeness = required presence; Integrity = coherent/valid relationships.
- Consistency = expected agreement; Uniqueness = one representation per real entity.
- Accuracy may require trusted comparison, sampling, calibration, re-observation or real-world verification.
- A business expectation describing how data/operations should behave for useful/compliant operation.
- A dimension-aligned, testable expression of a DQ requirement.
- Format conformance; allowed-domain membership; type/range/precision; mapping conformance among value domains.
- Conditions under which missing values/records are acceptable or unacceptable.
- Expected conditional agreement across values, records, sets, definitions or time.
- Every ORDER.CUSTOMER_ID must reference an existing approved Customer.
- Daily record count must remain within an approved fixed/benchmark range unless explained.
- Compare with trusted/verified source or reality; use sampling/calibration where appropriate.
- Plan requirements/causes/options; Do fixes/controls; Check conformance; Act respond/correct/restart.
- DQ team leads much Plan/Do with stakeholders; business operations/process owners carry major ongoing Check/Act responsibility with DQ support.
- Threshold breach; new data scope; new DQ requirement; changed rule/standard/expectation.
- Lack of oversight; Data Entry Processes; Data Processing Functions; System Design; Fixing Previous Issues.
- Missing awareness/priority/leadership/governance/justification/value measurement.
- Poor training/usability; weak edit checks; bad list placement; field overloading.
- No downstream awareness; inconsistent execution; changed/stale rules; changing structures.
- Missing referential/uniqueness constraints; processing/timing/type design; weak Master/Reference controls.
- They bypass application rules/controls, may be rushed/untested, create unintended consequences, and often lack audit/change control.
- Define DQ Framework → Define High Quality Data → Dimensions/Supporting Rules → Initial Assessment → Prioritize Improvements → Improvement Goals → Develop/Deploy DQ Operations.
- Repeatable operating approach for roles, Governance, methods, standards, measurement, communication and extension of practice.
- Identify important data and articulate purpose-specific quality expectations using business/process/system/stakeholder context.
- Many expectations are undocumented and embedded in policy, workflow, edits, code, triggers, standards or SME knowledge.
- Examine actual critical data, profile/query, compare with rules/expectations, discover issues/relationships and validate with Stewards/SMEs.
- Undocumented dependencies, implied rules, redundant/contradictory data, and genuine conformance.
- Current remediation; preventive controls/process improvements; ongoing controls/reporting.
- Combine data evidence with business impact/risk, criticality, stakeholder needs, cost/benefit and feasibility.
- Quick hit = immediate low-cost issue response; strategic improvement = root-cause/preventive long-term change.
- Prevention generally costs less and reduces recurring risk compared with repeated correction.
← Key 01–31 · Key 62–91 →