Improve Trade Spend ROI with Trade Promotion Optimization Solution on Azure
Objective: Develop a scalable solution across brands and regions to study the efficacy and efficiency of trade promo spends coupled with a simulated environment to determine an efficient TO-BE state.
Key Challenges Addressed:
How do we address your challenges:
Pilot Outcome: Scope: 1 Country; 2-3 PPGs; 1 Customer
ML models for Trade Promo Effectiveness; Price Elasticity curves; Promo KPIs: ROI, incremental volume / revenue
Implementation Plan The break-up of the implementation plan is as below: Week 1 - Conduct data discovery and sanitize required data elements Week 2 - ML models to extract baselines and elasticities Week 3 - Model refinement and Promo KPI computation
This implementation uses the following native Azure components: ADF pipelines ADLS Gen 2 Azure SQL Database Azure ML Power BI