Pinpoint data model
Release notes for Controlant Analytics - Pinpoint data model.
Solution | Controlant Analytics - Pinpoint data model |
Version | 2.2.0 |
Type of release | Major |
Live release date | 1 September 2025 |
For more information, see Pinpoint data model.
New features
Moved all code to new repository and tables to the new data_product catalog
This move caused recalculation from scratch for all tables, causing many location groups to get a new name
Solution | Controlant Analytics - Pinpoint data model |
Version | 2.1.0 |
Type of release | Major |
Live release date | 13 March 2025 |
For more information, see Pinpoint data model.
New features
Fix to properly capture locations happening at excursions in rare cases where they were missing
Excluding split shipments entirely from the PowerBI Data model
Excluding notification boundaries from the temperature range logic
Solution | Controlant Analytics - Pinpoint data model |
Version | 2.0 |
Type of release | Major |
Live release date | 1 February 2025 |
For more information, see Pinpoint data model.
New features
Improvements to arrival/departure times at points of interest by using additional data from devices.
Allowed shipments to be at multiple locations at once. This will help to account for overlapping points of interest.
Tables now accessible by customers
Customers now have access to the tables of the Pinpoint data model via delta sharing.
Solution | Controlant Analytics - Pinpoint data model |
Version | 1.0 |
Type of release | Major |
Live release date | 26 September 2024 |
Customers now have the option to get access to the data models underlying the of the Pinpoint Excursions and Pinpoint Bottlenecks products, via delta sharing.
This release is the first full release of tables defined as Controlant Pinpoint data model. Pinpoint data model consists of nine data tables that include data related to ongoing and finished shipments updated every 24 hours. Tables are shared using the Delta Sharing Protocol.
For more information, see Pinpoint data model.
New features
Geolocation of excursions table
The shipment_logger_excursion_geolocations table collects information on excursions. It contains data on which device measured the excursion, where it happened (in geo co-ordinates), in which country it took place and when. This table is on device level.
Points of interest or legs table
The shipments_pois_legs table consolidates all POIs with arrival and departure details and builds the shipment legs, representing the source of truth for tracking shipments between locations
Points of interest locations table
The poi_locations table contains details of all POIs (points-of-interest) in the supply chain network; airports, harbors or customer locations. Location groups are constructed from aggregating similar customer locations that share the same geographical location, and logistical locations such as airports or harbors from the Open Street Map project.
Location groups table
The location_groups table contains information about what customer locations belong to which location group.