FinTech Transaction Analytics

Helping management understand payment behavior, revenue drivers, customer segments and fraud risk
across 15,000 transactions · 10 countries · ₹31.21Cr total volume

SQL · 30+ QueriesPython EDA Power BIRFM Analysis Fraud DetectionFlask APIs 10 CountriesCohort Retention
📊
Total Transactions
15,000
FY 2024 · All channels
💰
Total Revenue
₹31.21Cr
Successful txns
↑ 23.4% YoY
📈
Avg Txn Value
₹23,913
Per successful txn
↑ 8.1% QoQ
Success Rate
87.02%
13,053 transactions
Failure Rate
9.01%
1,351 failed
↑ Needs action
👥
Unique Customers
2,978
Active 2024
↑ 14.6%
🌍
Countries
10
International reach
🚩
Flagged Txns
594
₹1.37Cr at risk

💰 Revenue & Monthly Trends

Business Performance
Monthly Transaction Volume & Count MoM Trend
Transaction Status Split Success·Failed·Pending
Revenue by Txn Type Debit·Credit·Transfer
Device Distribution Mobile·Desktop·POS

💳 Payment Methods & Channels

Channel Analysis
Revenue by Payment Mode ₹ Millions
Failure Rate by Payment Mode Risk Signal
Revenue by Merchant Category Spend Category
Hourly Transaction Volume — Peak Hours 24h Cycle

👥 Customer Behavior & RFM Segmentation

4 Segments
💤
Dormant
728
Avg Spend
₹15,517
Recency 153d
⚠️
At Risk
684
Avg Spend
₹63,439
Recency 84d
Loyal
799
Avg Spend
₹115,109
Recency 60d
Champion
754
Avg Spend
₹219,468
Recency 27d
RFM Revenue Share Who drives revenue?
Top 10 Merchants by Revenue ₹ Millions

🌍 Geographic Performance

Country · City
Revenue by Country Top 10
Country Volume Share % Distribution
Country Performance Detail All Regions
#CountryRevenueTransactionsUsersShareBar
1 India ₹224,034,783 9,485 2,872 71.77%
2 USA ₹19,081,498 762 678 6.11%
3 UAE ₹13,715,655 609 552 4.39%
4 UK ₹11,748,125 486 441 3.76%
5 Singapore ₹9,708,170 407 383 3.11%
6 Canada ₹8,830,099 386 360 2.83%
7 Netherlands ₹8,474,034 281 272 2.71%
8 Australia ₹7,241,187 260 247 2.32%
9 Germany ₹6,140,417 256 250 1.97%
10 Japan ₹3,166,034 121 119 1.01%
Revenue by City — India Top 10
Transactions by City Count

🚨 Fraud Indicators & Risk Signals

Anomaly Detection
🌙
Late Night High-Value
67
12AM–5AM · Amount > ₹50,000
✈️
Impossible Travel
71
Multi-city same-day anomaly
🚩
Total Flagged
594
4% of all transactions
💸
At-Risk Volume
₹1.37Cr
Total financial exposure
♻️
Refund Abuse Users
~120
Refund ratio > 40%

💡 Business Insights for Management

10 Actionable Findings
#FindingBusiness ImpactActionPriority
01UPI dominates 45%+ of volumePrimary channel outage = major revenue loss99.99% SLA, fallback mode🔴 Critical
02Top 5% users → ~35% revenueHVU churn = immediate revenue cliffVIP loyalty tier, dedicated support🔴 Critical
03Failure rate 9.01% — 1,351 failed txnsEach failure = lost revenue + trust damageRoot cause analysis; target <5%🔴 Critical
04₹1.37Cr at-risk in 594 flagged txnsDirect financial fraud exposureReal-time ML fraud scoring🔴 Critical
05Peak: 10AM–12PM & 7PM–9PM — 40% daily volumeOutage risk highest in 4-hour windowsAuto-scale infra before peaks🟡 High
06Champions spend 3.5× more than DormantSegment revenue gap wideningWin-back offers for Dormant users🟡 High
07India = 71.77% of volume — low geo diversityConcentration risk; limited growthExpand to UAE, Singapore, UK🟡 High
08~120 users: refund ratio >40%Est. ₹18–24L in avoidable refundsManual review + refund friction🔵 Medium
09Mobile = 68% of transactionsMobile-first investment justified70% UX budget to mobile app✅ Opportunity
10Health category growing 34% YoYHigh-intent repeat customers emergingPartner 3 more health merchants✅ Opportunity