Skip to main content
U.S. flag

An official website of the United States government

Dot gov

The .gov means it’s official.
Federal government websites often end in .gov or .mil. Before sharing sensitive information, make sure you’re on a federal government site.

Https

The site is secure.
The https:// ensures that you are connecting to the official website and that any information you provide is encrypted and transmitted securely.


M3 Framework Introduction M3 Framework Overview M3 Phase 0 - Assessment M3 Phase 1 - Readiness M3 Phase 2 - Selection M3 Phase 3 - Engagement M3 Phase 4 - Migration M3 Phase 5 - Operations M3 Resources
M3 Playbook > Phase 2: Selection
2.7 Conduct Initial Data Cleansing Activities
2.6 Develop Change Management Plan
2.8 Develop a Decommission Plan
Image Map Phase 0: Assessment Phase 1: Readiness Phase 2: Selection Phase 3: Engagement Phase 4: Migration Phase 5: Operations
Objective: Continue cleansing data based upon data quality assessment results and agreed upon quality metrics in data governance model.

Phase 2 GuidanceResponsible Party - Customer, Provider, Shared
Activities
1. Assess data quality against defined criteria after cleansing activities from previous phase (C)
2. Update manual and automated cleansing methods as necessary for additional cleansing needs (C)
3. Conduct additional data cleansing and update scripts and batch cycles (C)
4. Report updates in governance meetings and Status Reports/Dashboards (C)

Inputs
• Data Cleansing Plan
• Data Quality Assessment Results

Outputs
• Data Cleansing Plan
• Data Cleansing Scripts
Stakeholders
• Business Owner (C)
• Program Manager (C)
• Functional Lead (C)
• Technical Lead/Solution Architect (C)
• Data Conversion Lead (C)
• Data SME (C)

Best Practice
• Begin data cleansing activities prior to migration activities and continuously throughout the implementation to assist with data readiness
• Gain agreement on data governance including metadata management and data quality management
• Allocate a sufficient number of SMEs with the appropriate skill sets to support data conversion activities throughout the implementation
• Establish criteria and metrics through the Data Governance approach on what constitutes “clean” data