Why is it so important to carry out a data integrity test and data cleansing process as part of your LMS implementation?
Pre-migration – data preparation
The best time to look at existing LMS data is right at the start of the LMS implementation project; and ideally this should form part of an LMS implementation checklist. Going through a data profiling exercise at the start means that Project Managers can more accurately identify the amount of effort and time required to clean data and fix data integrity problems in the new LMS. We have found that using MDLresolver at this early stage makes this process quick and easy.
Implementation – LMS data migration problems
Many companies start a new LMS project without considering potential data migration problems. It is only when they are asked to provide data for the new LMS that they first encounter data transfer problems. This puts additional stress on the already stretched IT and Learning & Development 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 LMS data migration projects.
Overcoming data migration problems
Typically, we are bought in by either the 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 through put increase by over 400%.
Live – Fixing common production data and integrity problems
Once in production, any LMS is only as good as the data entered in to it. 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 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 LMS project can be delivered on time and within budget. In addition, after deployment we have seen an increase in customer satisfaction from both the Learning & Development function and the end user because the system is working well and delivering value.