- Do you know where all the data is?
- Who owns the data?
- Why is it needed and how is it used?
- Is the data ready to be moved?
- Is it clean i.e. complete, consistent and accurate?
- How will it be moved?
- If you don’t understand your data, and the vendors don’t understand your business processes, how will the new system meet the business requirements?
Data Cleansing & Migration
Good quality client data is essential to a successful project.
Whether you are interfacing a new system to the existing infrastructure, replacing systems, or moving to or from an outsource provider, the most critical element of the project is having good quality data.
Understanding the data contained deep with your system’s background databases is normally left to the techies. However, they frequently don’t understand the business processes. Meanwhile, the business often doesn’t understand the database structures and relationships. Yet when it comes to changing the infrastructure or vendors, understanding the data plays a pivotal role in the project – one that is often left to people ill-equipped to handle this key role. Inevitably, this leads to delay and complication.
The steps we take in this stage of a project include:
- Find all the data stores; analyse and profile the data
- Understand the data and its interrelationships
- Prioritise and start the cleansing activity
- Map your existing data to the new system structures
- Construct the extraction routines
- Construct the transformation routines
- Load the data in the new database structures
Our team of experienced professionals have been analysing and manipulating data for decades and can help guide you through this complex and risky area of any project. Contact us to find out more.
See also: Client Data Analysis