Data migration and cleansing

What's the problem?

You’ve changed systems as you’ve grown – and you need to migrate data from the old system to the new.
You’ve got data in all sorts of systems, and an array of formats – but you need it all in one place.
Data in the wrong format could cause errors in operations or reporting.

What are the steps?

Data discovery

Work with your migration project team to understand:

Which data is to be moved
Its current format
The format expected by the new (target) system

Data discovery

Work with your migration project team to understand:

Which data is to be moved
Its current format
The format expected by the new (target) system

Data discovery

Work with your migration project team to understand:

Which data is to be moved
Its current format
The format expected by the new (target) system

Data analysis

Identify any format differences that could cause an error. Identify if there is any incorrect or missing data in the current system. Document all data cleansing that is required.

Data analysis

Identify any format differences that could cause an error. Identify if there is any incorrect or missing data in the current system. Document all data cleansing that is required.

Data analysis

Identify any format differences that could cause an error. Identify if there is any incorrect or missing data in the current system. Document all data cleansing that is required.

Data cleansing

Put all data into the correct format for the new system, correct any data errors and fill any data gaps. Automate and streamline this process using the Power Query tool.

Data cleansing

Put all data into the correct format for the new system, correct any data errors and fill any data gaps. Automate and streamline this process using the Power Query tool.

Data cleansing

Put all data into the correct format for the new system, correct any data errors and fill any data gaps. Automate and streamline this process using the Power Query tool.

The outcome

Fully cleansed, formatted and complete data, so that you can run your migration with confidence that your operational processes and your reporting will run like clockwork.

Back

Find out more