
2.7 : Conduct Initial Data Cleansing Activities
Objective
Cleanse data based on Data Quality Assessment Results and agreed to quality metrics.
View Lessons LearnedRecommended Best Practices
-
Customer
Assess data quality against defined criteria after cleansing activities from previous phase
-
Customer
Refine both automated and manual methods used for cleansing data
-
Customer
Perform additional cleansing; update cleansing scripts and batch cycles
-
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
- Data Cleansing Plan
- Data Cleansing Scripts
- Status Reports/Dashboards