Case Study: Wayfair achieves 1000X BI query speed and self-service analytics with AtScale

How Wayfair Uses Data to Drive their Business using Google BigQuery and AtScale

Wayfair, a fast-growing e-commerce retailer, needed to modernize its analytics as it migrated from on‑prem Microsoft SQL Server Analysis Services (SSAS) to Google BigQuery without disrupting hundreds of business analysts who relied on Excel and Tableau. To preserve OLAP-style performance, simplify a sprawling hybrid on‑prem/cloud environment, and enable self‑service analytics, Wayfair engaged AtScale to provide a cloud‑friendly semantic layer and dimensional analysis capability.

AtScale implemented a semantic layer that bridged BigQuery to existing BI tools, preserving OLAP query speeds with a live connection to cloud data and a single governed view of metrics. The outcome was dramatic: 1000X BI query speed acceleration, 5X increase in data retention, support for 2,000+ users and 50+ analytics use cases — enabling faster time‑to‑insight, minimal disruption during migration, and broader self‑service analytics across Wayfair.

Wayfair

Matthew Hartwig

Associate Director, Data Infrastructure Team