Qlik > 实例探究 > Gatorade de Mexico quenches its thirst for real-time sales analysis with QlikView

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

Qlik Logo
公司规模
Large Corporate
地区
  • America
国家
  • Mexico
产品
  • QlikView
  • QlikView Server
  • QlikView Publisher
技术栈
  • MFG-Pro
  • MicroStrategy
  • Excel
实施规模
  • Departmental Deployment
影响指标
  • Productivity Improvements
  • Cost Savings
技术
  • 分析与建模 - 实时分析
适用行业
  • 消费品
适用功能
  • 销售与市场营销
  • 商业运营
用例
  • 实时定位系统 (RTLS)
  • 补货预测
服务
  • 数据科学服务
关于客户
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.
挑战
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.
解决方案
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.
运营影响
  • 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.
  • 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.
  • 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.
数量效益
  • Reduced reporting time from 1-4 hours to 3 minutes
  • Saving up to $237 in employee time for each report
  • Realized a full return on its QlikView investment in only four months

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

感谢您的信息!
我们会很快与你取得联系。