📌 Overview
A deep-dive SQL analysis of 25,000+ credit card transactions across India, uncovering regional spending patterns, high-growth opportunities, and risk indicators to support smarter financial decision-making.
🎯 Objectives
- Identify regional and demographic spending trends across Indian states
- Surface high-impact growth opportunities and potential risk indicators
- Build a performance evaluation framework for transaction behavior analysis
- Enable data-driven prioritization of business initiatives
🛠️ Tools & Technologies
| MySQL | Data extraction, cleaning, analysis |
| Excel | Data validation and cross-checking |
📊 Key Findings
🔍 Identified 3+ high-impact growth opportunities across transaction segments
📍 Uncovered distinct regional spending patterns across 10+ Indian states
📈 Quantified behavioral trends enabling targeted business improvements
💡 Business Recommendations
- Focus marketing spend on the top 3 high-transaction regions
- Flag accounts with anomalous spending patterns for risk review
- Allocate resources toward the highest growth transaction categories