Big Data Integration

A market leading 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.


Big Data Integration, Integration of multiple Big Data assets spanning sales data and purchase drivers allowed the retailer to make better store-by-store assortment decisions, yielding a 2% sales boost in a mature market.


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.


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 fuel 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 then 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.


The client’s initial pilot achieved incremental 2% portfolio growth per week, worth hundreds of millions 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?


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


Answer the question below:
= eight + six