Store demand forecasting in BigQuery and Vertex AI
- Situation
- A retailer plans replenishment from spreadsheets built on weekly exports from its ERP and point-of-sale systems.
- Approach
- We replicate sales, inventory and promotions data into BigQuery, train store-and-item forecasts in Vertex AI, and write recommended order quantities back to the ERP for planners to approve.
- Outcome
- Planners work from one forecast tied to current sales, and the spreadsheet rebuild each week stops.
