Qlik Case Studies QlikView Provides Business Discovery for PT. Kapal Api Global’s Big Data

Edit This Case Study Record

	QlikView Provides Business Discovery for PT. Kapal Api Global’s Big Data Qlik

QlikView Provides Business Discovery for PT. Kapal Api Global’s Big Data

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Consumer Goods
Applicable Functions	Business Operation Sales & Marketing
Use Cases	Predictive Quality Analytics Real-Time Location System (RTLS)
Services	Software Design & Engineering Services
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Consumer Goods

Applicable Functions

Business Operation

Sales & Marketing

Use Cases

Predictive Quality Analytics

Real-Time Location System (RTLS)

Services

Software Design & Engineering Services

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

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.

Impact #1	A user-friendly dashboard to visualize business intelligence
Impact #2	Reduced lead time to business intelligence reporting facilitated actionable insights and decision-making
Impact #3	A 2013 roadmap for operational efficiency and business expansion supported by QlikView

Impact #1

A user-friendly dashboard to visualize business intelligence

Impact #2

Reduced lead time to business intelligence reporting facilitated actionable insights and decision-making

Impact #3

A 2013 roadmap for operational efficiency and business expansion supported by QlikView

Benefit #1	QlikView generated reports in less than 20 seconds for nationwide analysis, and just 2 seconds for regional or branch-level analysis
Benefit #2	QlikView was able to go live within 7 weeks instead of 5-6 months with competing vendors

Benefit #1

QlikView generated reports in less than 20 seconds for nationwide analysis, and just 2 seconds for regional or branch-level analysis

Benefit #2

QlikView was able to go live within 7 weeks instead of 5-6 months with competing vendors

Download PDF Version

Overview

QlikView Provides Business Discovery for PT. Kapal Api Global’s Big Data

Operational Impact

Quantitative Benefit