Gatorade de Mexico quenches its thirst for real-time sales analysis with QlikView
Customer Company Size
Large Corporate
Region
- America
Country
- Mexico
Product
- QlikView
- QlikView Server
- QlikView Publisher
Tech Stack
- MFG-Pro
- MicroStrategy
- Excel
Implementation Scale
- Departmental Deployment
Impact Metrics
- Productivity Improvements
- Cost Savings
Technology Category
- Analytics & Modeling - Real Time Analytics
Applicable Industries
- Consumer Goods
Applicable Functions
- Sales & Marketing
- Business Operation
Use Cases
- Real-Time Location System (RTLS)
- Predictive Replenishment
Services
- Data Science Services
About The Customer
Gatorade de Mexico is a subsidiary of PepsiCo, Inc. and is the manufacturer of the leading sports drink, Gatorade. Gatorade is scientifically formulated and athletically proven to quench thirst, replace fluids and electrolytes, and provide carbohydrate energy to enhance athletic performance. Outside the United States, Latin America and especially Mexico, is one of the most important markets for the American brand Gatorade. The company has a strong growth opportunity in these markets and to best take advantage of this, the sales support team at Gatorade de Mexico wanted to ensure they had accurate sales visibility to quickly respond to market changes for competitive advantage.
The Challenge
Gatorade de Mexico, a subsidiary of PepsiCo, Inc., was facing challenges in accessing real-time sales data to proactively respond to market changes. The company was using MicroStrategy for Business Intelligence (BI) and reporting, but the tool’s complexity made it difficult for the sales support team to easily access and analyze the real-time data they needed. Producing reports could take anywhere from 40 minutes for basic sales performance reports to four hours for more strategic sales analysis. The business users needed to engage a sales support analyst to run multiple MicroStrategy reports, export them to Excel, and then map, update and consolidate the data to get the answers they needed. Since MicroStrategy only refreshed on a daily basis, the information was outdated and the high level of manual manipulation increased the margin of error.
The Solution
Gatorade de Mexico deployed QlikView to 20 employees in less than one week. With QlikView, Gatorade now analyzes order cycles from order through billing, sales expenses, and account sales and profitability, all focused on driving increased sales. With QlikView Server (32-bit) and QlikView Publisher, Gatorade easily supports security and visibility while handling the modest data volume tens of millions of records. The company developed a sales overhead application that tracks all overhead, such as Travel & Entertainment, marketing, and office expenses, in relationship to sales for each account and each salesperson. Every component of overhead expense can then be analyzed to see if there is an opportunity for savings. In addition, sales management is empowered with a more detailed and actionable view of each individual salesperson’s performance and related costs.
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.
.png)
Case Study
Improving Vending Machine Profitability with the Internet of Things (IoT)
The vending industry is undergoing a sea change, taking advantage of new technologies to go beyond just delivering snacks to creating a new retail location. Intelligent vending machines can be found in many public locations as well as company facilities, selling different types of goods and services, including even computer accessories, gold bars, tickets, and office supplies. With increasing sophistication, they may also provide time- and location-based data pertaining to sales, inventory, and customer preferences. But at the end of the day, vending machine operators know greater profitability is driven by higher sales and lower operating costs.
Case Study
Series Production with Lot-size-1 Flexibility
Nobilia manufactures customized fitted kitchens with a lot size of 1. They require maximum transparency of tracking design data and individual processing steps so that they can locate a particular piece of kitchen furniture in the sequence of processes.
Case Study
American Eagle Achieves LEED with GE LED Lighting Fixtures
American Eagle Outfitters (AEO) was in the process of building a new distribution center. The AEO facility management team decided to look at alternate options for lighting layout that could provide energy and maintenance savings. AEO would need a full-time maintenance employee just to replace burned-out fluorescent tubes.
Case Study
Revolutionizing Rodent Control
From pet- and child-safe traps, to touch-free and live-catch rodent control solutions, Victor continues to stay committed to producing superior products that meet the varying needs of today’s pest control professionals. And, with a long standing history supporting customers in the food processing, service, and retail settings, Victor knew that strict regulations were costing organizations thousands of dollars in excess overhead trying to manage their rodent-control solutions. Trap inspections in these environments are often difficult and time consuming, requiring personnel to manually check a trap’s status multiple times per day, amounting to over six hours of manual labor. Victor is looking for an innovative way to increase operational efficiencies with the use of technology.
