Rapid Recall Key 62–91
- Manage DQ Rules; Measure/Monitor DQ; Manage Data Issues; Establish DQ SLAs; Data Quality Response.
- Capture/discover, approve, document, version/change, implement, maintain, and gather feedback on rules.
- Detailed rule-execution results and aggregated results such as scorecards.
- Measurable; business relevant; threshold-linked; accountable/stewarded; controllable/actionable; trendable.
- Percentage of tested data conforming to the rule/requirement.
- Count/percentage violating the rule/requirement.
- Statistical/pattern exploration of content, distributions, nulls, uniqueness, ranges, frequencies and relationships.
- Profiling discovers conditions/potential issues but does not determine business requirements or root causes by itself.
- Vocabulary/classification; assignment; escalation; workflow; diagnosis/RCA; remediation options; business decision; implementation/verification/history.
- Impact, duration, urgency, risk and SLA/Governance commitments.
- Trace symptoms/lineage, isolate entry point, assess process/environment/external contributors, identify potential root cause.
- Process fixes; system modifications; prevention; added monitoring/inspection; direct controlled correction; or no action when cost/value does not justify it.
- Covered elements, business impact, dimensions/rules, methods, thresholds, notifications, response/remediation deadlines, escalation, possible rewards/penalties.
- Scorecards; trends; SLA metrics; issue status; Governance/policy conformance; business effects of improvements.
- Profiling; Business Rule Templates/Engines; Parsing/Formatting; Transformation/Standardization; Enrichment; Incident Management.
- Parsing decomposes/recognizes components; standardization changes them to approved representation.
- Adding data/context to improve usefulness: geocode, demographics, timestamps, lineage/audit context, reference vocabulary, etc.
- Pareto analysis, fishbone diagram, track-and-trace, process analysis, Five Whys.
- Fully automated; manually-directed; manual.
- Automation uses confidence/scoring, but uncertain or sensitive cases require human/Steward review.
- They bypass normal safeguards and are high risk; controlled interfaces with edits/audit are preferred.
- Hybrid: top-down sponsorship/consistency/resources plus bottom-up discovery/incremental wins.
- Current understanding/pain; actual state of data; risks in creation/processing/use; cultural/technical readiness for scalable monitoring.
- Status-quo resignation; silo politics/blame; hero culture.
- Metadata formalizes DQ expectations/rules and stores results/issues; DQ measurements themselves become Metadata.
- They provide critical, trusted domains/parents supporting validity, consistency, uniqueness and integrity.
- Data movement can introduce defects; inspection between stages isolates corruption earlier and preserves DQ evidence.
- Governance sets priorities/decision rights, coordinates participation/access, makes measurement lead to action, and resolves conflicts.
- ISO 8000 supports portable/application-neutral data meeting stated requirements and standards-based definition/request/verification of quality.
- SPC seeks unexpected/special-cause variation relative to a statistically stable baseline; control limits are not business acceptance thresholds.
← Key 32–61 · Blank-Page Rebuilds →