Qlik > Case Studies > TNT consolidates monthly management reports using QlikView

TNT consolidates monthly management reports using QlikView

Qlik Logo
Customer Company Size
Large Corporate
Region
  • Europe
Country
  • Netherlands
Product
  • QlikView
Tech Stack
  • Microsoft Office/ Windows Server
  • Excel
  • Hyperion
  • Computron
  • Timewatch
  • SAP
Implementation Scale
  • Departmental Deployment
Impact Metrics
  • Productivity Improvements
  • Cost Savings
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
About The 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.
The 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.
The 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.
Operational Impact
  • 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.
  • The system has also reduced the time spent on meetings to discuss the reports, saving an additional four hours.
  • The system provides real-time access to data, which is expected to be utilized more in the future.
  • The information produced by QlikView is used mostly for managing the department, providing more insight into data and better detection of deviations from the planning, improving the efficiency of the audit process.
Quantitative Benefit
  • Time savings of almost a full week per month
  • Reduced time spent on monthly reports from a day to approximately an hour and a half per person
  • Reduced time spent on meetings to discuss reports from six hours to two hours

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.