QlikView in Orange Business Services: exploring millions of lines of telecom data
ATK
QlikView
Orange Business Services
.png)
Company:
Orange Business Services
Industry:
Telecommunications
Functional areas:
Sales analysis
Financial analysis
Product:
QlikView
About the client company:
Orange Business Services is a global telecom operator and IT services integrator
21,000 employees, 800 of them in Russia, supporting business and government organizations in all aspects of their digital transformation. Has the specialists and experience to solve complex problems.
Russia's only international provider with its own infrastructure
-
3,000 clients in Russia in the financial, oil and gas, retail, transportation and other industries.
-
Offices in 26 cities in Russia, as well as in Kazakhstan, Ukraine and Belarus for convenient interaction.
-
8500 km of our own backbone network: from Moscow to Vladivostok will ensure reliable communication between remote branches.
-
30 proprietary data centers store big data and process it in real time.
Project Objective:
-
Optimizing big data analytics for customer services and billing data
-
The need for multidimensional analysis of large volumes of data
-
Creation of a single corporate service for interactive data analysis
Solution:
Key analytical tasks solved:
-
Key analytical tasks solved:
-
Revenue analysis based on billing data and customer rating
-
Study of voice call margins taking into account a multi-stage costing scheme.
As a result, QlikView allowed to promptly:
-
Identify destinations with negative margins.
-
Identify contracts with negative margins
-
Investigate routing errors and equipment configuration
-
Plan measures to improve traffic margins
-
Monitor data downloads from telecommunication equipment
-
Monitoring of load by the number of calls at intervals of 10/15/30minutes / hour / day
-
Analysis of communication channel utilization in comparison with the previous day/week/month
-
Traffic anomalies detection
The QlikView system is used by financial analysts, specialists of the operator interaction department, Fraud control specialists, as well as specialists of marketing and sales departments
Data Sources:
-
Billing system
-
DPS system
-
Excel files.
Results in numbers:
man-hours
240
automated workstations
120
Results in numbers:
-
QlikView allows you to quickly and flexibly analyze millions of rows of billing data records.
-
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
Screenshots of the solution:
Testimonial:
“QlikView's analytics platform helps us effectively manage our business and improve the quality of service for our customers. With QlikView and ATK Consulting Group, we were able to deploy an analytics platform in a short period of time, which works efficiently with large arrays of billing data. In 2016 we have planned a number of projects to deepen the analytics functionality for further optimization of services and tariffs”
IT Manager, Orange Business Services.
VLADIMIR VALJKOVIC
Video Review
Press release
ATC QLIKVIEW PROJECT IN ORANGE BUSINESS SERVICES RECOGNIZED AS “THE BEST LARGE-SCALE ANALYTICAL SOLUTION 2015”
+7 (495) 134-32-92
consult@atkcg.ru
Russia, 121467, Moscow,
Istrinskaya str. 4, Office 1
Company News
subscribe to our newsletter
