Challenges
- Landcare needed to migrate legacy data from 22 different source systems.
- Legacy data needed to be cleaned, de-duplicated and transformed before it could be loaded intothe new CRM system
- Contact data was stored in Outlook, Microsoft Dynamics, Mailchimp, MYOB, PDFs, email lists and many and varied Excel workbooks
- Control of contacts was vital so a single system was needed
- Consolidation and migration of contact information was extremely complex and corporates were unable to handle the complexity
Solution
- Approach a specialist modelling and data migration company with specialised skills to handle diverse data formats
- Leverage the specialists modelling skills to create highly customised rules to handle dirty data
Outcome
- Reduction in the number of contacts by 14% after cleansing
- Simplified software portfolio and reduced licensing costs
- Company contacts were centralised
- Minimal business involvement was required for the exercise
What our Client Said
Landcare’s very successful data migration was largely attributed to the expertise of our data migration partner Analytical Models. This was a key project for Landcare as it would consolidate the contact information for the entire organisation which was at that time held in a 22 different sources, many of rather poor quality. The data needed to be cleansed, transformed through simple to complex business rules and de-duplicated before it could be migrated. Analytical Models’ extensive experience with complex data migration exercises was clear throughout the project as they led the migration effort with minimal involvement needed from Landcare. The thorough cleansing of the data reduced the number of contacts by 14% which will drive significant efficiencies within our organisation. They were responsive, professional and pro-active in the way that they ran the project and stayed within budget, we are very pleased with the outcome achieved. When we need to do another data migration we would definitely look to use their services again.
Tessa Jakszewicz
CEO – Landcare Australia