Airtel customer churn analytics dashboard — sample data only, for illustrative purposes.

Sample data only. All figures, subscriber counts, revenue values, and segment breakdowns shown in this dashboard are illustrative and do not represent actual Airtel data. This is a template built to demonstrate dashboard structure and analytical capability.
Churn analytics dashboard
Airtel prepaid — Q2 2024 · Updated daily
3 high-risk segments
Overall churn rate
4.8%
+0.6% vs last quarter
At-risk subscribers
1.24M
+18K this month
Monthly revenue at risk
₹31.2Cr
+₹4.1Cr vs last month
Retention success rate
62%
+5% vs last quarter
Churn rate trend — last 12 months
Churn rate % Retention target
Sample data only.
At-risk segments
HIGH RISK
342K
Low recharge freq.
MEDIUM RISK
518K
Declining data use
LOW RISK
291K
Complaint history
MONITOR
89K
Port requests
Churn by circle
Delhi NCR
6.2%
Maharashtra
5.3%
Karnataka
4.5%
Tamil Nadu
3.8%
UP East
3.4%
Rajasthan
2.9%
Usage: churned vs retained
Churned Retained
Sample data only.
Revenue at risk by plan
Sample data only.
Top at-risk subscriber cohorts
Cohort Subscribers Avg. tenure Last recharge Data use (30d) Risk level
No recharge 15–30 days1,84,3208 months18 days ago0.2 GBHigh
Data usage drop >60%2,21,45014 months6 days ago0.8 GBHigh
Port request initiated89,12022 months2 days ago3.1 GBHigh
3+ complaints in 60 days1,12,80011 months9 days ago1.4 GBMedium
Downgraded plan tier98,54019 months3 days ago2.2 GBMedium