In Part I of this blog, I stated that before embarking on a large scale data migration from a legacy system into a new system, it is important to establish a game plan.  In Part II, once you have established the game plan, it is important to establish priorities for the Data Remediation Plan.

To build a Data Remediation Plan, you need to establish metrics by which to measure and prioritize the effort.  This will be very helpful when you have conflicting resource constraints and need to know where to begin.

In Part I, I demonstrated the importance of setting priorities for data by Mandatory field, Data Retention Policy, Data Load (null records),  Data Loss (truncation and duplication of records), Data Quality.  Once all of these parameters have been determined, you are now left with the records that need to be remediated. I will use a fictitious metrics table to provide examples of how to set up the priority for tackling each one.