Why is it so important to carry out a data integrity test and data cleansing process as part of your implementation?
Pre-migration – data preparation
The best time to look at existing ITM/LMS data is right at the start of the implementation project and ideally, this should form part of an ITM/LMS implementation checklist. Data Profiling and measuring the quality of the data means that Project Managers can more accurately identify the amount of effort and time required to clean data and fix data integrity problems. Using MDLresolver at this early stage makes this process quick and easy.
Implementation – ITM/LMS data migration problems
Many companies start a new ITM/LMS project without considering potential data migration problems. It is only when they are asked to provide data for the new system that they first encounter data transfer and integrity problems. This puts additional stress on the already stretched IT, Learning & Development and HR departments, particularly if they try to fix the problem themselves without the tools and a structured process to follow. This results in project delays, increased costs, end user dissatisfaction; and even potential interruption to business.
At MDLman we have the experience of fixing data migration problems and again our consultants use MDLresolver to quickly resolve these common problems with data migration projects.
Overcoming data migration problems
Typically, we are bought in by either the ITM/LMS provider or the customer directly when they first encounter problems during the data upload phase of the project. As this is part of the critical path, even a slight delay at this stage will be harmful to the success of the project. Once again, our consultants use MDLresolver which not only maps the data from the legacy system to the requirements of the new target system but also can be used to reformat the data, remove unwanted characters and highlight any inconsistencies that may prevent a successful data upload. As a result, we have seen data load failures drop by over 90% and data load throughput increase by over 400%.
Live – Fixing common production data and integrity problems
Once in production, any ITM/LMS is only as good as the data entered. There is often a requirement to remove duplicate data, carry out address verification or fix data integrity problems where links have been broken. This situation is caused by the absence of field verification at point of entry and is exacerbated in a new system if the data cleaning process wasn’t completed thoroughly prior to data load. MDLman can help you address all these problems by implementing a maintenance process using MDLresolver to regularly check the integrity of your production data to ensure it is always accurate. By doing this, the ITM/LMS can operate at the optimum level, analysis can be conducted with confidence and end-user satisfaction increases because there are less trouble tickets raised as a result of data issues.
Engaging MDLman ensures your ITM/LMS project can be delivered on time and within budget. In addition, after deployment, we have seen an increase in customer satisfaction from Learning & Development and HR functions and the end user because the system is working well and delivering value.