What the client needed
Stock and sales sat in separate exports, so leadership could not see quickly which products moved and which held stock.
Thousands of products across many brands made it difficult to see which items were moving, which were holding stock and where margins sat.
What we built
- A unified product and sales model
- Dashboards by brand, category and SKU
- Stock ageing and movement views
- Automatic refresh
How we solved it
We cleaned and joined product, stock and sales data, then designed views for purchasing, sales and leadership.
Product, stock and sales data were cleaned and joined, then presented in views designed for purchasing, sales and leadership.
The outcome
The team sees performance across more than 2,000 SKUs in one place and makes purchase decisions with confidence.
Decisions on purchasing and pricing are now made from one clear view of every brand, category and SKU.
