PADB to Snowflake Migration

About the Client

Ask is leading Q&A brand responsible for answering billions of user questions over the last 20 years. Consumers can access client browser as a browser plugin, which delivers fresh and relevant content on desktop. Here client has strong web search engine which retrieves the information from where it is originated.

Client Speak

Jade Consulting has been a great help to IAC Publishing Labs as we migrated our data warehouse to Snowflake in the cloud. They continue to support us operationally. We trust that anything we throw at them can be done by the morning, effectively halving our turnaround time to business.

Business Challenges

  • EDW System availability: Most of the time EDW environment (PADB database) is down due to Infrastructure related failures. This was impacting daily data refresh load thus preventing business users to view their reports and dashboards for key decisions.
  • Performance Issue: Since the response time from the system is poor, business users are spending more time in running their reports / dashboards thus impacting productivity of the employees
  • Return on Investment: Return on investment (ROI) was also poor since overall EDW support costs were higher. Also support from the product vendor was also not up to the desired level.

Business Requirements

  • Build scalable and flexible Enterprise Data Warehouse ( EDW)
  • Stable environment to enable enterprise reporting platform
  • Enablement of Portfolio reports