Business Case
Leadership wanted quicker insight and a single source of truth. Here were some of the existing issues
- Data silos Sales, stock, and promo files lived in separate systems—making every report a hunt.
- Long waits Teams queued nightly SaS jobs and still relied on third-party extracts for ad-hoc questions.
- Pricing blind spots No clear view of how discounts pushed or hurt demand and margin.
Our Solution
We built a cloud warehouse and price-elasticity engine in 100 days that consisted of the following components:
- Cloud warehouse Python and Airflow landed 50 billion SaS rows in Snowflake, ready for near-real-time queries.
- Price elasticity modelling Python models test price moves and highlight margin risk before campaigns launch.
- Unified reporting Tableau pulls Hyperion data directly, aligning reports across departments.
- Reusable ingestion framework New data sets plug in fast; no rewrite needed.