LATAM Inventory Health Dashboard finally stops breaking
Built a Power BI dashboard for the LATAM supply chain team that compares safety stock vs on-hand stock and classifies each material–country pair as green / yellow / red.
What was happening
The workflow failed in small ways: inconsistent columns, missing tabs, mixed currencies, and country-level “creative formatting.”
The dashboard wasn’t wrong because visuals were wrong — it was wrong because inputs were unstable.
The real problem
The dashboard was acting like a data pipeline, but it had no pipeline discipline.
No contracts. No validation. No stable definition of what a row means across countries.
What I changed
Standardized intake and semantics so green/yellow/red means the same thing every time.
Made the model more robust to upstream drift instead of letting Power BI guess.
What I’d do next
Add basic data quality flags and ingestion history.
Add weekly roll-ups: what flipped status and what stays chronically red.
← Back to Notes