Market Share Platform at Nutricia Netherlands

Challenge

Nutricia's Marketing and Innovation Department employees constantly analyze the market and the company's place in it - looking for niches for new products and opportunities to expand the presence of existing ones. Market data, however, came from different sources with different frequencies and levels of detail. Each cycle, employees spent significant time collecting and reconciling data manually before they could even start analyzing it. The team needed an analytical platform that takes the routine data-prep work off their plate.

Approach

We developed an algorithm and automated pipeline that lets users download and process all the required data "with one button". The pipeline pulls market data from each source on its own cadence, normalizes structures and granularities, and lands the data in a staging layer.

From staging, the data flows into a Master Data Service layer where users can enrich product and market-participant master data with internal categories and values used by the company. Once the user has finished enriching, the dataflow continues automatically to the final storage and on to Power BI - where the marketing and innovation team works with the prepared dataset.