Improve by Analysis and Modelling

Data Migration at Baxi

A well organised data migration project is similar to a data analysis project where it is documented well enough to be easily transferable and adaptable. If someone was picking it up in the future, they should be able to do so spending a minimum amount of time learning about the project and how it is structured. At Intellisolve, proper documentation is important. Each stage in the project is done with the necessary documentation as priority.

The Challenge

Migrate all historical data from SAP R3 to a new M3 ERP system for 4 main SAP modules. The complete data set had to be put into a format that could be easily uploaded to M3 ERP system in a standard format. For each module, data for closed and open items and header and detailed information had to be extracted and put into a standard format for upload.

The Solution

The project structure included raw data to the final dataset in the format required to upload into M3. Each of the transformations to the data was properly documented so the customer could tell the story of how the final dataset was derived. There were multiple sets of data which included the complete data set created in a format that could be queried for historical reasons as well as well as the formatted data set for upload.
All the queries were documented showing the data sets as well as the meaning of each field.

The Result

The complete processed and analysed data was presented on time and on budget with the required data sets to upload into the target system as well as the ability to query historical data without the need to revert to the source system. This meant a significant cost saving on maintenance.

The Applications Involved

During initial investigation we select the best applications that will fix your requirement and build our solutions on top of this.

The Services Involved

Come to us for our unique approach to data solutions taylor made for your unique needs. We have years of experience delivering useful solutions doing only a few things that we are really good at.

Our services allow you to hand over the techincal aspects of data management and analysis over to us to help you focus on the business

Statistical Modelling

A statistical model takes the guesswork out of thinking there are patterns in your data. Using a statistical model, you can mathematically prove if there are relationships between elements of a dataset and if so you can assign a number to the degree of the relationship. When you model real world data, relationships are a grey area. There are exceptions to rules due to the complexity of real world interactions. Intellisolve sets up statistical models the same way as financial models, focusing on the business need first and building the model around that.

We would like to hear from you.

Give us a call on 020 333 20457

Would you like a callback?

Leave your details and we will call you back.