Telefonica Gains Real-time IT Operational Intelligence and Reduces Costs Using Denodo to Create Virtual Performance Dashboards

• Platform as a Service (PaaS) - Data Management Platforms

• Telecommunications

• Business Operation

• Predictive Maintenance
• Real-Time Location System (RTLS)

• Data Science Services

Telefonica, one of the largest telecommunication operators in the world, was facing challenges in managing key performance metrics and reporting across multiple, complex IT and network management systems. Each of these systems had their own dashboards and reports, and it took a team of 20 people to retrieve and consolidate the information and produce reports. The time to produce a report was typically 1 week and changes in sources or management requirements made the task quite difficult. Moreover, there was a complete lack of real-time views of the key operational metrics across systems. In a highly dynamic environment where projects, priorities and problems were changing all the time, IT management was hampered in decision making regarding systems and applications and taking rapid countermeasures to prevent poor service, delayed resolution, or efficient actions to advance priority projects. The system they had was rigid, fragmented and unable to support the integrated ITIL operating and performance management needs of Telefonica's IT management.

Telefonica is one of the largest telecommunication operators in the world having a dominant market presence in Europe and Latin America. The company boasts 278 million customers, 56.7 Billion Euros in annual revenue and over 100 Billion Euro in cumulative infrastructure investments. Several Telefonica business units depend on their central IT department to deliver new applications and maintain existing ones with high service levels to support key product and business initiatives. IT Management had decided to adopt the Information Technology Infrastructure Library (ITIL) framework of best practice processes to deliver high quality IT services at lower cost.

Telefonica selected Denodo because it provided a flexible and unified solution that was easier to build and maintain than other separate technologies. Denodo was able to extract disparate data from IT inventory systems, version control applications, system probe logs, and from multiple files being used in the management tasks to feed a real-time portal for unified, universal access to all the required sources. Denodo Data Virtualization helped to abstract and combine even semi-structured data sources with structured data and integrate sources provided by other departments. For example, some of the policies, business rules, configurations and calculations that had to be carried out to measure KPIs and service levels were contained in Excel files and sources with meta information of the systems. Telefonica also leveraged Denodo's web automation capabilities to access data about the environment and resources from partners and IT service providers from web sources. The solution requires minimal maintenance as the system repairs itself as sources change.

• Telefonica has realized significant operational cost savings and better data quality in addition to real-time views of processes related to incident problems and user performance of software implementations.
• This has enabled the IT Department to efficiently manage resources.
• The use of Denodo to feed data to a virtual dashboard, load information to a data mart, and manage unified data services that correlate information across many network and IT monitoring tools and web-based sources, has provided Telefonica tremendous flexibility compared to rigid ETL and data warehousing tools.

• Report generation time reduced from 1 week to 1 day.
• Manual effort on data integration was cut by 90%.