Skip to content

Analytics Dashboards

Copyright IBM Corporation and GTD Solution Inc. 2020, 2021

Overview

Sometimes a simple status report is not enough. At times we need more information and more sophisticated ways of analyzing what is happening in our supply chain in order to optimize an outcome or survive a shutdown or stockout. TradeLens connects you to a world of granular shipping data that is relevant to your ecosystem. With TradeLens Dashboards you can leverage pre-built reports and analytics to help you make sense of all that information, transform data into insights, and improve your shipping operations.

Analytics Dashboards in TradeLens will offer the following benefits:

  • Global snapshot: Thumbnail snapshot of your global in-flight cargo, summarized in a variety of ways such as terminal or country of loading and discharge, cargo type, carrier, arrival time, and others. Drill down to individual consignments.
  • Identify exceptions: See potential exceptions that may need to be acted on, including ETA updates, extended dwell times, and transhipment risk.
  • Flexible deployment: Access Dashboards directly from the web, or use our template in your own BI tool so you can run the Dashboard from your desktop.

Note: The Analytics Dashboards feature is only available for TradeLens Visibility and TradeLens Collaboration customers. The dashboards are not included with TradeLens Essentials. If you are interested in upgrading to TradeLens Visibility or TradeLens Collaboration, contact us at https://tradelens.com/connect to speak to one of our sellers.

If you have TradeLens Visibility or TradeLens Collaboration and your organization has been entitled for The Analytics Dashboard feature by the Onboarding team, you will see an Analytics Dashboards link on the left menu of the TradeLens UI. Click on the link to open your dashboards.

Analytics_Dashboards_UI_Link1

Details

The Analytics Dashboard contains several selectable tabs across the top that provide detailed insight into trade objects of interest to your organization. We will discuss several of these tabs in more detail along with a sample screen image. To view a larger screen image, right-click on the image and open in a new browser tab or window. The examples below are for a beneficial cargo owner (BCO).

Home

The Home tab displays a high level view of in-transit shipments, latest location of containers, ETA changes at final destination, layover days at Transshipment location, and overall TradeLens contributing network members.

Analytics_Dashboards_Home1b

ETA Changes

The ETA Changes tab displays any discrepancy between the initial Transport Plan (TP) and updates to the Transport Plan. This calls attention to early or delayed arrivals at final destination. This tab calculates the difference between the Latest Arrival at POD (Port of Discharge) date and the TP that was submitted right before the first Actual event at POL (Port of Loading); it also shows the estimated Transit Time. Bookings are excluded once they arrive to POD.

Column Heading Notes:

  • Bill of Lading: The Bill of Lading Number for this Booking
  • Booking Number
  • Split (BOL) / Combined (Booking): Show the BOL or Booking number of Split/Combined cases.
  • Equipment Number: Container Number
  • POL: Port of Loading
  • Latest Departure from POL: Latest Departure from the POL between Planned Vessel Departure vs Estimated Vessel Departure
  • Departing Vessel at Port of Loading: Name of the Departing Vessel
  • POD: Port of Discharge
  • Latest Arrival at POD: Latest Arrival at the POD between Planned Vessel Arrival and Estimated Vessel Arrival
  • Planned Arrival at POD: Planned Arrival Time submitted right before the first Actual Event at POL (Export Phase)
  • Arriving Vessel at Port of Discharge: Name of the Arriving Vessel
  • Transit Time (POL to POD): Latest Departure Date from POL and Latest Arrival at POD
  • Schedule Difference: Difference in hours between Latest Arrival at POD and Planned Arrival at POD

Analytics_Dashboards_ETA_Changes1b

Booking Details

The Booking Details tab displays a summary of Transport Pan information and commodity description, including additional details for latest location based on most recent Actual event. This tab shows the occurrence time and location of the most recent actual event per container, over the Booking; it also shows the Latest Arrival (Planned vs Estimated) at POD (Port of Discharge) data. Bookings that do not have any Actual events yet, or do not have any assigned containers are not included in this report.

Column Heading Notes:

  • Containers over Booking: Total number of containers assigned to the Booking Number
  • Origin: Origin Location of Booking Number
  • Destination: Destination Location of Booking Number
  • Commodity Description: Description of the type of Commodity handled within Booking
  • Most Recent Location: Most Recent Port of Call over Container
  • Event Type: Type of Actual Event undergone by Container
  • Container Count: Number of Containers undergoing specified Actual Event

Analytics_Dashboards_Booking_Details1b

Terminal Time (Import)

The Terminal Time (Import) tab displays the dwell time by terminal working days and billable days by container at the Port of Discharge by adjusting Free Days and Demurrage fees accordingly. This tab calculates the Terminal Time (Demmurage) at the POD for a given Container.

Column Heading Notes:

  • Actual Discharge From Vessel: Occurrence time of the Discharge from Vessel at POD
  • Actual Gate Out (Full): Occurrence time of the Gate Out (Full) event at the POD
  • At Terminal (Calendar Days) or (Week Days): Difference between the Discharge and Gate Out Full at POD. Days are calculated based on At Terminal Day Calculation Parameter (5 Working Days or 7 Week Days)

Calculation Notes:

  • At Terminal: If Actual Gate Out (Full) is not available then difference is based on Today (Server Time based in Dallas USA) vs Actual Discharge Occurrence Time. Both events have to happen at the same Location / UN/LOCODE. Weekends are considered Saturday and Sunday.

Analytics_Dashboards_Terminal_Time_Import1b

Intermodal Time (Import)

The Intermodal Time (Import) tab displays the container usage by working days outside terminal and billable days by container at the Port of Discharge by adjusting Free Days and Detention fees accordingly. This tab calculates the Intermodal Time (Detention) at the POD for a given Container.

Column Heading Notes:

  • Actual Gate Out (Full): Occurrence time of the Gate Out (Full) event at the POD
  • Actual Gate In (Empty): Occurrence time of the Gate In (Empty) event at the POD
  • Outside Terminal (Calendar Days) or (Week Days): Difference between the Gate Out (Full) and Gate In (Empty) at POD. Days are calculated based on Outside Terminal Day Calculation Parameter (5 Working Days or 7 Week Days)

Calculation Notes:

  • Outside Terminal: If Actual Gate In (Empty) is not available then difference is based on Today (Server Time based in Dallas USA) vs Actual Gate Out (Full) Occurrence Time. Both events do not have to happen at the same Location / UN/LOCODE. Weekends are considered Saturday and Sunday.

Analytics_Dashboards_Intermodal_Time_Import1b

Terminal Time (Export)

The Terminal Time (Export) tab displays the dwell time by terminal working days and billable days by container at the Port of Loading by adjusting Free Days and Demurrage fees accordingly. This tab calculates the Terminal Time (Demmurage) at the POL for a given Container.

Column Heading Notes:

  • Actual Gate In (Full): Occurrence time of the Gate In (Full) event at the POL
  • Actual Loaded on Vessel: Occurrence time of the Actual Loaded on Vessel event at the POL
  • At Terminal (Calendar Days) or (Week Days): Difference between the Gate In (Full) and Loaded on Vessel at POL. Days are calculated based on At Terminal Day Calculation Parameter (5 Working Days or 7 Week Days)

Calculation Notes:

  • At Terminal: If Actual Loaded on Vessel is not available then difference is based on Today (Server Time based in Dallas USA) vs Actual Gate In (Full) Occurrence Time. Both events have to happen at the same Location / UN/LOCODE. Weekends are considered Saturday and Sunday.

Analytics_Dashboards_Terminal_Time_Export1b

Intermodal Time (Export)

The Intermodal Time (Export) tab displays the container usage by working days outside terminal and billable days by container at the Port of Loading by adjusting Free Days and Detention fees accordingly. This tab calculates the Intermodal Time (Detention) at the POL for a given Container.

Column Heading Notes:

  • Actual Gate Out (Empty): Occurrence time of the Gate Out (Empty) event at the POL
  • Actual Gate In (Full): Occurrence time of the Actual Gate In (Full) event at the POL
  • Outside Terminal (Calendar Days) or (Week Days): Difference between the Gate Out (Empty) and Gate In (Full) at POL. Days are calculated based on Outside Terminal Day Calculation Parameter (5 Working Days or 7 Week Days)

Calculation Notes:

  • Outside Terminal: If Actual Gate In (Full) is not available then difference is based on Today (Server Time based in Dallas USA) vs Actual Gate Out (Empty) Occurrence Time. Both events do not have to happen at the same Location / UN/LOCODE. Weekends are considered Saturday and Sunday.

Analytics_Dashboards_Intermodal_Time_Export1b

Transshipment Layover

The Transshipment Layover tab displays details of transshipment layover (in days) based on Transport Plan. This tab calculates the Transshipment Layover time per Booking for each Trasnshipment Port.

Column Heading Notes:

  • Originator Name: Initial Start Consignment Tracking Publisher
  • Transshipment Location: Location of Planned Transshipment Ports
  • Expected Arrival: Latest Arrival to Specified Transshipment Port (Planned Vessel Arrival vs Estimated Vessel Arrival)
  • Expected Arrival Vehicle: Name of Expected Arrival Vessel
  • Actual Arrival: Occurrence Time of Actual Arrival if Happened
  • Actual Arrival Vehicle: Name of Arrived Vessel if Arrived
  • Expected Departure: Latest Departure from Specified Transshipment Port (Planned Vessel Departure vs Estimated Vessel Departure)
  • Expected Departure Vehicle: Name of Expected Departure Vessel
  • Actual Departure: Occurrence Time of Actual Departure if Happened
  • Actual Arrival Vehicle: Name of Departed Vessel if Departed
  • Transshipment Layover: Difference between Latest Arrival and Latest Departure

Calculation Notes:

  • Transshipment Layover: Ideally Actual Departure Date - Actual Arrival Date. If No Actual Departure then Expected Departure Date - Actual Arrival Date. If No Actual Arrival then Expected Departure Date - Expected Arrival Date.

Analytics_Dashboards_Transshipment_Layover1b

On the Water

The On the Water tab displays details of in-transit consignments (containers that have left their origin but have not arrived to their destination). This tab tracks the Actual Arrivals and Departures for a Booking Number and excludes consignments once they have Arrived to Destination.

Analytics_Dashboards_On_The_Water1b