Qlik Case Studies TNT consolidates monthly management reports using QlikView

Edit This Case Study Record

	TNT consolidates monthly management reports using QlikView Qlik

TNT consolidates monthly management reports using QlikView

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Transportation
Applicable Functions	Human Resources
Use Cases	Real-Time Location System (RTLS) Predictive Quality Analytics
Services	Data Science Services System Integration
Challenge	TNT's Corporate Audit Services Department was facing a challenge with their monthly reporting process. The department, which is responsible for internal audits worldwide, had three senior managers compiling reports for the head of the department each month. This process was time-consuming and lacked a consistent structure and uniformity, as each manager had their own method of compiling the reports. This complicated the data-merging process and the compilation of one departmental report. Additionally, all the data was manually inputted, which took a lot of time. The department was looking for a solution that would simplify the consolidation of the decentralized data, accelerate the auditing of data reliability, and present their custom-defined KPIs in a flexible and transparent manner. Read More
About Customer	TNT N.V. is a global supplier of postal and express services to businesses and consumers worldwide. The company is headquartered in Hoofddorp, the Netherlands, and operates in over 200 countries. With around 159,000 employees globally and 68,000 employees in the Netherlands alone, TNT is the largest private employer in the Netherlands, second only to the Dutch government. In 2006, the company generated sales of €10.1 billion and recorded an operating result of €1.276 billion. The Corporate Audit Services Department of TNT, which is responsible for internal audits worldwide, is spread over two locations; 40 work at the head office in Hoofddorp, and five work in Singapore. Read More
Solution	After considering both internal and external solutions, TNT opted for QlikView in the spring of 2006. The decision was based on QlikView's high flexibility, which allowed TNT to make changes to their KPIs relatively easily, and its ability to link the application to various sources. The implementation process began in the summer of 2006. The translation of the KPIs to the data in the source systems proved more time-consuming than anticipated, taking more than six months. However, making the technical link to the data and from the data to QlikView was fairly simple, taking only one to two months. After correcting some flaws that showed up as a result of QlikView’s transparency, the system went live in May 2007. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Transportation

Applicable Functions

Human Resources

Use Cases

Real-Time Location System (RTLS)

Predictive Quality Analytics

Services

Data Science Services

System Integration

Challenge

TNT's Corporate Audit Services Department was facing a challenge with their monthly reporting process. The department, which is responsible for internal audits worldwide, had three senior managers compiling reports for the head of the department each month. This process was time-consuming and lacked a consistent structure and uniformity, as each manager had their own method of compiling the reports. This complicated the data-merging process and the compilation of one departmental report. Additionally, all the data was manually inputted, which took a lot of time. The department was looking for a solution that would simplify the consolidation of the decentralized data, accelerate the auditing of data reliability, and present their custom-defined KPIs in a flexible and transparent manner.

About Customer

TNT N.V. is a global supplier of postal and express services to businesses and consumers worldwide. The company is headquartered in Hoofddorp, the Netherlands, and operates in over 200 countries. With around 159,000 employees globally and 68,000 employees in the Netherlands alone, TNT is the largest private employer in the Netherlands, second only to the Dutch government. In 2006, the company generated sales of €10.1 billion and recorded an operating result of €1.276 billion. The Corporate Audit Services Department of TNT, which is responsible for internal audits worldwide, is spread over two locations; 40 work at the head office in Hoofddorp, and five work in Singapore.

Solution

After considering both internal and external solutions, TNT opted for QlikView in the spring of 2006. The decision was based on QlikView's high flexibility, which allowed TNT to make changes to their KPIs relatively easily, and its ability to link the application to various sources. The implementation process began in the summer of 2006. The translation of the KPIs to the data in the source systems proved more time-consuming than anticipated, taking more than six months. However, making the technical link to the data and from the data to QlikView was fairly simple, taking only one to two months. After correcting some flaws that showed up as a result of QlikView’s transparency, the system went live in May 2007.

Impact #1	QlikView has helped TNT to reduce the time spent on monthly reports to approximately an hour and a half per person, a gain of 6.5 hours per person, saving a total of 32.5 hours.
Impact #2	The system has also reduced the time spent on meetings to discuss the reports, saving an additional four hours.
Impact #3	The system provides real-time access to data, which is expected to be utilized more in the future.

Impact #1

QlikView has helped TNT to reduce the time spent on monthly reports to approximately an hour and a half per person, a gain of 6.5 hours per person, saving a total of 32.5 hours.

Impact #2

The system has also reduced the time spent on meetings to discuss the reports, saving an additional four hours.

Impact #3

The system provides real-time access to data, which is expected to be utilized more in the future.

Benefit #1	Time savings of almost a full week per month
Benefit #2	Reduced time spent on monthly reports from a day to approximately an hour and a half per person
Benefit #3	Reduced time spent on meetings to discuss reports from six hours to two hours

Benefit #1

Time savings of almost a full week per month

Benefit #2

Reduced time spent on monthly reports from a day to approximately an hour and a half per person

Benefit #3

Reduced time spent on meetings to discuss reports from six hours to two hours

Download PDF Version

Overview

TNT consolidates monthly management reports using QlikView

Operational Impact

Quantitative Benefit