Easing the data migration burden

Easing the data migration burden

What: "How to tackle data migration obstacles," a research study by Experian Data Quality.

Why:   As organizations' needs for data migration processes increase, so too do the challenges. According to a recent Experian Data Quality study, 91 percent of companies are involved with data migration projects. Yet 85 percent of those organizations face data migration problems.

The five major challenges, according to Experian, are lack of collaboration, lack of data consistency, poor system design, inaccurate information and poor interpretation of business rules.

Take aways:  Lack of collaboration results from poor communication and knowledge sharing across various departments or with outside technology providers or consultants. The study suggests laying out a clear plan and involving all stakeholders with crafting the project by assigning them tasks, so no data requirements go missing.

Because data can be stored and organized many different ways, the lack of standardized and consistent data is a growing difficulty. Ways to avoid migration project errors, delays and costs can be as simple as aligning terms and definitions and setting standards for data storage and format. (The study uses how dates are entered as an example, “01/01/2015 or 1 JAN 2015”)

If the system design cannot handle the data, it is usually because of a lack of understanding by the technical team, too little engagement by the business side and confusion between internal and external teams working separately. Simplify the problem, the report authors suggest, and unify team members with clear scoping documents, built-in error time and a project management system accessible and updateable by all.

In order to avoid migrating inaccurate data, make sure all data is correct, clean and ready for the new system by implementing a data quality strategy. Legacy data issues can take time to fix, the report stresses, so plan ahead.

Finally, relay all business rules to both the technology and business users. This carries back to collaboration, as business users must clearly establish their data requirements so the technology team has a clear understanding before jumping into migration. Make sure data rules rightfully apply to the process so the data is “fit for a given purpose.”

“Data should be seen as your organization’s most strategic asset,” the report says, so be sure to cover both business and technical needs with teamwork, planning and organization.  

Get more: www.edq.com

About the Author

Amanda Ziadeh is a former reporter/producer for GCN.


  • business meeting (Monkey Business Images/Shutterstock.com)

    Civic tech volunteers help states with legacy systems

    As COVID-19 exposed vulnerabilities in state and local government IT systems, the newly formed U.S. Digital Response stepped in to help. Its successes offer insight into existing barriers and the future of the civic tech movement.

  • data analytics (Shutterstock.com)

    More visible data helps drive DOD decision-making

    CDOs in the Defense Department are opening up their data to take advantage of artificial intelligence and machine learning tools that help surface insights and improve decision-making.

Stay Connected