Retail Analytics Platform for a Leading Provider of Transport Solutions

Client

Our client is a world-leading provider of transport solutions, including trucks and buses for heavy transport applications combined with an extensive product-related service offering.

Business Challenges

The client wanted to:

• Identify the exact time that the vehicles enter and leave the workshop boundaries (Geofence).
• Verify if the time that the work order was opened matches the time that the vehicle enters and leaves the workshop.
• Increase accuracy on vehicles’ downtime in order to avoid fees issued to the client due to downtime agreements not being met.  

LTM Solution

• Created Snowpipe to process streaming data from vehicles. 
• Used vehicle geolocation and validated the stops inside the workshop. 
• Used Snowflake stream, task, and procedure, to track vehicle movements.  

Business Benefits

• 200K stops processed daily for Brazil
• Zero defects or error