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. New filter boxes have been added for "Consignee" and "Shipper".

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_Home1d

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_Changes1d

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. New filter boxes have been added for "Consignee" and "Shipper".

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_Details1d

Notes for Terminal Time and Intermodal Time

The Display By filter will stack the bar chart based on 3 values:

  • (Default) Port of Loading (for Export screens) or Port of Discharge (for Import screens)
  • Carrier
  • None

On a slice of a stacked bar chart, the dashboard displays that segment only and a slice of a sorted stacked bar chart. For example, if the user has selected to stack bars (Display By filter) by Port of Discharge, then clicking on the USLAX segment of the 21+ bar on the Intermodal Time (Import) screen will return a table of containers (transport equipment) that have spent 21 or more days dwelling at the Port of Los Angeles (USLAX).

  • 20' High Cube and 40' High Cube have been added as container types:

    • 25G0, 26G0 = 20' High Cube
    • 45G0, 45G1 = 40' High Cube
    • The other screens use the ISO codes.
  • A new Pop Up Menu has been added for Fees and FreeDays on each container category, to be divided based on this category: 20' Dry, 20' Reefer, 20' Special, 40' Dry, 40' Reefer, 40' Special

  • Billable Amount / Billable Days columns have been added

  • New filter boxes have been added for "Consignee" and "Shipper".

Terminal Time (Import)

The Terminal Time (Import) tab by default opens in the Historical Terminal Time view and calculates the Terminal Time (Demmurage) at the POD (Port of Discharge) for containers that match Already Gateout and would match the "Yes" selection in each filter, shown in the first image. There is a toggle button at the bottom of the dashboard to switch between the historical and current views. The second image shows the Current Terminal Time view to return containers that have not Already Gateout and would match the "No" selection in each filter. Adjusting the At Terminal Days Calculation 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+
  • Date/Time slider has containers that have Discharged from Vessel during the selected time range.

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_Import_Historical1e Analytics_Dashboards_Terminal_Time_Import_Current1e

Intermodal Time (Import)

The Intermodal Time (Import) tab by default opens in the Historical Terminal Time view and calculates the Intermodal Time (Detention) at the POD (Port of Discharge) for containers that match Already Gate In and would match the "Yes" selection in each filter, shown in the first image. There is a toggle button at the bottom of the dashboard to switch between the historical and current views. The second image shows the Current Intermodal Time view to return containers that have not Already Gate In and would match the "No" selection in each filter. Adjusting the Outside Terminal Days Calculation 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+
  • Date/Time slider has containers that have Gated Out or Left the Terminal during the selected time range.

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_Import_Historical1e Analytics_Dashboards_Intermodal_Time_Import_Current1e

Terminal Time (Export)

The Terminal Time (Export) tab by default opens in the Historical Terminal Time view and calculates the Terminal Time (Demmurage) at the POL (Port of Loading) for containers that match Loaded on Vessel and would match the “Yes” selection in each filter, shown in the first image. There is a toggle button at the bottom of the dashboard to switch between the historical and current views. The second image shows the Current Terminal Time view to return containers that have not Loaded on Vessel and would match the “No” selection in each filter. Adjusting the At Terminal Days Calculation 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+
  • Date/Time slider has containers that have Gated In or Arrived at the Terminal during the selected time range.

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_Export_Historical1e Analytics_Dashboards_Terminal_Time_Export_Current1e

Intermodal Time (Export)

The Intermodal Time (Export) tab by default opens in the Historical Terminal Time view and calculates the Intermodal Time (Detention) at the POL (Port of Loading) for for containers that match Gated In and would match the "Yes" selection in each filter, shown in the first image. There is a toggle button at the bottom of the dashboard to switch between the historical and current views. The second image shows the Current Intermodal Time view to return containers that have not Gated In and would match the "No" selection in each filter. Adjusting the Outside Terminal Days Calculation 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+
  • Date/Time slider has containers that have Gated Out Empty during the selected time range.

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_Export_Historical1e Analytics_Dashboards_Intermodal_Time_Export_Current1e

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_Layover1d

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. New filter boxes have been added for "Consignee" and "Shipper".

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_Transit1d