Qlik Case Studies Cost savings at KLM Equipment Services made possible with QlikView

Edit This Case Study Record

	Cost savings at KLM Equipment Services made possible with QlikView Qlik

Cost savings at KLM Equipment Services made possible with QlikView

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Transportation
Use Cases	Fleet Management Predictive Maintenance
Services	Data Science Services
Challenge	KLM Equipment Services, a subsidiary of KLM Royal Dutch Airlines, manages a large fleet of motorized and non-motorized vehicles and hoisting equipment. The company aims to save costs for its customers, which include KLM, Menzies, Martinair, and Transavia. The fleet managers at KLM Equipment Services are responsible for the purchase and maintenance of ground support equipment for their customers. Being able to quickly deliver adequate dynamic reports of, for example, repairs, malfunctions, usage statistics, and depreciation, is crucial. However, before the implementation of a Business Intelligence solution, they provided these reports using Excel, which proved to be too limited. There were several issues: from control issues and the complexity of retrieving data from their AS/400 database, to the fact that the reports were extremely labor-intensive, difficult to reproduce and highly error prone. Read More
About Customer	KLM Equipment Services B.V. is an independent subsidiary of KLM Royal Dutch Airlines. The company is extremely knowledgeable in all aspects of ground support equipment (GSE), the vehicles and equipment for handling airplanes on the ground. KLM Equipment Services handles such services as maintenance, repairs, planning, distribution, storage and fleet management (leasing, purchasing and lease-back). They manage approximately 3,000 motorized vehicles, 3,900 non-motorized vehicles and around 6,100 units of hoisting equipment. KLM Equipment Services aims to save costs for its customers, amongst which are KLM, Menzies, Martinair and Transavia. Read More
Solution	KLM Equipment Services implemented QlikView for all of its customers and employees. With QlikView, KLM Equipment Services is now able to easily and quickly create reports and analyzes on a strategic, operational and tactical level. The same number of people now provide more information, with higher data volumes. The required data for the QlikView applications is extracted from the AS/400 using an ODBC connection. The three main applications they have developed have been divided into strategic, operational and tactical levels and have been developed with QlikView 8.5. Their strategic application reports data at a contractual level. The tactical application reports on a Fleet Management level. Their QlikView operational application provides insight into maintenance details, mechanic hours, malfunction reports and used parts. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Transportation

Use Cases

Fleet Management

Predictive Maintenance

Services

Data Science Services

Challenge

KLM Equipment Services, a subsidiary of KLM Royal Dutch Airlines, manages a large fleet of motorized and non-motorized vehicles and hoisting equipment. The company aims to save costs for its customers, which include KLM, Menzies, Martinair, and Transavia. The fleet managers at KLM Equipment Services are responsible for the purchase and maintenance of ground support equipment for their customers. Being able to quickly deliver adequate dynamic reports of, for example, repairs, malfunctions, usage statistics, and depreciation, is crucial. However, before the implementation of a Business Intelligence solution, they provided these reports using Excel, which proved to be too limited. There were several issues: from control issues and the complexity of retrieving data from their AS/400 database, to the fact that the reports were extremely labor-intensive, difficult to reproduce and highly error prone.

About Customer

KLM Equipment Services B.V. is an independent subsidiary of KLM Royal Dutch Airlines. The company is extremely knowledgeable in all aspects of ground support equipment (GSE), the vehicles and equipment for handling airplanes on the ground. KLM Equipment Services handles such services as maintenance, repairs, planning, distribution, storage and fleet management (leasing, purchasing and lease-back). They manage approximately 3,000 motorized vehicles, 3,900 non-motorized vehicles and around 6,100 units of hoisting equipment. KLM Equipment Services aims to save costs for its customers, amongst which are KLM, Menzies, Martinair and Transavia.

Solution

KLM Equipment Services implemented QlikView for all of its customers and employees. With QlikView, KLM Equipment Services is now able to easily and quickly create reports and analyzes on a strategic, operational and tactical level. The same number of people now provide more information, with higher data volumes. The required data for the QlikView applications is extracted from the AS/400 using an ODBC connection. The three main applications they have developed have been divided into strategic, operational and tactical levels and have been developed with QlikView 8.5. Their strategic application reports data at a contractual level. The tactical application reports on a Fleet Management level. Their QlikView operational application provides insight into maintenance details, mechanic hours, malfunction reports and used parts.

Impact #1	QlikView helps to make better investing decisions
Impact #2	QlikView helps to realize operational maintenance cost savings
Impact #3	QlikView helps to achieve higher customer satisfaction percentages

Impact #1

QlikView helps to make better investing decisions

Impact #2

QlikView helps to realize operational maintenance cost savings

Impact #3

QlikView helps to achieve higher customer satisfaction percentages

Benefit #1	KLM Equipment Services has managed to reduce the costs of the KLM fleet by more than 53 %
Benefit #2	The data files in Excel were simply becoming too big. With QlikView, they can now provide more information, more efficiently and directly anticipate irregularities

Benefit #1

KLM Equipment Services has managed to reduce the costs of the KLM fleet by more than 53 %

Benefit #2

The data files in Excel were simply becoming too big. With QlikView, they can now provide more information, more efficiently and directly anticipate irregularities

Download PDF Version

Overview

Cost savings at KLM Equipment Services made possible with QlikView

Operational Impact

Quantitative Benefit