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.

Technology

Task Activities

  1. Customer

    Develop Data Governance Model to include the approach, process, roles and responsibilities, criteria/metrics

  2. Customer

    Determine criteria for assessing data quality

  3. Customer

    Conduct Data Quality Assessment, including master and transactional data

  4. Customer

    Identify data issues (e.g. duplication, missing data, incorrect data) based on the assessment and prioritize data cleansing needs

  5. Customer

    Develop a Data Cleansing Plan based on the prioritization

  6. Customer

    Report updates in governance meetings and Status Reports/Dashboards

  7. Customer

    Begin initial data cleansing

  8. Customer

    Update the Project Business Case

  9. Customer

    Populate the Investment Readiness Checklist

1.10 Best Practices

  • It is critical to success to begin data cleansing activities well before migration activities begin and continuously throughout the implementation to assist with data readiness
  • Define and establish the framework for the overall management of the availability, usability, integrity, and security of data in the Data Governance Model
  • Assign dedicated resources for data cleansing activities to ensure successful migration
  • Gain 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 through the Data Governance Model on what threshold constitutes “clean” data. Outline the course of actions to cleanse data in legacy systems or staging area to prepare it for migration to the provider system in the Data Cleansing Plan

Stakeholders

Customer

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

Inputs

  • Existing System Data Dictionaries
  • Existing Data Quality Assessments
  • Functional Specifications
  • Project Business Case

Outputs