Tackling OSA

Consumer product goods

Mondelez International, styled Mondelēz, is an American multinational confectionery, food, and beverage company based in Illinois which employs about 107,000 people around the world.


  • Amazon Redshift
  • Amazon EC2
  • Tableau Server
  • Tableau Desktop


  • Integration
  • Analysis
  • Visualization

Problem Statement

If a product is not on the shelf, it represents a lost opportunity to make a sale. The issue of accurately measuring and addressing OSA (On-Shelf Availability) is prevalent across the CPG industry and represents millions of dollars in lost sales. Due to the data living in multiple source systems along with the massive volume of data, Mondelez had difficulty getting a clear picture of which products and which stores represented these missed opportunities. Mondelez needed a tactical mechanism to visually identify and address these areas of concern. Mondelez turned to StartupMetrics to help solve this problem.

SUM Solution

Data cleansing and data integration were key components necessary to perform analysis at the correct level of granularity. Working with multiple Mondelez departments, StartupMetrics sourced all of the data required for this analysis, including the Product Information (e.g. Product name, UPC, Brand, Category, Department, etc.), Sales Force Hierarchy (e.g. Region, District Manager, Sales Rep, etc.), Customer / Store information (e.g. Retailer, Store name, address, etc.), Sales information (e.g. POS Dollar and units, OOS Dollar and Units, etc.) and Supply Chain information (e.g. Delivery Schedule, Orders, Shipments, etc.). StartupMetrics mapped out the relationships between the data and created a unified and flexible data model in the data warehouse to store the information. 

Data Analysis and Data Visualization required a strong understanding of the business need as well as the audience. The Executive audience needed to see performance at the aggregated level, while the District managers and sales reps only really cared about their own stores and products. Tableau handles this dichotomy with ease.  

Finally, Data Automation and Dissemination was also an important factor in the success of this initiative. As new sales data and orders and shipments data were flowing in daily through the automated integration, the dashboard vizs were automatically updated. StartupMetrics was able to integrate these into Tableau's mobile app, Vizable, to send them automatically to all of the district managers and sales reps on a weekly basis. 

Custom Code