The client, a multinational corporation, provides certification exams with discount codes for partners. They needed an efficient system for distributing codes and tracking usage, requiring a weekly status report.
Discount codes are collected, divided into batches, and distributed based on partner needs and previous batch utilization.
Integrated code status, partner mapping, and exam details for comprehensive analysis.
Identified key metrics for a clear understanding of code status and usage patterns across partners.
Created a Power BI dashboard with engaging design and custom visuals to show weekly variations in key metrics.
Added dynamic filters for dashboard slicing and provided guidelines for easy navigation.
The new system made it easy to assign codes to partners and track them efficiently.
PowerBI report provided detailed insights into partner behavior, exams focused, and specializations, enabling targeted engagement.
Reporting helped distinguish active partners from those accumulating unused codes, allowing strategic redistribution for maximum usability.
Offered practical guidance for maximizing retention.
