Wendara Telecom
Mobile subscribers, usage, ARPU, and churn for a regional carrier
About Wendara Telecom
Industry
Mobile carrier operations and subscriber analytics
Footprint
14 metro markets across four regions; 180 network sites
Subscriber scale
about 82K active lines of 130K lifetime lines
Account base
about 75K consumer and business accounts, every one of them owning at least one line
Revenue scale
about $121M total over the two-year window (~$34M/year service revenue)
ARPU
about $62 per active line per month
Dataset scope
19 Enterprise-tier tables
Wendara Telecom is a fictional regional mobile carrier created for synthetic BI demos and training. The business story is intentionally realistic but does not represent a real carrier, MVNO, subscriber base, device lineup, network, or billing system. The kit presents a believable mid-size mobile operator where BI builders move from monthly service revenue and the active base into rate plans, per-line usage, billing and ARPU, network site performance, care load, churn, and market P&L. It is built for revenue, subscriber, network, and care teams rather than as a billing, provisioning, or OSS/BSS system of record.
Operating Profile
- Wendara sells consumer, prepaid, business, and connected-device rate plans, from Basic Talk & Text and
- A subscriber line is activated through a sales channel onto a rate plan with a device, consumes voice,
- Metered lines typically run at about two thirds of their contracted data allowance, and the roughly
- Network sites carry traffic across 4G LTE and 5G with daily performance KPIs (throughput, utilization,
- Market-level monthly P&L rolls up from line billing and in-window device activations, while the activation fact deliberately
- The kit excludes real subscriber identities, phone numbers, SIM and device identifiers, payment-card
Recent Business Events
- 1Wendara opened three newer markets and added new cell sites as it densified coverage, stepping the
- 2The active line base grew steadily across the two years, lifting monthly service revenue from about
- 3Average mobile data consumed per line rose about 37 percent over the window (roughly 14 to 19 GB per
- 4Retention teams now review churn alongside care tickets, coverage, and network speed, with competitor
These are the operating questions this kit is optimized to answer first.
Service revenue, total revenue, active lines, and ARPU by month, market, and plan family
Gross adds, churn rate, average tenure, and churn-reason mix by plan, market, and tenure band
Mobile data, voice, messaging, and roaming usage by plan family, market, and device tier
Network throughput, utilization, and dropped-call rate by site and technology, plus care ticket
Embedded Analytical Stories
Revenue and ARPU growth
connect monthly service revenue, equipment revenue, the active base, and
Market portfolio quality
compare region, market, and tier performance on revenue and margin,
Usage and plan mix
follow how data, voice, and roaming usage differ across plan families and rise
Network and care health
read site throughput, utilization, and reliability by technology, and
Billing roll-up
Market service revenue traces to line billing and equipment revenue to the