Analytical solution for telecom companies "ATK Telecom Analytics"
ATK
Sectoral
Telecommunications
Acknowledgment of ATK's expertise:
QlikView at Orange Business Services - Best Large Scale Analytics Solution 2015
Platforms:
Solution Functionality:
Subscriber base dynamics by period, by category - growth, churn, return Total churn, total change in subscriber base Ranking of subscriber activation/return/outflow factors Possibility to fall into a detailed list of subscribers/contracts by churn rate Ranking of subscribers - ABC, RFM and other types of segmentation Ranking and trending by types of services, divisions, segments of subscriber base Evaluation of support service efficiency and subscriber base activation
Subscriber base analysis
Analysis of tariff migration ARPU by tariff plans (including subscribers who were on the tariff for a partial month) Changes in ARPU and revenue by tariff plan by month
Analysis of tariff plans
Load control by the number of calls at intervals of 10/15/30 minutes / hour / day Analysis of communication channels load in comparison with the previous day/week/month Identification of traffic anomalies
Network analysis
Revenue analysis based on billing data Study of tariff plans and services margins (taking into account the multi-stage costing scheme) in dynamics Revenue analysis by basic and additional services Calculation of ARPU by tariff plans and services Identification of contracts and directions with insufficient/negative margins
Analysis of revenues and ARPU
Flexible client segmentation Prompt evaluation of successful launch of advertising campaigns for effective management of promotion budgets Evaluation of the effectiveness of marketing activities to reactivate subscribers Dynamics and efficiency of marketing expenses by services, regions, plan and budgeted actuals
Marketing Analysis
Screenshots of the solution:
Implementation results:
-
Operational and transparent control of KPIs and increased efficiency of analysts' work;
-
Reduction of time and operational costs for preparation of reports - managerial, financial, billing;
-
Obtaining a convenient analytical basis for the formation of in-demand, highly profitable tariff plans for a specific target audience;
-
Effective management of subscriber growth and churn, tracking of factors affecting subscriber behavior;
-
Prompt detection and investigation of routing and equipment configuration errors, traffic anomalies;
-
Significant reduction of time and labor costs for data analysis for decision-making;
-
Increased efficiency of marketing campaigns and channels due to detailed analysis of incentive campaigns and deeper audience segmentation capabilities.
-
Load control by the number of calls at intervals of 10/15/30minutes / hour / day
-
Analysis of channel utilization in comparison with the previous day/week/month
-
Identification of traffic anomalies
Orange Business Services
-
80+ QlikView users
-
During the pilot project, in just 1.5 days, a solution was developed that allows you to see the value and dynamics of margins for each client, operator, line of business and specific service
Solution News
ATK Consulting Group automates management processes in the company AMT Group
ATK Consulting Group with the participation of MICROSOFT BUSINESS SOLUTIONS held a press conference.
ORANGE BUSINESS SERVICES WILL EVALUATE CUSTOMER MARGINS IN QLIKVIEW
TZ COMMUNICATIONS HAS CHOSEN MICROSOFT AXAPTA TO MANAGE ITS BUSINESS