The Challenge
Derby University faced the challenge of managing and extracting complex CRM data from a diverse range of sources, including current students, alumni, prospects, and applicants. Their goal was to improve the accuracy and consistency of their marketing activities by developing a robust CRM data warehouse.
The Solution
To address this challenge, our team conducted workshops with business users to fully understand their requirements and define project goals. We identified gaps in the existing data and addressed current challenges. Taking ownership of the project, we managed additional resources and workflows to ensure successful and timely delivery.
We developed complex ETL routines to create and update the CRM data warehouse, enhancing data accuracy and automating auditing processes. This approach increased confidence in the CRM data, leading to more effective marketing campaigns and improved data consistency.
The Results
Our solution significantly improved Derby University’s CRM data management, providing a reliable and accurate data warehouse that enhanced marketing efforts. The automated processes and improved data quality allowed for more precise and consistent marketing activities, supporting the university’s strategic goals and operational needs.