DD19 Inventory & Stock Health: how it was built
What do we reorder today, where does it fit, and what stock should we clear? Rebuild this dashboard step by step in the Data Canvas.
DD19 · Inventory & Stock Health
Code in this build: 4 widgets written in SQL, and 1 filter, chart or pivot setting written as code.
The question: What do we reorder today, where does it fit, and what stock should we clear?
Who asks, and when: The purchasing manager, daily.
The decision: What to reorder today, where it fits, and what stock to clear.
What the dashboard shows: 14 SKUs are below their reorder level, 4 of them in Rotterdam, and Rotterdam is the warehouse with no room left: 94% of capacity against 71% in Frankfurt and 52% in Sao Paulo. 62,110.83 sits in 9 slow movers that have not sold in 90 days, none of them worth more than 6,979.31 on its own, and every one of them is in a different building - so the money to free is spread thin while the space problem is in one place.
Follow the pictures below, in order, and you end up with the same dashboard. Every step is one thing you do in the Data Canvas, on the demo data that installs with DataPallas.