Identifying the approach to remediation

Now that the priorities are understood, it is time to work on the approach to remediating the bad data. There are a number of different approaches that can be applied and the effort involved varies hugely.

Typically, each prioritized rule can be categorized into a particular approach. Most often, only one approach will apply to each issue. Sometimes there might be the possibility to apply two or more approaches to a particular issue.

For example, if supplier email addresses are missing in the ERP system to send remittance advice details, three approaches might apply:

1. The data might be in another system (for example, a contract management system) for 40% of the vendors who are missing the data. For these, the data would be migrated across to the ERP system in a batch.
2. The data might be available on previous supplier invoices for a further 40% of the vendors and could be collected and keyed in.
3. The data might have to be collected...