Case Study: 1010DATA Conversion to Snowflake

CASE STUDY: 1010DATA CONVERSION TO SNOWFLAKE

The Client measures how consumers shop across all channels, sourcing data from both retailers and consumers to quantify sales, share, distribution and velocity. The market research company collects point-of-sale data, tracking retailers, distributors and foodservice operators, measuring what’s selling at over 1,200 retailers, across over 300,000 stores. The Customer also interviews over 12 million consumers annually and tracks millions of their receipts—following the same consumers over time—to understand shifting tastes and trends.The Client helps retailers, manufacturers, financial analysts, and the public sector measure performance, predict future performance, improve marketing and product development, and identify business and consumer trends and market opportunities. The Client tracks spending and has dedicated advisers and analysts in more than 20 industries: apparel, appliances, automotive, beauty, books, consumer electronics, e-commerce, entertainment, fashion accessories, food consumption, foodservice, footwear, home, juvenile products, mobile, office supplies, retail, sports, technology, toys, travel retail, video games and watches/jewelry.

Challenge

The Customer’s adoption of 1010DATA started as a BI trial that performed well on small scale analytics. However, when they rolled it out to their large retail customers, the solution choked under the computation load. While the deployment was not ideal, the momentum of adoption kept the solution within the Customer ecosystem despite the lack of performance being a consistent thorn in their side. Intricity had assisted the Customer in helping them migrate their Hadoop/HBASE deployment to Snowflake, which was an instant success within the organization. The Customer was seeking to build on that success by targeting the customer-facing analytics supported by their struggling 1010DATA deployment. The 1010DATA deployment was a complex repository of...

To read the full Case Study click here: https://www.intricity.com/whitepapers/1010data-conversion-to-snowflake-case-study