
03 — Dashboard & Process
OTIF — 76% → 96% via Power BI Tracker + Warehouse Redesign
Process Engineer · Warehouse & Logistics · Jan 2022 — 9 months
Joined warehousing as Process Engineer with OTIF dismal at 76%. Built a Power BI dashboard from grassroots time data, then used the insights to realign warehouse locations, clear defunct inventory, and revamp truck calling — reaching 96% OTIF in 9 months.
76% → 96%
OTIF achieved
+20 pts
OTIF improvement
9 months
End-to-end turnaround
−15%
Defunct inventory
The brief
When I joined the warehouse department in January 2022, OTIF was sitting at 76%. Weekly meetings were held religiously, but with no concrete outcome — everyone debated symptoms, no one had data. We had records of every shipment that went out, but zero tracking of the intermediate steps in between. The real bottlenecks were invisible. I decided to flip the approach: stop arguing from the top, get down to the grassroots of shipping and warehousing, and build the answer upwards from the actual time data.
The approach
- 01Started capturing time stamps for every intermediate step — SR to BOL, BOL to second weight, second weight to gate out, tarping time, allocation to invoice
- 02Built a Power BI dashboard around the captured data so the team could finally see which step was bleeding the most time, week over week
- 03Used the dashboard to answer the questions that were previously guesswork: which step is slowest? Is a specific SKU hard to fish out? Are trucks arriving on time? Where are shipment decisions getting stuck?
- 04Realigned warehouse locations into smaller sections — drastically reduced time to withdraw packs from the back of each location
- 05Ran a focused cleanup of defunct inventory — physically removed from the floor and written off from the ERP, restoring inventory accuracy
- 06Revamped truck calling from the logistics side and built proper cushions for the unusual / far-flung destinations
- 07Drove the implementation hard for 6 months — hit 90% OTIF — and kept pushing for the next 3 months to reach 96%
Got a plant problem like this one?