Download PDF
QlikView® delivers insights ontap to SABMiller India
Technology Category
- Analytics & Modeling - Real Time Analytics
Applicable Industries
- Consumer Goods
Applicable Functions
- Logistics & Transportation
- Sales & Marketing
Use Cases
- Real-Time Location System (RTLS)
- Supply Chain Visibility
Services
- Data Science Services
The Challenge
SABMiller India had stored all of its data on Microsoft SQL Server and ran its Enterprise and Resource Planning (ERP) system on SYSPRO for its commercial business operations of Finance, Manufacturing and Sales and Distribution. All other business processes were supported by over 45 applications and as a result, the company was unable to generate reports by combining data from multiple applications. SAB Miller India needed reporting and analysis to provide the appropriate level of depth and flexibility in order to comply with statutory requirements, as well as for making crucial business decisions. The company was also dealing with reporting challenges. The team were pulling together multiple data sources into one report, which was a time consuming process, and an inaccurate method for reporting.
About The Customer
SABMiller plc is one of the world’s leading brewers with more than 200 beer brands and some 70,000 employees in over 75 countries. The firm also has a growing business in soft drinks and is currently one of the world’s largest bottlers of Coca-Cola products. SABMiller plc entered the Indian market under the trading name of SABMiller India in the year 2000 and currently owns ten breweries across nine states in the country, supporting several popular brands such as Haywards, Knock Out, Royal Challenge, Foster`s, Miller High Life, Indus Pride and its premium international brand Peroni Nastro Azzurro.
The Solution
As a first step the SABMiller India IT team pulled together its data sources into one single enterprise data warehouse. The company then started to investigate possible business discovery solutions in the market. They worked with a consultant to help pull together the options available in the market including Microsoft SharePoint, IBM Cognos and QlikView. They then approached Gartner for a recommendation and they suggested QlikView, which gave them great confidence in the solution and proceeded to initiate a proof of concept. SABMiller India now works with KPMG to support its QlikView platform. KPMG India helped them to develop the dashboard views, so that they can make the most of the solution within their business.
Operational Impact
Quantitative Benefit
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.
