Qlik Case Studies Gatorade de Mexico quenches its thirst for real-time sales analysis with QlikView

Edit This Case Study Record

	Gatorade de Mexico quenches its thirst for real-time sales analysis with QlikView Qlik

Gatorade de Mexico quenches its thirst for real-time sales analysis with QlikView

Qlik

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

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

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.

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

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.

Impact #1	Gatorade’s sales support analysts are no longer spending their time manually compiling and updating reports; instead, they are free to analyze data to identify market opportunities and areas for potential cost savings.
Impact #2	With a reduction in report generation time from 1-4 hours before QlikView to just three minutes today, Gatorade is saving up to $237 for each of its 10 employees time for 10 reports each day.
Impact #3	Those cost savings, in conjunction with increased visibility for gains in operational effectiveness and additional revenue opportunity identification, enabled the company to realize a full return on its QlikView investment in only four months.

Impact #1

Gatorade’s sales support analysts are no longer spending their time manually compiling and updating reports; instead, they are free to analyze data to identify market opportunities and areas for potential cost savings.

Impact #2

With a reduction in report generation time from 1-4 hours before QlikView to just three minutes today, Gatorade is saving up to $237 for each of its 10 employees time for 10 reports each day.

Impact #3

Those cost savings, in conjunction with increased visibility for gains in operational effectiveness and additional revenue opportunity identification, enabled the company to realize a full return on its QlikView investment in only four months.

Benefit #1	Reduced reporting time from 1-4 hours to 3 minutes
Benefit #2	Saving up to $237 in employee time for each report
Benefit #3	Realized a full return on its QlikView investment in only four months

Benefit #1

Reduced reporting time from 1-4 hours to 3 minutes

Benefit #2

Saving up to $237 in employee time for each report

Benefit #3

Realized a full return on its QlikView investment in only four months

Download PDF Version

Overview

Gatorade de Mexico quenches its thirst for real-time sales analysis with QlikView

Operational Impact

Quantitative Benefit