Build a business-event fact with auditable duplicate handling
Transaction feeds overlap, and source deliveries may be counted as separate business events.
- Transformation
Larger outcome
9 RecipesLogistics and fleet analytics
Logistics and fleet analytics Recipes, including reusable modelling patterns with relevant operational triggers and domain-specific fleet and shift outcomes.
Build a metric with explicit eligibility and reconcilable rollups
A new percentage, rate or average needs a defensible eligible population and missing-value policy.
- Transformation
Build auditable event-to-resource attribution
Revenue or productivity must be reported by employee, asset or team, but responsibility for each event is unclear.
- Transformation
Add dimension history with verified historical fact classification
Customer, asset or vendor attributes change, but past events need a defensible historical classification.
- Transformation
Build state durations by entity, location and reporting period
Waiting, idle, available or busy time must be measured by site or zone and hour from operational event histories.
- Transformation
Build fleet utilisation against explicit asset availability
A fleet dashboard labels observed vehicle occupancy as utilisation without an authoritative available-time denominator.
- Transformation
- Supply chain and operations
Build shift revenue, cost and margin with reconciled rollups
A fleet dashboard reports revenue per shift but cannot establish whether a shift covers its applicable costs.
- Transformation
- Supply chain and operations
Build historical event amounts from effective-dated business rules
Historical fees or surcharges change when a current rate is applied to past events.
- Transformation
Build lane-day on-time transport performance with open trips and exceptions shown as approved
A TMS dashboard reports on-time performance by lane, but nobody can inspect how it is calculated or reproduce its figure.
- Transformation
- Supply chain and operations