Case Study | Compass Group: Customer Data Platform Dashboarding Transformation
Compass Group is a multinational food and support services company based in the United Kingdom, a global leader in its sector. With a track record of over 80 years, the company operates in more than 45 countries.
It provides a wide range of services, including corporate catering, event catering, dining services for businesses, hospitals, schools, universities, prisons, among others.
In addition to food services, Compass Group also offers cleaning, maintenance, and facility management services.
Revolutionizing Procurement with Advanced Cloud Data Platform
Compass Group encountered hurdles in streamlining procurement processes due to heavy reliance on a single ERP Database. This hindered accessing, analysing, and integrating diverse data sources, impacting the ability to conduct in-depth data analytics and make strategic decisions, thus limiting operational flexibility and competitiveness in the market.
The primary challenge was effectively tracking and managing purchasing expenses across the company’s catering centers. This included managing expenses by category, center, item, and supplier, as well as tracking expenses by volume, type, and product characteristics. There was also a need for forecasting and conducting exploratory analysis on expenses, trends, stock, and period comparisons. Additionally, consolidating and automating price and profit calculations proved difficult due to reliance on manual processes and multiple sources.
To overcome these challenges, a scalable, efficient, and integrated Cloud Data Platform (CDP) on AWS, with advanced reporting and dashboard capabilities was developed. It required a robust architecture for seamless data exploration, future data sources integration, and dynamic data visualization tools to translate complex data sets into actionable insights.
This initiative was crucial for enhancing Compass Group’s procurement strategy, essential for managing global inflationary pressures and adapting to rapidly changing market demands. The project aimed to surmount these obstacles, providing a solution that would not only satisfy the immediate analytical requirements but also lay a scalable foundation for future growth and innovation within Compass Group’s data ecosystem.
Solution on AWS
Keepler engineered a cutting-edge AWS Cloud Data Platform (CDP) for Compass Group, transforming its procurement landscape. This comprehensive solution integrated seamlessly with Compass Group’s ERP Database, transitioning from traditional data management to a dynamic, cloud-based ecosystem optimised for scalability and flexibility.
AWS services used were as follows
AWS-Powered Modular Data Lake: Utilising AWS’s robust ecosystem, Keepler designed a modular Data Lake architecture. This framework enhanced data ingestion, storage, and processing, integrating seamlessly with AWS S3, Glue, Athena, and Redshift to offer secure storage and efficient data analysis.
Advanced Analytics and Dashboarding: Through Power BI, Keepler enabled transformative reporting and dashboarding, turning complex procurement data into clear, actionable insights. This strategic deployment not only improved data visualisation but also established a foundation for predictive analytics and future integration capabilities.
Scalability and Future Growth: The solution’s architecture was crafted with growth in mind, ensuring easy integration of new data sources and analytics tools. This forward-thinking approach guarantees that Compass Group’s investment continues to deliver value, supporting both current needs and future expansion.
Benefits for the client
Operational Efficiency
Automated analytics reduced manual tasks and operational costs, streamlining procurement processes.
Market Competitiveness
Enhanced analytics capabilities enabled agile market responses, optimising procurement to counter inflation.
Informed Decision-Making
Advanced dashboards provide deep insights, improving sourcing and cost strategies.
Scalability for Growth
The scalable solution ensures future growth with easy integration of new data sources.
Keepler is a full-stack analytics services company specialized in the design, construction, deployment and operation of advanced public cloud analytics custom-made solutions. We bring to the market the Data Product concept, which is a fully automated, public cloud services-based, tailored software that adds advanced analytics, data engineering, massive data processing, and monitoring features. In addition, we help our customers transition to using public cloud services securely and improve data governance to make the organization more data-centric.
Would you like to talk about your business?
We can help you leverage the power of data to enhance your operations.