Case Studies Premier Foods Enhances Decision Intelligence with AWS and Pyramid Analytics

Edit This Case Study Record

	Premier Foods Enhances Decision Intelligence with AWS and Pyramid Analytics

Premier Foods Enhances Decision Intelligence with AWS and Pyramid Analytics

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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

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

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.

About 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.

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.

Impact #1	The new Pyramid-AWS model significantly improved data processing speed and visibility, enabling Premier Foods to make faster and more informed decisions.
Impact #2	The integration with SAP BW and Amazon RedShift allowed seamless access to transaction and non-transactional data, enhancing data accuracy and reliability.
Impact #3	The AI-guided self-service experience empowered non-technical users to generate insights independently, reducing reliance on IT support and increasing overall productivity.

Impact #1

The new Pyramid-AWS model significantly improved data processing speed and visibility, enabling Premier Foods to make faster and more informed decisions.

Impact #2

The integration with SAP BW and Amazon RedShift allowed seamless access to transaction and non-transactional data, enhancing data accuracy and reliability.

Impact #3

The AI-guided self-service experience empowered non-technical users to generate insights independently, reducing reliance on IT support and increasing overall productivity.

Benefit #1	Premier Foods processes 25 million records daily with the new system.
Benefit #2	The implementation led to measurable increases in processing speed within a few months.
Benefit #3	The new system supports compliance with the UK's Plastic Packaging Tax, reducing manual reporting efforts by months.

Benefit #1

Premier Foods processes 25 million records daily with the new system.

Benefit #2

The implementation led to measurable increases in processing speed within a few months.

Benefit #3

The new system supports compliance with the UK's Plastic Packaging Tax, reducing manual reporting efforts by months.

Download PDF Version

Overview

Premier Foods Enhances Decision Intelligence with AWS and Pyramid Analytics

Operational Impact

Quantitative Benefit