Download PDF
AtScale > Case Studies > Fortune 50 Retailer Modernizes Analytics with AtScale
AtScale Logo

Fortune 50 Retailer Modernizes Analytics with AtScale

Technology Category
  • Analytics & Modeling - Big Data Analytics
  • Infrastructure as a Service (IaaS) - Cloud Computing
Applicable Industries
  • E-Commerce
  • Retail
Applicable Functions
  • Business Operation
Services
  • Cloud Planning, Design & Implementation Services
  • Data Science Services
The Challenge
A Fortune 50 retailer launched an initiative to modernize their analytics infrastructure with the primary goal of increasing the flow of data-driven insights that could lead to improved margins, optimization of product mix and better inventory management. Their challenge was to enable better analytics at scale while ensuring efficiency and consistency across a broad audience of data consumers. With thousands of users performing analytics using a diverse set of legacy platforms, including SQL Server Analysis Services (SSAS), Teradata, and Hadoop, the existing infrastructure was expensive and could not scale at the rate of their business. To empower their users, the data team needed a scalable semantic layer solution that could serve the needs of internal users as well as suppliers that rely on a shared view of inventory. The solution needed to scale, needed to support security and access control policies, and needed to support the organization’s migration from on-premise legacy data platforms to a cloud data warehouse.
About The Customer
The customer is a Fortune 50 retailer that operates on a large scale. They have thousands of internal and external analytics consumers who rely on their data for various purposes. The retailer has a diverse set of legacy platforms, including SQL Server Analysis Services (SSAS), Teradata, and Hadoop, which were proving to be expensive and unable to scale at the rate of their business. The retailer's primary goal was to modernize their analytics infrastructure to increase the flow of data-driven insights that could lead to improved margins, optimization of product mix, and better inventory management. They needed a solution that could scale, support security and access control policies, and support their migration from on-premise legacy data platforms to a cloud data warehouse.
The Solution
The retailer partnered with AtScale to replace traditional SQL Server Analysis Services (SSAS) OLAP instances. The AtScale semantic layer delivered the analytics performance of SSAS without the complex data engineering and the need to extract and transform data to maintain traditional OLAP “cubes.” This initial implementation was done with on-premise Hadoop data. As the organization transitioned to Google BigQuery, they were able to leverage AtScale’s virtualization-based approach to seamlessly transition analytics with no interruption to the business. Within a single weekend, the data team was able to redirect existing AtScale models to the new cloud data repository, enabling existing reports, dashboards, and applications that were based on AtScale to continue operating with no changes.
Operational Impact
  • In the first stage, this organization leveraged AtScale to transition SSAS-based analyses from Hadoop to Google BigQuery. Internal business users and external partners were able to run the exact same analytics as they had before the migration without realizing that the data store they were querying against had shifted to the cloud.
  • They were able to continue their modernization by leveraging AtScale to manage cloud costs, ensure predictability of performance, and create the scalability needed to accommodate growth in the years to come.
  • By working directly in Google BigQuery, AtScale reduced the cost of a query by 91%, empowering the organization to re-allocate funds to increase the number of value-creating analysts to better support the needs of the business.
Quantitative Benefit
  • Reduced the cost of a query by 91%
  • Increased data retention from 3 months to 3 years (a 1200% increase)
  • Supported the 17,000+ queries per day being initiated by their large constituency of internal and external users

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.