Download PDF
Pyramid’s Decision Intelligence Platform puts Export Packers on a new trajectory for growth
Technology Category
- Analytics & Modeling - Predictive Analytics
- Application Infrastructure & Middleware - Data Visualization
- Functional Applications - Enterprise Resource Planning Systems (ERP)
Applicable Industries
- Food & Beverage
Applicable Functions
- Business Operation
- Procurement
- Sales & Marketing
Services
- Software Design & Engineering Services
- System Integration
- Training
The Challenge
An Ontario-based importer, exporter, and distributor of food commodities, Export Packers has been around for over 80 years and is one of Canada’s largest privately held companies. Despite being a market leader with a reputation for quality, customer service, and innovation, the company wanted to take advantage of new technologies and increase efficiencies around business-to-business relationships. When John Stakel joined the company as Head of Information Technology in 2019, his mission was clear: “I was brought in to rehabilitate the technology stack. We had a tendency to be entrepreneurs at every level in the organization, which is great but very execution-oriented; we were absolutely lacking in all sorts of actionable insight.” The company’s ERP system was Microsoft Navision, running on SQL Server with a Citrix publishing tool. For business intelligence (BI), information from Navision was authored into Excel or taken directly into hundreds of Microsoft Access databases, depending on the level of integration. Either way, it was hard to get insights into inventory, sales, procurement, and the profitability of trades. “We created a scheduler because other jobs were kicking the Access databases off the system, but it was just putting a Band-Aid on the problem,” explained Stakel. “As well as investing in a new ERP system, we wanted to change the culture, the way people in the company think about information. We needed to start convincing them that there’s a different way to consume insights than a PDF and Excel spreadsheet.”
About The Customer
Export Packers is an Ontario-based importer, exporter, and distributor of food commodities. With over 80 years of experience, it is one of Canada’s largest privately held companies. The company is known for its quality, customer service, and innovation. Despite its market leadership, Export Packers sought to leverage new technologies to increase efficiencies in its business-to-business relationships. The company’s ERP system was Microsoft Navision, running on SQL Server with a Citrix publishing tool. For business intelligence (BI), information from Navision was authored into Excel or taken directly into hundreds of Microsoft Access databases, depending on the level of integration. This made it challenging to gain insights into inventory, sales, procurement, and the profitability of trades. The company aimed to modernize its technology stack and change its culture to become more data-driven.
The Solution
To identify levels for reporting, the internal IT team had to scope the relationship between dimensions; they had to familiarize themselves with ETL processes, data transformation, and data modeling. Onboarding people to Pyramid was a culture change and a technical challenge, according to Stakel, but what he liked about the platform was the way it could be rolled out incrementally—his point about not putting too much pressure on the organization at the start. “We would work in one area of the business at a time,” he said. “We started with the trading organization.” A first iteration was developed with a data model and dashboards that allowed the sales team to dig down into revenue and profitability. Next came the procurement group. To make a big change workable, they were able to compare their old reports with new ones from Pyramid to understand the transition. “There was a trust-building exercise that took a few months,” explained Stakel. He described it as a journey to “change hearts and minds,” to move away from transactional and operational analytics to deeper-routed intelligence around profitability, looking at margins on a product-by-product basis.
Operational Impact
Quantitative Benefit
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.
