The Sustainability Dashforce

We provide visibility and carbon neutrality as a dashboard to shippers and freight forwarders by leveraging the IATA One Record standard.

Comment

The problem

An increasing amount of end customers ask for climate neutral products. At the same time regulations start to take effect, that require shippers and forwarders to provide transparency on emissions and ultimately reduce them to zero.

Shippers that want to compete successfully need to offer solutions for carbon neutrality. Therefore they demand CO2-transparency and carbon neutral shipment options from their forwarders.

Current solutions, where each carrier provides their own custom solution are too complex and scattered to be effectively handled in the daily work of a forwarder.

Solution

We tackle the problem by proposing the IATA One Record Sustainability Dashboard. Forwarders, that commit to the new standard can provide an integrated out-of-the-box solution to their shippers. The dashboards plugs in to the One Record server as well as a compensation API (SQUAKE). Shippers can use the dashboard to view the emissions of each piece and optionally compensate for these using different projects.

How we built it

The dashboard is built using Microsoft Power BI. It connects to our backend server, which we built using Node.js and NestJS. It is deployed as a web app in the Microsoft Azure Cloud and is accessible to the frontend via a web link.

The backend collects the individual data-objects from our One Record Server and transforms them into a flat json-structure for the frontend. Because we need some more data for our Sustainability Dashboard, which is not yet available in the current One Record data-model, we have extended it with our own addon. We defined new logistics object types and data properties, so that our solution is easy to use and easy to implement as an additional feature.

To enrich our OneRecord data sets with CO2 data we use the Squake API in the backend. With Squake you can calculate CO2 emissions. In addition, we can calculate the amount of CO2 for used electricity and packaging material. The retrieved data is then stored in the OneRecord server via our backend. Furthermore, the Squake API offers different projects to compensate. The projects, with a description and compensation costs are also fetched via the API and displayed to the user on the PowerBI dashboard. A certificate is issued after the compensation process is completed.

Built With

  • nestjs
  • node.js
  • onerecord
  • powerbi
  • squake
Share this project:

Updates