Case Studies Telefónica UK Leverages MicroStrategy for Enhanced Data Insights and Decision-Making

Edit This Case Study Record

	Telefónica UK Leverages MicroStrategy for Enhanced Data Insights and Decision-Making

Telefónica UK Leverages MicroStrategy for Enhanced Data Insights and Decision-Making

Technology Category	Analytics & Modeling - Predictive Analytics Application Infrastructure & Middleware - Data Visualization Functional Applications - Enterprise Resource Planning Systems (ERP)
Applicable Industries	Telecommunications
Applicable Functions	Business Operation Sales & Marketing
Services	System Integration Training
Challenge	Like all communications companies, maximising profitability and efficiency is vital to Telefónica UK as it faces greater competition in the market, customers’ growing use of data and the move to 4G. The company’s vital marketing, sales and service and finance reports were created through a combination of Microsoft Access and Microsoft Excel. This method was limited in terms of speed and the amount of data being processed, since the files became large and slow relatively quickly. Company data was also disparate, with individual reports independently created by various ‘cottage industries’ all around the organisation. To give the business a single source for fast, accurate and detailed insight to help inform decision-making, Telefónica UK decided to implement a new system based on a single Teradata warehouse. Read More
About Customer	Telefónica UK Limited is part of Telefónica Europe plc and uses O2 as its commercial brand in the UK, Ireland, Slovakia, Germany and the Czech Republic. O2 is a leading communications company with over 23 million customers, as well as owning half of Tesco Mobile. It operates 2G and 3G networks and was the first to trial 4G/LTE. O2 employs over 11,000 people in the UK and has around 450 retail stores. Read More
Solution	Telefónica UK’s RFP process included MicroStrategy, SAP BusinessObjects and Cognos. The company chose MicroStrategy based on a number of factors. Firstly, the ability to allow users to drill down from top-level data into greater detail appealed to Telefónica UK, which needed to see what trends were happening and why to react accordingly. Being able to transform data into a simple, easy-to-grasp visualisation was also important, as well as high levels of performance even with large quantities of data. Finally, MicroStrategy’s partnership with Teradata was vital since Telefónica UK was intending to use that company’s data warehouse technology. The solution went live in early 2010 and there are currently 300-350 users. The company has created a pyramid of scorecards reporting on Key Performance Indicators (KPIs) and major product performance. These include customer numbers, revenue, internal and customer satisfaction scores, product holding and corporate responsibility performance. The top-level scorecards provide fundamental statistics on how the business is performing, which the board can access on their iPads. Users can then drill down into further levels of detail depending on the information their area of the business needs. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Predictive Analytics

Application Infrastructure & Middleware - Data Visualization

Functional Applications - Enterprise Resource Planning Systems (ERP)

Applicable Industries

Telecommunications

Applicable Functions

Business Operation

Sales & Marketing

Services

System Integration

Training

Challenge

Like all communications companies, maximising profitability and efficiency is vital to Telefónica UK as it faces greater competition in the market, customers’ growing use of data and the move to 4G. The company’s vital marketing, sales and service and finance reports were created through a combination of Microsoft Access and Microsoft Excel. This method was limited in terms of speed and the amount of data being processed, since the files became large and slow relatively quickly. Company data was also disparate, with individual reports independently created by various ‘cottage industries’ all around the organisation. To give the business a single source for fast, accurate and detailed insight to help inform decision-making, Telefónica UK decided to implement a new system based on a single Teradata warehouse.

About Customer

Telefónica UK Limited is part of Telefónica Europe plc and uses O2 as its commercial brand in the UK, Ireland, Slovakia, Germany and the Czech Republic. O2 is a leading communications company with over 23 million customers, as well as owning half of Tesco Mobile. It operates 2G and 3G networks and was the first to trial 4G/LTE. O2 employs over 11,000 people in the UK and has around 450 retail stores.

Solution

Telefónica UK’s RFP process included MicroStrategy, SAP BusinessObjects and Cognos. The company chose MicroStrategy based on a number of factors. Firstly, the ability to allow users to drill down from top-level data into greater detail appealed to Telefónica UK, which needed to see what trends were happening and why to react accordingly. Being able to transform data into a simple, easy-to-grasp visualisation was also important, as well as high levels of performance even with large quantities of data. Finally, MicroStrategy’s partnership with Teradata was vital since Telefónica UK was intending to use that company’s data warehouse technology. The solution went live in early 2010 and there are currently 300-350 users. The company has created a pyramid of scorecards reporting on Key Performance Indicators (KPIs) and major product performance. These include customer numbers, revenue, internal and customer satisfaction scores, product holding and corporate responsibility performance. The top-level scorecards provide fundamental statistics on how the business is performing, which the board can access on their iPads. Users can then drill down into further levels of detail depending on the information their area of the business needs.

Impact #1	Storytelling dashboards aid better decision-making.
Impact #2	Mobile solution provides access to dashboards anywhere.
Impact #3	Faster, more powerful analytics.

Impact #1

Storytelling dashboards aid better decision-making.

Impact #2

Mobile solution provides access to dashboards anywhere.

Impact #3

Faster, more powerful analytics.

Benefit #1	The solution went live in early 2010 and there are currently 300-350 users.
Benefit #2	O2 employs over 11,000 people in the UK and has around 450 retail stores.

Benefit #1

The solution went live in early 2010 and there are currently 300-350 users.

Benefit #2

O2 employs over 11,000 people in the UK and has around 450 retail stores.

Download PDF Version

Overview

Telefónica UK Leverages MicroStrategy for Enhanced Data Insights and Decision-Making

Operational Impact

Quantitative Benefit