← All projects

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

  1. 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
  2. 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
  3. 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?
  4. 04Realigned warehouse locations into smaller sections — drastically reduced time to withdraw packs from the back of each location
  5. 05Ran a focused cleanup of defunct inventory — physically removed from the floor and written off from the ERP, restoring inventory accuracy
  6. 06Revamped truck calling from the logistics side and built proper cushions for the unusual / far-flung destinations
  7. 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?