Improve by Analysis and Modelling

Data Migration in Skype

A well managed data migration will ensure only the required information will be moved across to the new system or process. Validation and ownership must be put in place where the business owners sign off on the data when taking it over. A stakeholder must take on responsibility of the data. Because of this, communication is a key element of a successful data migration project.

The Challenge

Extract Skype's general ledger held on eBay's ERP system. The data had to be complete, balanced and validated by stakeholders in both Skype and eBay for accuracy and completeness. The number of transactions far exceeded Excel's capacity of 65,000 rows at the time so Excel had to process text files that held the data.

The Solution

Create macros on Excel to process comma separated (csv) files. The macros had to summarize these files in order to validation tests in place and for final signoff. This was then joined into a larger process of overall validation of the data which had to be handed over to the business owners.

The result

A well documented end to end process that showed the steps involved including business ownership and validation of data, provided confidence that all the relevant data had been extracted.

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.