Retail · 2024
One live dashboard for a 40-store retail chain
Data pipelines from POS, inventory and ad platforms into BigQuery with live BI dashboards for leadership and store managers.
3 days → live
Reporting time
Vertex Retail
- Reporting time
- 3 days → live
- Stock-outs
- −22%
- Dashboard adoption
- 94%
The challenge
Weekly reports took two analysts three days to compile from spreadsheets, and numbers rarely matched between teams.
The system we built
We modelled sales, inventory and marketing data with dbt in BigQuery, automated ingestion, and delivered role-based dashboards with anomaly alerts.