Skip to content

Analytics Dashboards for BCO

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 set of widgets to summarize and visualize some of the data presented in the dashboards.

Widgets:

  • In Transit: High Level view of In Transit Shipments. Drills into In Transit Dashboard.
  • Most Recent Location: Latest Container Location. Drills into Booking Details Dashboard and allows you to click on a country and filter the Booking Details. It also supports the country-level click.
  • ETA Changes: ETA Difference at the Port of Discharge. Drills into ETA Changes Dashboard.
  • Transshipment Layover: Layover Days at Transshipment Location. Drills into Transshipment Layover Dashboard.
  • Network Members: Overall TradeLens contributing Network Members.

The individual widgets on the Home tab are expandable. The widgets click through to the corresponding detail report and expand/contract the individual widgets as well.

Analytics_Dashboards_Home1c

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 Consignment
  • Booking Number: Carrier 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
  • GMT Offset: The date format determined by the end user's browser locale
  • 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_Changes1c

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:

  • Bill of Lading: The Bill of Lading Number for this Consignment
  • GMT Offset: The date format determined by the end user's browser locale
  • Containers over Booking: Total number of containers requested in the Booking
  • Origin: Origin Location of the Consignment
  • Destination: Destination Location of the Consignment
  • Commodity Description: Description of the Commodity type provided in the Booking
  • Most Recent Location: Most Recent Port of Call for a Container
  • Event Type: Type of Actual Event
  • Container Count: Number of Containers Event applies to

Analytics_Dashboards_Booking_Details1c

Terminal Time (Import)

The Terminal Time (Import) tab calculates the Terminal Time (Demmurage) at the POD (Port of Discharge) for a given Container. Adjusting the At Terminal Days Calulation will either Include or Exclude weekends.

Column Heading Notes:

  • Bill of Lading: The Bill of Lading Number for this Consignment
  • GMT Offset: The date format determined by the end user's browser locale
  • 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).
  • In the bar chart, group by the following: 1-3, 4-5, 6-10, 11-15, 16-20, 21+

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_Import1c

Intermodal Time (Import)

The Intermodal Time (Import) tab calculates the Intermodal Time (Detention) at the POD (Port of Discharge) for a given Container. Adjusting the Outside Terminal Days Calulation will either Include or Exclude weekends.

Column Heading Notes:

  • Bill of Lading: The Bill of Lading Number for this Consignment
  • GMT Offset: The date format determined by the end user's browser locale
  • 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).
  • In the bar chart, group by the following: 1-3, 4-5, 6-10, 11-15, 16-20, 21+

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_Import1c

Terminal Time (Export)

The Terminal Time (Export) tab calculates the Terminal Time (Demmurage) at the POL (Port of Loading) for a given Container. Adjusting the At Terminal Days Calulation will either Include or Exclude weekends.

Column Heading Notes:

  • Bill of Lading: The Bill of Lading Number for this Consignment
  • GMT Offset: The date format determined by the end user's browser locale
  • 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).
  • In the bar chart, group by the following: 1-3, 4-5, 6-10, 11-15, 16-20, 21+

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_Export1c

Intermodal Time (Export)

The Intermodal Time (Export) tab calculates the Intermodal Time (Detention) at the POL (Port of Loading) for a given Container. Adjusting the Outside Terminal Days Calulation will either Include or Exclude weekends.

Column Heading Notes:

  • Bill of Lading: The Bill of Lading Number for this Consignment
  • GMT Offset: The date format determined by the end user's browser locale
  • 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).
  • In the bar chart, group by the following: 1-3, 4-5, 6-10, 11-15, 16-20, 21+

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_Export1c

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:

  • Bill of Lading: The Bill of Lading Number for this Consignment
  • GMT Offset: The date format determined by the end user's browser locale
  • 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_Layover1c

In Transit

The In Transit tab displays details of in-transit Consignments (Containers that have left their origin but have not arrived at their destination). This tab tracks the Actual Arrivals and Departures for a Booking Number and excludes Consignments once they have Arrived at their Destination.

Column Heading Notes:

  • Origin: Origin Location of the Consignment
  • Destination: Destination Location of the Consignment
  • Bill of Lading: Bill of Lading Number
  • Booking Number: Carrier Booking Number
  • Containers over Booking: Total number of containers requested in the Booking
  • Event Type: Type of Actual Event, for example Vessel Arrival or Vessel Departure

Analytics_Dashboards_In_Transit1c