Case Study: Data Warehouse Assessment
Leading to Ongoing Relationship
Challenge
- A Director of Data & Insight asked us to assess the Data Warehouse project being delivered by a well-known Big 5 consultancy firm, from a quality and cost view.
- The project was a key enabler to driving personalised contacts across the group and involved bringing the data in-house from an external agency.
- Previously a big name IT house had also failed in delivering the project
Solution
- We spent 6 weeks assessing each element of the programme, highlighted numerous areas of concern and did a financial forecast on the project which showed major gaps and deficiencies.
- The incumbent supplier as accountable for fixed price delivery but could not deliver within the parameters of the project – it was just unrealistic.
- We restructured the project, replaced multiple key resources and focused on developers and technical solution design, rather than leadership roles.
- Ultimately the project was delivered and integrated with SAS for analytics and campaigning. The solution is in production today.
- We were subsequently asked to recruit all the permanent team members for the expanded Group Data & Insight department.
Results
- The data project was hugely complex and required us working with experts in single customer view design and implementation.
- The deployment of SAS linked to a new data warehouse now delivers hugely profitable personalised targeted campaigns.
- We still support our client with all their insight hires and specialist resource on consulting basis as needed.
- As they upgrade their infrastructure we are well placed to provide continued ongoing consulting and development support.