Tricolor TV begins an implementation project of the systems of DWH and BI

On November 19, 2013 the consulting company Columbus announced the beginning of an implementation project of the corporate data warehouse and the system of the business analysis for the operator of satellite television of Tricolor TV (National Satellite Company Ltd).

Project Tasks

Tricolor TV it is interested in the full solution for forecast modeling of dynamics of a subscriber base, the operational analysis of key indicators of the company in different cuts, increase in reliability and quality of the processed information. The operator uses the IBM Cognos BI software products and TM1 for implementation of these tasks, the Informatica PowerCenter platform is taken as a technology basis of corporate storage.

Project Progress

"The offer of Columbus was not limited to technical aspect of the project. Along with system implementation of the business analysis and corporate storage we will make a number of organizational changes according to the results of which we will improve quality of analytical work in scales of all organization, - Roman Gotov, the director of information technology of Tricolor TV noted. – At us there is a lot of divisions, each of them developed own approaches and "know-how" in assessment of these or those performance indicators of a company performance. On the basis of these best practices it is possible and it is necessary to construct the uniform unified reporting system. One more direction for development is planning and tracking of efficiency of marketing efforts. During the project we will develop the general principles of corporate planning, the forecast analysis and accounting, having provided thereby the uniform centralized picture about the state of affairs in the company".

The begun project will infringe, first of all, on the interests of commercial directorate, directorate of subscriber services, marketing and financial departments. A system based on IBM Cognos TM1 will help to model and predict dynamics of primary and repeated connections of services [[Tricolor TV (National Satellite Company) |, to analyze impact on the actual indicators of the carried-out and future marketing actions. It is supposed that the created solution will give the chance to the TV-operator to plan and control change of the sizes and activity of a subscriber base in the horizon from one to five years. Afterwards these data will become a basis for preparation of revenues of the budget of the company.

The uniform corporate storage will collect and will arrange actual data about the clients of the operator used by them services, income and expenses of the company which arrive from the systems of billing, registration of new subscribers, accounting, Columbus RSys and other applications. Use of the Informatica PowerCenter ETL tools promotes the accelerated processing and quality improvement of initial analytical data. On the basis of actual data the company will prepare in IBM Cognos BI the reporting on change of a subscriber base in different combinations of indicators, data on activity of dealer sales, income and expenses of the company.

The solution will promote creation of analytics of number of subscribers, connections and repeated connections, average income and the subscriber's value during all lifecycle. Using personal dashboards, the management and the staff of commercial divisions of Tricolor TV will be able to obtain information interesting them in real time, including far off from mobile devices.

Project terms

Tricolor TV expects to complete the project by the fall of 2014.