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.

The Modernization and Migration Management (M3) Playbook has a new look! Explore our new features here.

M3 Playbook > Phase 2: Selection > 2.7 Conduct Initial Data Cleansing Activities

2.7 Conduct Initial Data Cleansing Activities

Technology

Task Activities

  1. Customer

    Assess data quality against defined criteria in the Data Cleansing Plan after cleansing activities from previous phase

  2. Customer

    Update manual and automated cleansing methods as necessary for additional cleansing needs

  3. Customer

    Conduct additional data cleansing and update Data Cleansing Scripts and batch cycles

  4. Customer

    Report updates in governance meetings and Status Reports/Dashboards, informing QSMOs as necessary

2.7 Best Practices

  • Begin data cleansing activities prior to migration activities and continuously throughout the implementation to assist with data readiness
  • Obtain agreement on data governance including metadata management and data quality management
  • Allocate a sufficient number of Subject Matter Experts (SMEs) with the appropriate skill sets to support data conversion activities throughout the implementation
  • Establish criteria and metrics to clearly convey what constitutes “clean” data as part of the broader data governance approach

Stakeholders

Customer

  • Business Owner
  • Program Manager
  • Functional Lead
  • Technical Lead/Solution Architect
  • Data Conversion Lead
  • Data SME

Inputs

  • Data Cleansing Plan
  • Data Quality Assessment Results

Outputs