MAKTEL – DW consulting

About the client

As a leading national carrier of electronic communications, Makedonski Telekom AD – Skopje offers its customers a wide array of top excellence telecommunication services and amusing contents within the scope of the fixed network, broadband services and integrated solutions, also including TV over Internet Protocol (IPTV). The Company’s product portfolio includes Internet Protocol – based services, data transfer, sale and lease of equipment and services for system integration.

The challenge

Makedonski Telekom in the business analysis relies on data collected in an extensive corporate data warehouse (DW) system and business intelligence (BI) reporting system that relies on it. DW system also serves as a source of consolidated data to other internal systems.

DW system covers multiple business areas. DW target area is based on HP OneView model, which had to be adapted to MAKTEL’s specific needs.

The solution

Since the beginning of cooperation in 2009, Neos consultants have carried out several projects related to different segments of the data warehouse (DW).

The initial implementation of a data warehouse was performed in two stages. In the first phase, our company’s standard solution Neos BI environment was implemented. It is intended for automating and monitoring the ETL processes, and as a target data warehouse based on HP OneView model. The main source of information at this stage was the Geneva – Convergys’ Information System, in charge of cost calculation and collection within the telecom system, and Intec’s Interconnect system in charge of cost calculation and traffic between different telecom systems.

The second phase included the loading and consolidation of data from heterogeneous sources of various suppliers and technological platforms (MySQL, MS SQL Server and Oracle). Over the time, the data warehouse and OneView HP model upgrades were performed, improving the individual modules and the introduction of new solutions (ICT, CM).

The results

The implemented DW system serves as the basis for different analysis in the areas of segmentation and users analysis, collection, traffic, utilization of network capacities, job orders and other indicators interesting in the Telco industry.

During the implementation and the later projects, knowledge transfer to MAKTEL’s IT service was performed, including working with Neos BI Environment.

By introducing corporate data warehouse, MAKTEL has provided a stable source of data for business intelligence (BI) and other systems necessary for business analysis and decision-making at multiple levels.