Study guide
Section 4.3: DMAIC & DQ Improvement Lifecycle
DAMA Certified Data Management Professional CDMP
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Exam Overview & DMBoK Framework
1.1 CDMP Exam Details & Strategy 1.2 The DMBoK Framework 1.3 Data Management Organization & Roles
2 Chapter 2: Data Governance (Part A)
2.1 Data Governance Principles & Drivers 2.2 Operating Models & Structures 2.3 Policies, Standards, and Procedures
3 Chapter 2: Data Governance (Part B)
2.4 Data Stewardship 2.5 Governance Metrics & Implementation
4 Chapter 3: Data Modeling and Design (Part A)
Section 3.1: Conceptual, Logical, and Physical Models Section 3.2: ERD Notations & Relational Modeling Section 3.3: Normalization
5 Chapter 3: Data Modeling and Design (Part B)
3.4 Dimensional Modeling 3.5 Naming Standards & Modeling Best Practices
6 Chapter 4: Data Quality (Part A)
Section 4.1: Data Quality Dimensions Section 4.2: Data Quality Policy & Rules Section 4.3: DMAIC & DQ Improvement Lifecycle
7 Chapter 4: Data Quality (Part B)
4.4 Root-Cause Analysis & Remediation 4.5 DQ Metrics, Tools, and Reporting
8 Chapter 5: Metadata Management (Part A)
5.1 Business, Technical, and Operational Metadata 5.2 Metadata Lineage & Impact Analysis 5.3 Repository Architectures
9 Chapter 5: Metadata Management (Part B)
5.4 Standards and Semantics 5.5 Metadata Governance & Integration
10 Chapter 6: Master and Reference Data Management
6.1 Master vs Reference Data 6.2 MDM Repository Architectures 6.3 Match-Merge & Identity Resolution 6.4 Reference Data Governance & Standards
11 Chapter 7: Data Warehousing and Business Intelligence
7.1 DW Architectures: Inmon vs Kimball 7.2 Data Warehousing Storage & Load Patterns 7.3 BI Delivery & OLAP 7.4 Data Marts & Enterprise Data Warehouses
12 Chapter 8: Data Architecture
8.1 Enterprise Data Architecture & Zachman Framework 8.2 Data Flow Diagrams & Value Chains 8.3 Architecture Frameworks & Standards
13 Chapter 9: Document and Content Management
9.1 Records Management & ECM 9.2 Retention, Disposal, and E-Discovery 9.3 ARMA GARP Principles & Taxonomies
14 Chapter 10: Data Integration and Interoperability
Section 10.1: Integration Patterns & Technologies Section 10.2: Replication & Virtualization Section 10.3: Canonical Models & Integration Standards
15 Chapter 11: Data Security
Section 11.1: Security Principles: CIA Triad & Privacy Section 11.2: Access Control & Encryption Section 11.3: Security Regulations & Standards
16 Chapter 12: Data Storage and Operations
Section 12.1: Database Technologies & DBA Roles Section 12.2: Backup, Recovery, and High Availability Section 12.3: Performance Tuning & Operations
17 Chapter 13: Big Data and Data Science
13.1 Big Data V's & Technologies
18 Chapter 14: Data Ethics
14.1 DMBoK Data Ethics Framework
19 Chapter 15: Data Management Process and Maturity
15.1 Maturity Assessment Frameworks
Section 4.3: DMAIC & DQ Improvement Lifecycle
Key Takeaways Explain This Topic AI
DMAIC is a Six Sigma methodology adapted for continuous, root-cause-driven data quality improvement.
Root-cause analysis (RCA) in the Analyze phase relies on techniques like the 5 Whys and Ishikawa diagrams to prevent defect recurrence.
The Improve phase focuses on source-system fixes and data remediation rather than just temporary data cleansing.
The Control phase sustains improvements through automated monitoring dashboards, alerts, and stewardship roles.
Last updated: July 2026
The Six Sigma DMAIC Framework for Data Quality
Data quality management is not a one-time cleaning event; it is a continuous improvement cycle. DAMA DMBoK2 advocates for the use of structured quality improvement methodologies, most notably the Six Sigma DMAIC (Define, Measure, Analyze, Improve, Control) framework. Originally developed for manufacturing processes, DMAIC provides a rigorous, data-driven methodology to identify, analyze, and eliminate root causes of data defects.
- The Five Phases of DMAIC in Data Quality
- 1. Define Phase
The goal of the Define phase is to establish the project scope, identify stakeholders, align data quality initiatives with business objectives, and define the boundaries of the improvement project.
Key Activities :
Identify the Critical Data Elements (CDEs) that directly impact business operations or compliance.
Formulate a project charter that details the business case, goals, and milestones.
Document the business rules and quality expectations from the perspective of data consumers.
Deliverables : Project Charter, CDE Registry, and documented Business Rules.
2. Measure Phase
The Measure phase establishes a reliable baseline of current data quality. It answers the question: 'How bad or good is our data right now?'
Key Activities :
Execute data profiling on the identified CDEs to gather statistical properties.
Apply the business rules to the dataset to identify existing defects.
Calculate baseline data quality metrics (e.g., percentage of complete records, number of invalid entries).
Deliverables : Data Profiling Reports, Data Quality Baseline Metrics, and initial DQ Scorecards.
3. Analyze Phase
The Analyze phase focuses on identifying the root causes of the data defects measured in the previous phase. Rather than simply cleaning the data (which is a temporary fix), the team seeks to understand why the errors occur.
Key Activities :
Conduct Root-Cause Analysis (RCA) using techniques like the 5 Whys or the Ishikawa (Fishbone) Diagram .
Trace data lineage to locate the exact point of entry or transformation where the defect was introduced (e.g., input screen, ETL pipeline, API mapping).
Categorize root causes into systemic issues (e.g., missing system validation, software bugs) or operational issues (e.g., user training gaps).
Deliverables : Root-Cause Analysis Reports, Process Maps, and a prioritized list of data defect sources.
4. Improve Phase
The Improve phase focuses on developing, testing, and implementing solutions to eliminate the root causes identified in the Analyze phase, as well as cleaning up existing corrupt data.
Key Activities :
Implement Data Remediation processes to clean historic data (either through automated scripting or manual data steward intervention).
Modify source application validation controls (e.g., adding dropdown menus, making fields mandatory).
Optimize ETL logic to handle edge cases and data conversions correctly.
Deliverables : Corrected data records, deployed application code changes, updated ETL pipelines, and training materials.
5. Control Phase
The Control phase ensures that the improvements are sustained over time and that the data quality does not degrade back to its baseline state. It establishes the mechanism for ongoing governance and operational management.
Key Activities :
Implement automated data quality monitoring and alert systems that trigger when quality thresholds are breached.
Assign clear stewardship roles and responsibilities for resolving future data quality issues.
Publish regular data quality scorecards to business sponsors.
Deliverables : Continuous Monitoring Dashboards, SLA (Service Level Agreement) monitors, and Data Stewardship assignments.
DMAIC vs. Deming Cycle (PDCA)
In addition to DMAIC, DAMA DMBoK2 references the Deming Cycle or PDCA (Plan-Do-Check-Act) as a complementary continuous quality lifecycle model. The two methodologies align closely:
Plan corresponds to the Define phase, where requirements and standards are set.
Do corresponds to the business operations generating and storing data.
Check maps to Measure and Analyze , where data quality is monitored and assessed against the plan.
Act maps to Improve and Control , where corrective actions are taken to remediate errors and institutionalize controls.
DMAIC Phase PDCA Phase Core Objective DAMA DQ Activity
Define Plan Establish goals and rules Identify CDEs, document business rules, set thresholds.
Measure Check Gather baseline quality Run profiling, count defects, establish current metrics.
Analyze Check Determine root causes Run 5 Whys, map lineage, find origin of bugs.
Improve Act Implement solutions Correct source systems, remediate data, refine ETL.
Control Act / Plan Sustain improvements Deploy monitoring dashboards, assign stewards, alerts.
Deep Dive: Root-Cause Analysis Tools in the Analyze Phase
A key distinction in the DAMA DMBoK2 is the emphasis on preventative correction over reactive cleanup. Tracing defects back to their origin prevents downstream pollution. Two primary Six Sigma tools are used to accomplish this during the Analyze phase:
1. The 5 Whys
The 5 Whys is an iterative interrogative technique used to explore the cause-and-effect relationships underlying a particular problem. By repeating the question 'Why?', teams drill down through layers of symptoms to find the systemic root cause.
Problem : E-commerce invoices contain missing customer country codes.
Why? The shipping system did not pass the country code to the invoicing database.
Why? The shipping application API payload had an empty country field.
Why? The checkout form did not require the country field during purchase.
Why? The web form validation logic was disabled during a code update.
Why? There was no automated regression test for web form validation rules (Root Cause).
2. The Ishikawa (Fishbone) Diagram
The Ishikawa Diagram (or Cause-and-Effect Diagram) categorizes potential causes of a data quality problem into branches, typically:
People : Lack of training, manual data entry errors, fatigue.
Process : Undocumented steps, complex workflows, lack of review.
Technology : Software bugs, database timeout issues, network latency, bad interface design.
Data : Poor reference data, missing source files, formatting differences.
Mapping issues to these categories helps teams identify multiple contributing factors and design holistic fixes during the Improve phase.