Headerbild_1.jpg

cargoi squareCase Study Cargo iQ

 

 


 

Introduction


Cargo iQ operates as a non-profit membership group supported by International Air Transport Association (IATA) and is composed of about 80 major airlines, freight forwarders, ground-handling agents, trucking companies and IT solution providers globally. IATA Cargo iQ wants to replace its existing benchmark reporting solution by a new platform. The benchmark reporting evaluates the performance of carriers (members of Cargo IQ) along the different transport paths. The technology company Information Builders Switzerland AG was asked to offer a solution for Cargo iQ Smart Data and involved iRIX Software Engineering AG as solution partner to complete this offer.
 

 

Background

 

Cargo iQ Members (see list here) of this interest group agreed on a system of shipment planning and performance monitoring for air cargo based on common business processes and milestones. During the standardization process a master operating plan (mop) was developed which describes the air cargo supply chain with the first, industry-endorsed, standard of the end-to-end process of air transport.


The smart data program forms a three-stage project that is intended to produce a broader scope of measurements, more information on specific milestones, and allow self-service member access to the group’s reporting platform. During Module One of the project, airport-to-airport data collection and benchmarking processing, is underway and due for completion in the spring of 2017. For Module Two iRIX Software Engineering AG is currently implementing the online portal, which Cargo iQ members will be able to use to interrogate Cargo iQ data for customised reports on milestones covering individual routes, timeframes and the performance of their partners.

 

 
Challenges

  • Massive data volumes (2015: 10 mio airport-to-airport measured shipments, 5.5 mio door-to-door measured, smart data project is adding 110 mio lines of performance data annually)
  • Data foundation: performance data is gathered on a file basis with retransmission if incomplete
  • Data quality: application should tackle missing, incomplete and inconsistent data sets as not all data providers are fulfilling set standards yet
  • Existing reporting platform should be decommissioned; self-service analysis should be facilitated for Cargo iQ members

 

 

Approach


A web based portal solution is being implemented to address smart data targets, hosted in an European cloud environment, driven by the highly reliable and flexible Information Builders Technology and realized by its business partner iRIX Software Engineering AG specialised in developing business analytics solutions.


The cooperation between iRIX Software Engineering AG and Information Builders is a natural fit. The customer oriented spirit of both companies as well as the experience in the market gives IATA the best value for success, using proven technology based on vertical experience in the logistics market.


To fulfil all defined smart data project requirements iRIX Software Engineering AG is foreseeing one of the most flexible business analytics applications available in the market. The solution will be provided as a cloud based application to offer an easy to reach data hub for members and non-members to improve quality and process performance. The solution comprises a dedicated custom reception and validation process storing the data in an appropriate store and a highly sophisticated analysis and presentation layer WebFOCUS from Information Builders. This layer is also available with the licensed users as a platform for other reporting and analytics within the IATA organization for other self-service analytics or monthly reporting. A first glimpse on that solution was presented at the World Cargo Symposium 13-16 of March 2017 to IATA members.

 

 

Solution

 

To enhance performance and speed data analysis, Exasol's proven in-memory technology is used. Relevant data is now automatically included in a specially developed data warehouse schema and will only be routed to the Analytics platform after an audit. WebFOCUS components are selected to create a multi-tab dashboard that provides in-depth insight into process performance for defined milestones to each Cargo iQ member.

 

 

 

 

Added value for Cargo iQ

 

As a result the developed cloud-based analytics portal application allows Cargo iQ members to:

 

  • Get detailed insights in their shipment processes and so can derive concrete means to improve milestone performance for both airport-to-airport and door-to-door shipments
  • Facilitate industry benchmark comparisons along the standardized supply chain process chain
  • Further develop the industry standardization of the air cargo supply chain
  • Switch from static reporting to a self-service analysis to shorten information life-cycle and use insights for discussions with related business partners

 

 

  IATAlogo

Links

Cookies make it easier for us to provide you with our services. With the usage of our services you permit us to use cookies.