Achieving Operational Excellence at George Weston Foods with SnapLogic Integration
Customer Company Size
Large Corporate
Region
- Pacific
Country
- Australia
- New Zealand
Product
- SnapLogic Enterprise Integration Cloud
- Tableau
- Amazon Redshift
Tech Stack
- REST API
- SQL Server
- SAP
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Productivity Improvements
- Cost Savings
- Digital Expertise
Technology Category
- Platform as a Service (PaaS) - Connectivity Platforms
- Application Infrastructure & Middleware - Data Visualization
- Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries
- Food & Beverage
Applicable Functions
- Sales & Marketing
- Business Operation
Use Cases
- Supply Chain Visibility
Services
- System Integration
- Cloud Planning, Design & Implementation Services
About The Customer
George Weston Foods (GWF) is one of the largest food manufacturers in Australia and New Zealand, with a history spanning over 50 years. The company is headquartered in Sydney, Australia, and operates in the fast-moving consumer goods (FMCG) industry. GWF employs over 6,000 people and has a diverse portfolio of four brands. The company is known for delivering fresh products to supermarkets daily, ensuring that customers receive the food they love. GWF's commitment to quality and consistency in its products, such as freshly baked bread, is a key factor in its success. The company relies on streamlined sales operations processes and effective data analysis to maintain its high standards and meet customer expectations. Despite using multiple cloud applications to facilitate data analysis, GWF faced challenges in achieving consistent data sets and reporting, which prompted the need for a more integrated and efficient data management solution.
The Challenge
A large part of George Weston Foods’ (GWF) success comes from delivering fresh products to supermarkets each day to delight its customers with the food they love. To continually provide consistent and high-quality products like freshly baked bread, GWF requires more streamlined Sales Operations processes. Multiple teams at GWF worked behind the scenes to analyze hundreds of thousands of data points and understand what they mean to the business. Though these teams used multiple cloud applications to ease their data analysis process, they still struggled to get consistent sets of data and reporting. Even though different teams used the same sets of data and existing tools to perform analysis, the results produced varied outcomes. GWF used a middleware platform for data orchestration, which while great for EDI and B2B, its strength was not extracting large batches of data, such as those that contained 1GB of customer orders (SKUs). “We had great systems, but we couldn’t effectively get the data into a centralized application. We needed to get a trusted and validated data representation where users, like sales and marketing, can go in and get the data they needed,” said Stephen Mackay, Solutions Architect at GWF.
The Solution
Working with multiple business representatives across GWF and its businesses, Mr. Mackay started looking for an integration platform-as-a-service (iPaaS) to consolidate data from the ERP and other line of business applications into a centralized cloud-based data warehouse. Mr. Mackay required an iPaaS to provide ease of use for the business, and ultimately, improve efficiency in their current business and IT operations. After evaluating multiple solutions, Mr. Mackay and his team identified SnapLogic as their iPaaS of choice. “We chose SnapLogic primarily for its ease of use both for our lean IT team and citizen integrators. It only took a couple of hours to setup and start building integrations, and we believe that the REST API capability is key to the future of IT and for building a digital platform,” said Mr. Mackay. Business teams are now able to move data amongst the cloud applications. GWF can export and move data from existing data repositories, SaaS services, and other applications into a cloud-base data warehouse hosted by AWS. People can easily access relevant data sets from Tableau to build reports ranging from sales and finance to operations and supply chain metrics.
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.
