Alcoholic drinks

Modelling the drivers of sales uplift for a large alcoholic drinks client

Understanding needs

Our task was to connect two massive databases in a fast growing market – one on daily sales and another on daily shelf placement data.

We were able to extract and combine daily data for over 25,000 outlets and 3 million individual sales invoice/ shelf placement records.

Connecting data

Evaluation of the ‘Outlet Execution’ standards programme to assess sales performance, in 4 key markets and provide a 360 view of sales performance.

Using time series analysis and econometric modelling, we were able to pinpoint which outlets were working and which needed recalibrating.

Driving change

Gave clear guidance on where targets were working and where they needed to be reworked for the next financial year.

Visual output mapping all 50+ outlet segments into a single ‘current vs expected’ performance framework.

quotations

Unbelievable impact in a short space of time. Analytics across diverse data was an eye-opener, providing clear direction to take to the CEO

Global Head of Consumer Analytics & Insights

Decision Sciences

If you have any data analytics questions or challenges please get in touch with:

Hasdeep Sethi

Data Science Director

hasdeep.sethi@bonamyfinch.com

Hasdeep Sethi