Skip to main content
M3 Playbook > Phase 2: Selection > 2.7 Conduct Initial Data Cleansing Activities
Play Icon

2.7 : Conduct Initial Data Cleansing Activities

Technology
  1. Customer

    Assess data quality against defined criteria after cleansing activities from previous phase

  2. Customer

    Refine both automated and manual methods used for cleansing data

  3. Customer

    Perform additional cleansing; update cleansing scripts and batch cycles

  4. Customer

    Report updates in leadership meetings and Reports/Dashboards, informing stakeholders

2.7 Lessons Learned

  • Start data cleansing before implementation and iterate continuously, as needed, to ensure readiness
  • Obtain agreement on data governance including metadata management and data quality management
  • Allocate sufficient number of Subject Matter Experts (SMEs) with appropriate skills to support data conversion
  • Establish criteria / metrics to clearly convey what constitutes “clean” data in the broader data governance approach

Stakeholders

Recommended stakeholders, inputs, & outputs may vary by implementation; however, agencies that contributed to this Playbook reported these factors as increasing the likelihood of success.

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

USSM.GSA.gov

An official website of the General Services Administration

Looking for U.S. government information and services?
Visit USA.gov