telco bi
TRANSCRIPT
![Page 1: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/1.jpg)
Telecom Business Intelligence
March 2015
![Page 2: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/2.jpg)
ABOUT US
![Page 3: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/3.jpg)
3
CUBOT
CUBOT is our BI product
Developed and owned by Robust
Designs
CUBOT now has over 40 customers
in India, Singapore, Malaysia,
Singapore, Vietnam & Netherlands
Developed with the vision:
Faster to Implement, Simpler to use
Robust Designs and CUBOT
CUBOT
Robust Designs (RD) is an Asian
Software company specializing in
Business Intelligence Solutions
Operational since 2004
RD stats
Privately held
Offices: Singapore, Mumbai,
Bangalore
15 people
![Page 4: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/4.jpg)
4
Experience with BI over the YearsInstallations in India, Singapore, Malaysia, Vietnam, Netherlands, and Africa
PA
ST
CU
RR
EN
TA
PAC
IND
IAP
AS
TC
UR
RE
N
T
![Page 5: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/5.jpg)
5
Knowledge Delivery: Overview
DASHBOARDS
• For Executives
REPORTS
• For Operations and Finance
MIS
• Drill down, Filters, Enquiry, Detailed lists, Export to Excel, pdf
SECURITY
• Role based provisioning of information to different departments, geographies and seniority
WEB BASED
• Browser front-end, Server centric, cloud ready
![Page 6: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/6.jpg)
6
Experience with Telecom BI Applications
Business
Operations
Finance
Service Delivery
Customer Satisfaction
Revenue Assurance
Vendor Payouts
Revenue Analysis
Telecom Areas
Products
Clients
Markets
RBT, SMS, USSD
Content
USSD
3G, 4G Speed Test
Media
GNOC
VAS
Music
![Page 7: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/7.jpg)
Business: RBT Tracker
• Comviva’s Airtel RBT platform (covering north, east, west regions in India) with – 10M subscribers
– >1M daily RBT
• Integration of 3 hubs
• Operational reporting
• Campaign analysis
• Sales analysis
• Ad-hoc analysis
Business
![Page 8: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/8.jpg)
Business: Music
• Music portal provides
streaming and
download of music
and videos
• Usage, behavior,
product popularity,
consumer patterns are
provided via BI
• Recommendation
engine implementation
is done based on
these
Business
![Page 9: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/9.jpg)
Business/Finance: Revenue Analysis
• Revenue analysis
across products,
customer types,
channels,
telecom circles
• Target vs actual
tracking and
reporting with
alerts for
shortfalls
Business
![Page 10: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/10.jpg)
10
Telecom: VAS
Business Process KPIs
Business
![Page 11: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/11.jpg)
11
Subscribers by ARPU Levels, Customer Segments
(Average, 80% of Average, 60% of Average Chart)Business
![Page 12: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/12.jpg)
12
Average Latency by Region & OSOperations
![Page 13: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/13.jpg)
13
Network Faults with ForecastOperations
![Page 14: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/14.jpg)
Service Delivery: Ookla Speed Test
• Ookla is world’s leading speed test platform
• Dashboards were made from Ookla data
• Speed– Downloads speed,
Upload speed, Latency
• Across various dimensions
– Geography – state/ city/ area of interest like malls
– Handsets
– Network type – 2G, 3G, LTE
– Month on month
Operations
![Page 15: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/15.jpg)
Finance: Revenue Reconciliation
• Revenue from
clients is tracked
at individual
content level
• Client receivables,
revenue share,
vendor payments
calculated
• Reports made
available for
transparent
financial
operations
(3,000) (2,000) (1,000) - 1,000 2,000 3,000 4,000
ANDHRA PRADESHASSAMBIHAR
CHENNAIDELHI
GUJRATHARYANA
HIMACHAL PRADESHJAMMU & KASHMIR
KARNATAKAKERALA
KOLKATAMUMBAI
NORTH EASTORISSA
PUNJABRAJASTHAN
TAMILNADUUP EAST
UP WESTWEST BENGAL
Revenue Reconciliation
Revenue Recon Diff Recon Count Diff
Finance
![Page 16: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/16.jpg)
Revenue by Business Lines
• Month on
Month
Revenue by
business
lines
Finance
![Page 17: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/17.jpg)
17
Knowledge Delivery: Visualizations
Location
Analysis
KPI
Analysis
Heat maps
Executive Landing
Page
![Page 18: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/18.jpg)
18
Knowledge Delivery: Detail
INFORMATION
GENERATION
Reports, Dashboards, Ad-Hoc Analysis, Alerts
INFORMATION
DISTRIBUTION
Web Portals, Emails,
Extracts, Mobile
![Page 19: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/19.jpg)
19
Customer Segmentation
TRACKPROFILE, DISCOVER
SEGMENT
ACTION
EACH
SEGMENT
![Page 20: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/20.jpg)
20
Analytics
1. Get Data, Build Data
Model
2. Create Snapshots
3. Track Movements
4. Improve Conversions
5. Act in Real Time
![Page 21: Telco bi](https://reader034.vdocuments.us/reader034/viewer/2022042716/55a965df1a28ab40108b47f0/html5/thumbnails/21.jpg)
21
Analytics Framework
• Popular Products
• Related Products
• By Category, Geography, Timeline
PRODUCT
ANALYTICS
• Campaigns On Demand
• Campaign Effectiveness
MARKETING
ANALYTICS
• Micro Segmented Sales
• Sales Performance Management
SALES
ANALYTICS
CUSTOMER ANALYTICS360O
CUSTOMER
VIEW