Our client, a multinational corporation, issues discount codes to partners for their technology certification exams. Client needed to monitor target attainment at partner levelfor efficient utilization of discount codes.
Gathered essential data from various sources and performed exploratory data analysis (EDA) to understand the discount code distribution system.
Provided a detailed report on distributed codes and conducted a brainstorming session to analyze partner usage behavior.
Developed a formula for partner-wise projection, determining the number of codes needed for each partner.
Created impactful visuals in a Power BI dashboard for insightful data representation.
Enabled informed decisions for quarter-wise target setting and efficient code distribution aligned with strategic objectives.
Power BI report offered real-time information on code requirements for each partner, facilitating customized distribution.
Partners gained awareness of projected usage, allowing proactive adjustments in their usage pattern.