Big Data Integration

The client achieved incremental 2 percent portfolio growth per week, worth hundreds of millions of dollars in annual sales, and improved new product forecasting.

 

ISSUE

A leading U.S. brewer wanted to develop unique store-level assortment strategies to ensure optimal product placement at 500,000+ locations for the over 600 different SKUs in distribution.

While the client already executed store-level strategies, additional granularity was required to account for the uniqueness of each store (layout, shelf space, regional differences, etc.). Developing an assortment strategy that leveraged these individual store factors required granular competitive data (by item and by store on a weekly basis) and a means of integrating the data from multiple sources.

INSIGHTS

First, IRI deployed a three-step process to impute a full market view of competitor and client sales, as well as purchase drivers at the store level:
 

1. Data Assembly:

IRI compiled over 100 internal and partner-provided data sets, spanning from point-of-sale and e-commerce information to digital measurement and gas price data, providing rich insight into aisle dynamics.

2. Integration and Harmonization:

After assembling the multitude of data assets, IRI identified key dimensions that needed to be aligned across the database, such as time, geography, product, etc., in order to ensure a seamless integration. The data was then processed, sanitized, harmonized and stored at the “leaf level” (greatest possible granularity) to allow for complete accuracy and lightning-fast access.

3. Liquid Data Deployment:

Following sanitation and harmonization, the complete database was loaded into IRI’s Liquid Data™ platform. To make the data accessible and functional, IRI constructed brand hierarchies, assigned specific product attributes, distributed between specific segments, and developed all necessary calculations and rule sets.

Once the process was complete, IRI developed a unique analytic approach with the client to create a store-level assortment optimization tool. The solution optimized the potential for each store across a variety of execution tactics. The tool was based on store-level shopper preferences (loyalty to 25 key beer attributes) as well as constraints such as floor and shelf space. It was also dynamic, allowing the client to make decisions quickly for each of its 500,000+ stores. The resulting assortment recommendations were also delivered via mobile to each route driver for execution.

IMPACT

The client’s initial pilot achieved incremental 2 percent portfolio growth per week, worth hundreds of millions of dollars in sales annually, in stores that implemented the recommendations versus a control group. The newly integrated data platform also dramatically improved new product forecasting through better understanding of store-level dynamics.

How can we help you supercharge growth and profitability?

FACTS ABOUT US

95% of CPG, retail, and health and beauty companies in the Fortune 100 work with us.

 

Answer the question below:
= eight - two