Involved collaboration with the client, and the following steps were executed:
- Factor mapping was performed to identify a comprehensive list of factors for assessing partner behavior.
- Hypotheses regarding these factors were formulated and tested.
- Exploratory analysis was conducted on sales data to analyze seasonality and market trends.
- Purchases of different partner levels for the upcoming year were forecasted.
- An Excel-based model with varying thresholds was designed to estimate partner purchases.
- The team identified the appropriate thresholds and requirements to define the program.