Blog · Board and management reporting · Telecommunications
A telecom commercial dashboard compares subscriber revenue, additions, and retention on consistent definitions. Work through a subscriber bridge, segment ARPU, and a revenue variation with the checks that prove the totals.
A Power BI telecom dashboard should show subscriber revenue and retention together, by segment and for the same reporting period. Reconcile subscriber movements first, then calculate revenue per subscriber and retention from those checked counts. The useful commercial question is whether growth comes from keeping subscribers, adding subscribers, or earning more from the subscriber base.
Use the overview for service revenue, closing subscribers, net additions, average revenue per subscriber, and retention. Below it, put a segment comparison beside a subscriber movement table. A commercial manager should be able to see which segment needs a pricing review and which needs a retention investigation.
Microsoft describes a Power BI dashboard as a single page of highlights, with related reports supplying the detail. That distinction helps here: the overview can summarize the commercial result while the supporting tables preserve its denominators. Broader Power BI dashboard examples cover other business layouts; this example concentrates on subscriber economics.
Covirage is not affiliated with Microsoft or Power BI.
Decide who will act before choosing charts. The revenue owner investigates service revenue and credits, the retention owner reviews disconnect reasons, and finance signs off the revenue tie. Microsoft's dashboard design guidance recommends choosing measures around the audience's decisions and providing context for important numbers.
Bring a subscriber movement export with subscriber identifier, segment, opening status, activation date, disconnect date, and closing status. Bring a revenue export with subscriber identifier, service month, service revenue, and adjustments. Keep identifiers consistent between them.
For this example, a subscriber means one active service line, not a billing account. A company with several service lines contributes several subscribers. Revenue means earned service revenue after service credits, excluding equipment sales and sales taxes. Cash collections belong to a different question.
The reporting period is September 2026. Segment assignments stay fixed throughout the month, and all disconnects in this illustration come from subscribers active at the beginning. New activations remain active at month end. Those assumptions make opening-cohort retention directly visible; a real export must identify that cohort rather than assume it.
Closing subscribers = Opening subscribers + Additions - Disconnects
Average subscribers = (Opening subscribers + Closing subscribers) / 2
Monthly ARPU = Monthly service revenue / Average subscribers
Opening-cohort retention = (Opening subscribers - Opening-cohort disconnects) / Opening subscribers
The average uses endpoint balances as an explicit approximation. If activations cluster near month end, daily average subscribers give a more representative denominator. Use the same method for every segment and every comparison month.
Consider an illustrative US telecom operator. Its checked September exports produce these segment totals. Amounts are USD and counts are service lines.
| Segment | Opening subscribers | Additions | Disconnects | Closing subscribers | Service revenue (USD) |
|---|---|---|---|---|---|
| Small business | 4,000 | 200 | 80 | 4,120 | 243,600 |
| Consumer | 6,000 | 300 | 180 | 6,120 | 272,700 |
| Enterprise | 1,000 | 40 | 10 | 1,030 | 101,500 |
| Total | 11,000 | 540 | 270 | 11,270 | 617,800 |
The small-business bridge is 4,000 + 200 - 80 = 4,120. The company bridge is 11,000 + 540 - 270 = 11,270. Net additions are 540 - 270 = 270, which also equals 11,270 - 11,000.
Apply the formulas to the preceding table. Monetary rates are rounded to cents and percentages to two decimal places; calculations retain unrounded values.
| Segment | Average subscribers | Monthly ARPU (USD) | Opening-cohort disconnect rate | Opening-cohort retention |
|---|---|---|---|---|
| Small business | 4,060 | 60.00 | 2.00% | 98.00% |
| Consumer | 6,060 | 45.00 | 3.00% | 97.00% |
| Enterprise | 1,015 | 100.00 | 1.00% | 99.00% |
| Total | 11,135 | 55.48 | 2.45% | 97.55% |
Small-business average subscribers are (4,000 + 4,120) / 2 = 4,060, and ARPU is 243,600 / 4,060 = $60.00. Its retention is (4,000 - 80) / 4,000 = 98.00%. The disconnect rate uses the same opening cohort, so it complements retention in this example.
The company ARPU is 617,800 / 11,135 = $55.48. Company retention is (11,000 - 270) / 11,000 = 97.55%. Calculate both from the totals. Giving each segment equal weight would treat the enterprise segment as though it had the same subscriber base as consumer.
Multiply each segment's unrounded ARPU by its average subscribers. The results must reproduce service revenue: 4,060 × 60 = 243,600; 6,060 × 45 = 272,700; and 1,015 × 100 = 101,500. Their sum is 617,800, matching the revenue table.
Next, reconcile that service revenue to the ledger account scope used for the report. Reconcile closing subscriber identifiers to the active-line register at the cutoff. Separate migrations between segments from company additions and disconnects; an internal move should not create a new company subscriber.
For a spreadsheet review before presentation, the Excel dashboard guide covers the broader layout workflow. Preserve the source tables alongside the summary so another reviewer can reproduce the arithmetic.
Now change only small-business service revenue from $243,600 to $223,300, perhaps after approved service credits. Subscriber movements and every other revenue amount stay unchanged. This is a sensitivity example, not a prediction about customer behavior.
| Measure | Original | With changed revenue | Calculation |
|---|---|---|---|
| Small-business revenue (USD) | 243,600 | 223,300 | 243,600 - 20,300 |
| Small-business ARPU (USD) | 60.00 | 55.00 | 223,300 / 4,060 |
| Company revenue (USD) | 617,800 | 597,500 | 617,800 - 20,300 |
| Company ARPU (USD) | 55.48 | 53.66 | 597,500 / 11,135 |
| Company retention | 97.55% | 97.55% | Opening cohort unchanged |
The company ARPU decline is 20,300 / 11,135 = $1.82 after rounding. This is a revenue change with stable subscriber counts, so retention work alone does not explain it. Finance should separate credits, product mix, and recurring price changes before the commercial team chooses an action.
Keep the commercial overview brief enough for an executive dashboard review, then assign each unexplained movement to an owner. Teams choosing an analysis approach can also review Power BI alternatives for the file-based business workflow.
Bring a sample of your own subscriber movement and service revenue files to Covirage, or upload a Google Sheet with the same columns. Covirage maps the columns, and its tools compute and check the subscriber bridge, segment revenue, and ratios; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your own export.
See Covirage for telecom teams for the industry context.
Include service revenue, opening and closing subscribers, gross additions, disconnects, average revenue per subscriber, and retention of the opening subscriber cohort. Show the reporting period and subscriber definition beside the figures so account counts are not mistaken for line counts.
Divide the period's eligible service revenue by average active subscribers for the same period. State whether the average uses daily counts or opening and closing balances. Exclude equipment revenue when the measure is intended to describe recurring service economics.
Yes. New activations can exceed disconnects even when existing subscribers leave at an increasing rate. Show gross additions and opening-cohort retention separately. A positive net subscriber movement does not establish that existing customers are staying longer.