Promotional Opportunity & Customer Segmentation Analysis
Customer segmentation, basket affinity, and household promotional opportunity scoring in Power BI
Analyzed 2.6M+ transactions across 2,500 households representing $8.06M in sales to understand customer behavior and identify promotional opportunities.
- Engineered a household-level promotional scoring framework evaluating customer engagement, category affinity, and campaign responsiveness.
- Controlled for analytical zero-inflation bias and department-size distortion across 2,500 households and $8.06M in sales.
- Translated and cross-validated analytical pipelines across Python, PostgreSQL, and AWS Athena.
- Constructed an executive Power BI dashboard, identifying 10 un-campaigned high-affinity households and evaluating an illustrative $18.1K sensitivity case.