__STYLES__
Process:
To begin the process, I performed ETL operations, addressing duplicate values, blank/nan values, and ensuring the totals are accurate. I then created the data model and commenced data exploration.
I crafted key questions to guide my analysis:
I tried to address most of these questions through the dashboard.
KPI's I have used
Challenge Facing Right now:
Low Credit Card Usage Across High APSC Categories:
Challenge: Encountering lower credit card usage in high Average Spending Per Customer (APSC) categories, especially in local groceries and food stalls.
Solution: Propose initiatives to transition from UPI and debit cards, offering merchants payment systems and guidance. Address concerns by partnering with businesses, providing incentives, and introducing exclusive deals on food and groceries.
Converting Lower APU Customers to Higher APU Customers:
Challenge: Transforming lower Average Utilization Percentage (APU) customers into higher APU segments.
Solution: Provide budget planners, spending insights, and introduce temporary AUP-based rewards like bonus miles to encourage responsible card usage and boost overall expenditure.
Product Recommendations:
Mitron Bloom:
Targeted Audience: Females
Features: Wellness points at spas, fashion cashbacks, extended warranties on gadgets.
Mitron Thrive:
Targeted Audience: Singles
Features: Food delivery rewards, entertainment discounts, discounts on electronics.
Mitron Legacy:
Targeted Audience: Families
Features: Groceries cashback, bills rewards, joint travel packages.
Mitron Wisdom:
Features: Discounts on medical appointments, health supplements, and fitness trackers.
Feature Recommendations:
Lifetime free credit card with no annual or joining fee.
5% cashback on grocery purchases (up to Rs.1000 per month).
1% fuel surcharge waiver on fuel spends at petrol pumps nationwide.
3x reward points on online grocery spends.
5x reward points on online dining spends.