Skip to the content

The University of East London can trace it's roots back to 1892, from the second industrial revolution right through to where we are now, the fourth. They are a careers-led university, dedicated to supporting students to develop the skills, emotional intelligence and creativity needed to thrive in a constantly changing world. 

The Challenge

The University of East London (UEL) recently started work on migrating over 100,000 records from a legacy alumni database to Microsoft Dynamics 365. Before migrating to D365, the data team at UEL identified a need to cleanse the Database to ensure that the new environment was populated with the best possible quality data.

 

The Objective

The main objective of the data team was to kick off the new CRM project with a fully up-to-date database, removing any information that was out-of-date, such as identifying gone-aways, movers and deceased, as well as ensuring GDPR compliance. This would then allow the University to re-engage with its alumni as effectively and cost-efficiently as possible. To help with this, the team reached out to Data8 to explore how our cleansing services could help achieve the objective.

The Solution

As a first step, UEL undertook our free data quality audit which is available via our online portal data8 online. This allowed the data team to identify any existing issues that required attention, such as address formatting issues, gone-aways and deceased records that existed on their database. By undertaking this initial audit, they could quickly assess any resource commitment needed to correct any issues and achieve an accurate view of the costs to cleanse the database as well as identifying any areas of focus to the database that required resolving before migrating to the updated CRM system.

The Outcome

The data quality audit allowed the team at UEL to not only identify issues that required attention prior to the CRM migration, but also to easily demonstrate to the board at UEL the cost and resources required to improve the data quality of the alumni database, with quantitative statistics on the improvements that will be made to that database by proceeding with the cleansing service. This resulted in a fast sign-off for the cleansing project and has also given UEL confidence to proceed with the implementation of advanced deduplication and merge tool, Data8 Duplicare, to maintain the quality of the alumni database going forward.

Working with Data8

The ability to conduct a self-service data quality audit stood out for UEL, and the ability to see transparent costs for data cleansing as a result of the audit extremely quickly were of great benefit to the data team. In fact, UEL estimate that the audit has negated the need for two full time staff and saved around three months in migration time.

Furthermore, the support offered by the Data8 client services team meant that any queries around supporting documentation or technical support were on-hand as and when needed.