The leadership team of a Fortune 50 DIY retailer tasked their IT department with moving data from an on-premise enterprise data warehouse to a cloud enterprise data warehouse. The reason behind this decision was the retailer’s desire for an economical rollout of broad analytics use cases, with the focus on using more analytics at a scalable price. The retailer also wished to realize the improvement in their BI tools’ performance that results from querying against a more modern data store.
Ultimately, the decision was made to select Google BigQuery. The retailer’s IT department needed to determine how to move their data from Teradata to Google BigQuery without disrupting their business users. Additionally, the retailer had to connect multiple frontend business intelligence tools to BigQuery simultaneously, while maintaining high levels of performance and data governance across each BI tool.
Where AtScale Came In
The retailer’s IT department was able to connect their different BI tools to their on-premise warehouse using AtScale’s Virtual Data Warehouse. When they had moved their data to the cloud, they were able to re-point the AtScale Virtual Data Warehouse from their on-prem data warehouse to their new cloud data warehouse within a single weekend. Not one BI user was impacted when performing their reporting tasks on the following Monday morning. Business analysts were able to run the exact same reports as they had on Friday without realizing that the data store they were querying against had changed.
AtScale’s capacity to help its customers move data to the cloud without business interruption enabled this retailer to save millions of dollars that were being spent on legacy data warehouses. Once data was moved into Google BigQuery, AtScale’s smart aggregates provided further cost savings, as queries did not have to be executed against raw fact tables.
AtScale’s Virtual Data Warehouse also greatly improved the performance of the organization’s various BI tools. Business analysts are now able to receive insights in seconds, whereas prior to using AtScale it could take hours or even days to view the answer to a query. AtScale delivers 17,000 subsecond queries per day to a constituency of 3000 business users, regardless of whether those users are in Excel, Cognos, or Tableau.