High Level Design

Overview

A Telecom company’s decision to invest in upgrading infrastructure is strategic and should be based on early data and supporting metrics. By adopting this data-driven approach, the company can benefit most from either improving customer service to valuable clients or even help increase market share. This telecom analytics BI solution assists the organization on deciding what would be the best approach before starting with the upgrade.

Dashboard Example (sample data)

Click on the image to open and interact with the dashboard:

Telecom Infrastructure Prioritization Dashboard

 

Goals

Decide on the best location to invest in upgrading infrastructure.

Objectives

  • Improve customer satisfaction in locations where the current infrastructure conditions are the worst (based on amount of technical support calls)
  • Improve customer satisfaction to VIP customers (customers with high ARPU value)
  • Potentially increase of market share in areas where market share is relatively low

KPI Architecture

Objectives KPIs Measures Data Source
Improve customer satisfaction in locations where the current infrastructure conditions are the worst (based on amount of technical support calls) Calls per customer Avg. infrastructure calls per customer
(dupcount([Call ID]),[CallTypeName])/count([CustomerID])
Fact_Calls, DimCustomer, DimCall_Type
Calls per customer Max total calls per customer
max([CustomerID],(dupcount([Call ID]),[CallTypeName]))
Fact_Calls, DimCustomer, DimCall_Type
Calls per week Avg Calls
(dupcount([Call ID]),[CallTypeName])
Fact_Calls, DimCall_Type
Improve customer satisfaction for VIP customers (customers with high ARPU value) ARPU Avg ARPU
avg([ARPU Value])
DimNeighbourhood, DimCustomer
Number of customers Number of customers
count([Customer ID])
DimNeighbourhood, DimCustomer
ARPU Max ARPU
[Total ARPU_Value]
DimNeighbourhood, DimCustomer
Potentially increase market share in areas where market share is relatively low Average Market share Average Market Share
avg([Market Share])
DimNeighbourhood, DimCustomer

Data Modeling (Elasticube Design)

Suggested data model for infrastructure prioritization in the telecom industry