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 leads to easier decision making. 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 MDL resolver 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 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 MDL man we have the experience of fixing data migration problems and again our consultants use MDL resolver 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 MDL resolver 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 usually arises in a new system if the data cleaning process wasn’t completed thoroughly prior to data load. MDL man can help you address all these problems by implementing a maintenance process using MDL resolver 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 MDL man ensures your LMS project can be delivered on time and within budget and 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.