OverviewSymphony RetailAI helps retailers and CPG manufacturers drive profitable revenue growth through AI-enabled decision-making. Its customers include 15 of the world’s 25 largest grocery retailers, thousands of retail brands, and hundreds of national and regional chains. To uncover the insights that its customers require, Symphony RetailAI must continually ingest and analyze terabytes of customer data into its 700TB data warehouse environment. And in the fast-moving consumer goods industry that Symphony RetailAI serves, the company must turn those mountains of raw data into actionable insights and deliver them to customers as rapidly as possible.
Legacy and cloud-only options failing to deliverIn 2018, Symphony RetailAI began looking for a data warehousing platform that could help it scale for customer growth and minimize the time required to get insights to customers. That meant not only reducing query times, but also less time required to ingest that data, analyze it, and make the results accessible. At the time, Symphony RetailAI relied on a range of different data warehousing platforms, including Netezza, AWS Redshift, SQL Server, and 1010data. However:
- Redshift costs were high and cube build processes took up to 20 hours, making it hard to increase functionality without violating SLAs.
- Queries on 1010data were also slow, and its custom programming language made development difficult.
- Processing took too long on Netezza, which was already at full capacity—and would soon be EOL’d.
Yellowbrick removes the limitsThe company considered going cloud-only with Snowflake or Google BigQuery, but neither offered the predictable price/performance of Yellowbrick. For example, although one vendor promised on-demand scalability, Symphony found that it would either need to subject customers to unacceptable 12-15 second delays for real-time queries as instances in the cloud were scaled-up, or would need to pay four times as much as Yellowbrick to keep those instances running 24×7. Symphony RetailAI moved all workloads from Netezza, Redshift, and 1010data to Yellowbrick, with results including:
- Faster, more accurate reports and queries to get richer insights to customers more quickly. When on Netezza, Symphony RetailAI had to limit reports that were run up to 5,000 times daily to 10% data sets. Today, on Yellowbrick, the company is running those reports with 100% data sets and delivering them twice as fast. Compared to AWS Redshift, cubes built on Yellowbrick completed 3X-5X faster. And compared to 1010data, Yellowbrick is 4X-5X faster.
- Freedom to deploy anywhere. Yellowbrick’s small form factor lets Symphony RetailAI easily run workloads where its customers are, instead of shipping raw data and query results back-and-forth across the globe.
- Less data movement. Strong performance under mixed workloads has helped Symphony RetailAI streamline processes and reduce data movement. It’s now delivering new insights to customers up to 12 hours faster each week by avoiding the need to move hundreds of gigabytes of data to the cloud before it can be queried.
- Ease of migration. Compared to what would have been required on other platforms, the company’s move to Yellowbrick has been fast and easy, with few if any modifications needed.