Premier Foods Enhances Decision Intelligence with AWS and Pyramid Analytics
Company Size
1,000+
Region
- Europe
Country
- United Kingdom
Product
- Pyramid Analytics
- Amazon RedShift
- Amazon S3
- Amazon CodeCommit
- SAP Business Warehouse (SAP BW)
Tech Stack
- Data Analytics
- Data Warehousing
- ETL (Extract, Transform, Load)
- Cloud Storage
- AI-guided Self-service
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Digital Expertise
- Environmental Impact Reduction
- Productivity Improvements
Technology Category
- Analytics & Modeling - Big Data Analytics
- Analytics & Modeling - Predictive Analytics
- Application Infrastructure & Middleware - Data Exchange & Integration
- Application Infrastructure & Middleware - Data Visualization
Applicable Industries
- Food & Beverage
Applicable Functions
- Business Operation
- Procurement
- Quality Assurance
Use Cases
- Supply Chain Visibility
Services
- Cloud Planning, Design & Implementation Services
- Data Science Services
- Software Design & Engineering Services
- System Integration
About The Customer
Premier Foods is one of the UK's leading food businesses, known for its beloved brands found in 93% of British households. With over 4,000 employees and operations across 15 locations in the UK, the company has a significant presence in the food industry. Premier Foods relies on extensive data analytics to manage various functions, including supply chain, commercial activities, and sustainability efforts. The company processes an impressive 25 million records daily, necessitating a robust and efficient data analytics system. Premier Foods' commitment to innovation and efficiency drives its continuous search for advanced technological solutions to enhance its operations and meet regulatory requirements.
The Challenge
Premier Foods faced significant challenges with its existing SAP-based data analytics system, which relied heavily on spreadsheet-based reporting and outdated data warehousing. This system lacked external data integration capabilities and built-in data visualization, leading to manual, offline reporting and limited business intelligence (BI). The need for more flexible data sourcing, faster processing, and more frequent reporting was critical. Additionally, compliance with the recent Environmental Social and Governance (ESG) legislation in the UK required integrating data sets that the current system could not support. These limitations directly impacted business efficiency and productivity, prompting Premier Foods to seek a more advanced solution.
The Solution
Premier Foods turned to AWS Partner Pyramid Analytics to address its data analytics challenges. Pyramid Analytics offers a decision intelligence platform that combines data preparation, business analytics, and data science within a single platform. This platform features a super-fast direct query engine and an AI-guided self-service experience, enabling non-technical users to gain insights quickly. The new system needed to connect with SAP Business Warehouse (SAP BW) to access transaction data and integrate with Amazon RedShift for reporting on non-transactional data from multiple sources. Amazon S3 was used for data storage, while Amazon CodeCommit managed the code in Matillion, the ETL tool. Pyramid Analytics facilitated reporting on data from both SAP BW and RedShift, with Amazon Cloud Watch providing monitoring alerts. The implementation involved close collaboration between Pyramid's team and Premier Foods' team during the Proof of Concept (POC) stage, ensuring robust connections between tools and data sources. Recommendations on server sizing and environment structuring helped Premier Foods successfully deploy the new solution.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
The Kellogg Company
Kellogg keeps a close eye on its trade spend, analyzing large volumes of data and running complex simulations to predict which promotional activities will be the most effective. Kellogg needed to decrease the trade spend but its traditional relational database on premises could not keep up with the pace of demand.
Case Study
HEINEKEN Uses the Cloud to Reach 10.5 Million Consumers
For 2012 campaign, the Bond promotion, it planned to launch the campaign at the same time everywhere on the planet. That created unprecedented challenges for HEINEKEN—nowhere more so than in its technology operation. The primary digital content for the campaign was a 100-megabyte movie that had to play flawlessly for millions of viewers worldwide. After all, Bond never fails. No one was going to tolerate a technology failure that might bruise his brand.Previously, HEINEKEN had supported digital media at its outsourced datacenter. But that datacenter lacked the computing resources HEINEKEN needed, and building them—especially to support peak traffic that would total millions of simultaneous hits—would have been both time-consuming and expensive. Nor would it have provided the geographic reach that HEINEKEN needed to minimize latency worldwide.
Case Study
Energy Management System at Sugar Industry
The company wanted to use the information from the system to claim under the renewable energy certificate scheme. The benefit to the company under the renewable energy certificates is Rs 75 million a year. To enable the above, an end-to-end solution for load monitoring, consumption monitoring, online data monitoring, automatic meter data acquisition which can be exported to SAP and other applications is required.
Case Study
Coca Cola Swaziland Conco Case Study
Coco Cola Swaziland, South Africa would like to find a solution that would enable the following results: - Reduce energy consumption by 20% in one year. - Formulate a series of strategic initiatives that would enlist the commitment of corporate management and create employee awareness while helping meet departmental targets and investing in tools that assist with energy management. - Formulate a series of tactical initiatives that would optimize energy usage on the shop floor. These would include charging forklifts and running cold rooms only during off-peak periods, running the dust extractors only during working hours and basing lights and air-conditioning on someone’s presence. - Increase visibility into the factory and other processes. - Enable limited, non-intrusive control functions for certain processes.
Case Study
Temperature Monitoring for Restaurant Food Storage
When it came to implementing a solution, Mr. Nesbitt had an idea of what functionality that he wanted. Although not mandated by Health Canada, Mr. Nesbitt wanted to ensure quality control issues met the highest possible standards as part of his commitment to top-of-class food services. This wish list included an easy-to use temperature-monitoring system that could provide a visible display of the temperatures of all of his refrigerators and freezers, including historical information so that he could review the performance of his equipment. It also had to provide alert notification (but email alerts and SMS text message alerts) to alert key staff in the event that a cooling system was exceeding pre-set warning limits.
Case Study
Coca-Cola Refreshments, U.S.
Coca-Cola Refreshments owns and manages Coca-Cola branded refrigerators in retail establishments. Legacy systems were used to locate equipment information by logging onto multiple servers which took up to 8 hours to update information on 30-40 units. The company had no overall visibility into equipment status or maintenance history.
