The challenge
Store, online and supply-chain teams each kept their own spreadsheets. Leaders waited days for reports and often made decisions on conflicting numbers.
Our solution
- Designed a Snowflake data platform with automated ELT pipelines from 12 source systems.
- Modeled shared business metrics with clear definitions and data quality checks.
- Delivered executive and store-level Power BI dashboards.
- Built a machine learning demand forecast to guide replenishment.
The results
- Daily reporting instead of weekly
- 18% reduction in stock-outs
- 300+ business users on self-service BI