Download PDF
QlikView Provides Business Discovery for PT. Kapal Api Global’s Big Data
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 Quality Analytics
Services
- Software Design & Engineering Services
The Challenge
PT. Kapal Api Global, a manufacturer and distributor of Fast Moving Consumer Goods (FMCG), was facing performance issues when analyzing huge amounts of data (1.5 billion records, 200 million rows). There was a 2-3 week gap needed to prepare analysis, which was affecting decision making. The conventional reporting tools they were using were unable to cope with the huge data sets and frequent user changes to analytical requirements. The company has a distribution footprint that includes more than 500,000 stores nationwide, mostly consisting of small family-owned shops.
About The Customer
PT. Kapal Api Global is a manufacturer and distributor of Fast Moving Consumer Goods (FMCG). Its flagship coffee brand, Kapal Api (“Steam Ship” in Bahasa Indonesia) represents the central pillar of its business and has nationwide distribution. The company has seven business subsidiaries and engages in the manufacture, distribution and retail of coffee products. To support its next phase of growth, the company required a better understanding of its current distribution operations with plans to increase the efficiency of its manufacturing operations.
The Solution
PT. Kapal Api Global deployed QlikView to 65 employees in less than 7 weeks. QlikView provided PT. Kapal Api Global with a straightforward way to translate their reservoir of data into actionable findings. With QlikView, the company can build various apps for sales and distribution analysis, from nationwide, down to the branch level. Users can immediately assess KPIs such as the company’s sales conversion efficiency by cross-referencing costs of acquisitions to distribution volumes, something that took 2-3 weeks previously. QlikView now delivers BI reporting on over 1.5 billion records, and is centrally accessed online by over 150 users from different sites across the country.
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.
