- From
- Luc BergeronDirector of Operations
- To
- Analytics
- Subject
- The Monday on-time spreadsheet
Every Monday someone exports shipments from the transport system and rebuilds our on-time numbers by hand, and every Monday the number is a little different. Now that the export lands in Snowflake every night, I'd like the report rebuilt there so it is the same for everyone.
Watch out: the system writes a new row every time a shipment changes (booked, in transit, delivered or cancelled), so the raw table has two to four rows per shipment. A shipment delivered on its promised day counts as on time.
Done looks like: one current row per shipment, a tested model of deliveries, a view of on-time delivery by lane, and a short readout on which lanes need attention.