Telco - Account Development

by Tableau

Description

This Tableau Accelerator allows you to:

  • Assess & Grow Monthly Recurring Charges (MRC)
  • Predict & Reduce account churn
  • Optimise Product Mix
  • Understand Account Portfolio Evolution
  • Improve mobile penetration & 5G penetration
  • Identify potential MRC growth areas

Demo video

Answer key business questions

  • What is the composition of our revenues? How does it trend?
  • Are we efficient at recruiting new accounts? At retaining existing accounts?
  • Are we efficient at cross-selling?
  • What is Penetration Rate of Mobile, Internet and Mobile 5G?
  • Where do we have opportunities for improvement?

Monitor and improve KPIs

Monthly Recurring Charges (MRC)

  • Total MRC: Total Monthly fee paid by accounts
  • Total Mobile MRC: Total Monthly Recurring Charges: total monthly fee accounts pay for mobile services (expressed in currency)
  • Wireline MRC: Total Monthly Recurring Charges: total monthly fee accounts pay for wireline services (expressed in currency)
  • Wireline MRC %: Share of revenues which is generated by wireline (expressed in %)
  • Mobile MRC %: Share of revenues which is generated by Mobile (expressed in %)
  • MRC per Account: Average MRC per account (expressed in currency)

Penetration

  • Mobile 5G Penetration: Share of mobile accounts who have 5G (expressed in %)
  • Mobile Penetration: Share of mobile accounts
  • Internet Penetration: Share of wireline accounts having “Internet” as product (expressed in %)
  • Mobile Device Penetration: Share of mobile accounts having “mobile device” as product (expressed in %)
  • Accounts with Mobile Only %: Share of accounts who are mobile only (expressed in %)
  • Accounts with Wireline Only %: Share of accounts who are wireline-only (expressed in %)

Accounts Churn

  • Churn Rate: Share of accounts who left
  • Lost Accounts: Number of accounts who left

Accounts

  • Accounts: Total number of accounts
  • Mobile Accounts: Number of accounts having a mobile subscription
  • Mobile 5G Accounts: Number of mobile accounts with 5G network
  • Nb Accounts With Mobile Device: Number of accounts having a Mobile Device subscription
  • Nb Accounts With Mobile Only: Number of mobile-only accounts
  • Nb Accounts With Wireline Only: Number of wireline-only accounts
  • Nb Accounts With Wireline Phone: Number of accounts having a wireline phone subscription
  • Nb Accounts With Internet: Number of accounts having an internet subscription

Required attributes

The required dataset is a list of snapshots of your account base (at least 2):

  • Snapshot Date (date): Date of the Snapshot
  • Account # (string): Account Unique Identifier
  • Mobile Tenure Start Date (date): The date when the account initiated a mobile contract
  • Wireline Tenure Start Date (date): The date when the account initiated a wireline contract
  • Account Birth Date (date): Account Birth Date
  • Country (string, role: Country): Country of the account
  • State (string, role: State): State of the account
  • City (string, role: City): City of the account
  • Wireline - Has Internet Flag (string): “Y” if the account has Internet, otherwise set to “N”
  • Wireline - Has Wireline Telephone Flag (string): “Y” if the account has Wireline Telephone, otherwise set to “N”
  • Mobile - Has Mobile 5G Flag (string): “Y” if the account has Mobile 5G, otherwise set to “N”
  • Mobile - Has Mobile Device Flag (string): “Y” if the account has Mobile Device, otherwise set to “N”
  • Mobile MRC (numeric): Monthly Recurring Charges (MRC) for mobile
  • Wireline MRC (numeric): Monthly Recurring Charges (MRC) for telephone

Features

Supports data mapping

Resources