AtScale Case Studies Wayfair Embraces Self-Service BI with AtScale

Edit This Case Study Record

	Wayfair Embraces Self-Service BI with AtScale AtScale

Wayfair Embraces Self-Service BI with AtScale

AtScale

Technology Category	Analytics & Modeling - Real Time Analytics Infrastructure as a Service (IaaS) - Cloud Computing Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries	E-Commerce Retail
Applicable Functions	Business Operation Sales & Marketing
Use Cases	Inventory Management Predictive Quality Analytics Supply Chain Visibility
Services	Cloud Planning, Design & Implementation Services Data Science Services System Integration
Challenge	Wayfair, a fast-growing ecommerce retailer, was facing challenges with its existing analytics infrastructure. The company was using Microsoft SQL Server Analysis Services (SSAS) for mission-critical analysis, but as the business grew, this solution was not scalable enough. Wayfair decided to modernize their analytics infrastructure and move to a cloud platform, specifically Google BigQuery. However, they needed to ensure that the transition didn't disrupt the hundreds of business analysts who relied on SSAS for their daily operations. The company also wanted to maintain a hybrid on-premises/cloud environment for a time to ensure business continuity. Read More
About Customer	Wayfair is a fast-growing ecommerce retailer. The company uses data extensively to measure customer interest and chart the performance of their manufacturers. To operate their business successfully, they need to parse through data to predict the price and quantity of every SKU. Wayfair encourages all employees to interact with data and promotes a self-serve analytics culture. The company has hundreds of data modelers and business analysts who support the full range of Wayfair’s online businesses. Read More
Solution	To support their modernization, Wayfair chose AtScale. This solution provided a semantic layer that simplified and accelerated analytics, allowing the company to maintain OLAP analytics capability without the overhead and data movement required by SSAS. AtScale bridged Wayfair’s cloud data with business analysts who relied on high-performance dimensional analytics. This solution allowed Wayfair to maintain a single source of governed metrics that could be accessed with different BI tools, supporting the company's self-serve analytics culture. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Infrastructure as a Service (IaaS) - Cloud Computing

Infrastructure as a Service (IaaS) - Cloud Databases

Applicable Industries

E-Commerce

Retail

Applicable Functions

Business Operation

Sales & Marketing

Use Cases

Inventory Management

Predictive Quality Analytics

Supply Chain Visibility

Services

Cloud Planning, Design & Implementation Services

Data Science Services

System Integration

Challenge

Wayfair, a fast-growing ecommerce retailer, was facing challenges with its existing analytics infrastructure. The company was using Microsoft SQL Server Analysis Services (SSAS) for mission-critical analysis, but as the business grew, this solution was not scalable enough. Wayfair decided to modernize their analytics infrastructure and move to a cloud platform, specifically Google BigQuery. However, they needed to ensure that the transition didn't disrupt the hundreds of business analysts who relied on SSAS for their daily operations. The company also wanted to maintain a hybrid on-premises/cloud environment for a time to ensure business continuity.

About Customer

Wayfair is a fast-growing ecommerce retailer. The company uses data extensively to measure customer interest and chart the performance of their manufacturers. To operate their business successfully, they need to parse through data to predict the price and quantity of every SKU. Wayfair encourages all employees to interact with data and promotes a self-serve analytics culture. The company has hundreds of data modelers and business analysts who support the full range of Wayfair’s online businesses.

Solution

To support their modernization, Wayfair chose AtScale. This solution provided a semantic layer that simplified and accelerated analytics, allowing the company to maintain OLAP analytics capability without the overhead and data movement required by SSAS. AtScale bridged Wayfair’s cloud data with business analysts who relied on high-performance dimensional analytics. This solution allowed Wayfair to maintain a single source of governed metrics that could be accessed with different BI tools, supporting the company's self-serve analytics culture.

Impact #1	Wayfair was able to maintain business continuity during their transition to the cloud.
Impact #2	The company was able to support hundreds of business analysts using Microsoft Excel and Tableau and maintain OLAP analytics capability without the overhead and data movement required by SSAS.
Impact #3	AtScale provided one unified and governed view of business data for the hundreds of data modelers and business analysts who support the full range of Wayfair’s online businesses.

Impact #1

Wayfair was able to maintain business continuity during their transition to the cloud.

Impact #2

The company was able to support hundreds of business analysts using Microsoft Excel and Tableau and maintain OLAP analytics capability without the overhead and data movement required by SSAS.

Impact #3

AtScale provided one unified and governed view of business data for the hundreds of data modelers and business analysts who support the full range of Wayfair’s online businesses.

Benefit #1	Wayfair was able to accelerate their time-to-insight with a live connection to cloud data at OLAP query speeds.

Benefit #1

Wayfair was able to accelerate their time-to-insight with a live connection to cloud data at OLAP query speeds.

Download PDF Version

Overview

Wayfair Embraces Self-Service BI with AtScale

Operational Impact

Quantitative Benefit