Success Story

Vodafone Future-Proofs Their Business Model Through Oracle to Teradata DWH Migration

Vodafone Czech Republic embarked on a business model optimization journey, which required a data warehouse (DWH) migration from Oracle to Teradata. This included business critical reports in the domains of  sales, customer care, support, and marketing.

24
reports migrated from the original Oracle Data Warehouse to a new Teradata Enterprise Data Warehouse
7
months lasted the reporting migration project to a new business model
0
business interruption and negative impact

About the Client

Vodafone Czech Republic is a leading telecommunications company offering mobile and fixed services, including voice, data, and digital solutions, to consumers and businesses in the Czech Republic.

Solution

Adastra performed an Oracle to Teradata data warehouse migration for 24 business critical reports. We delivered a complete re-implementation including analyses, development, testing and acceptance.

Success Story

Industry:

Telecommunications

Technology:

Oracle | Quickview | SAP Business Objects | Teradata

Expertise:

BI and Analytics | Data Warehouse Modernization

Date:

March 21, 2023

Even though the project had seemed to be quite straightforward at the very beginning, a number of challenges, especially related to the Business Objects reporting infrastructure and data quality, appeared. I appreciate the proactive approach and communication with business users that was undertaken to resolve these issues. The new reports were put into production and this enabled us to switch off the Original Data Warehouse.
Zdeněk Martinec
Head of Management Information and Business Intelligence, Finance, Vodafone Czech Republic, a.s.

Challenge

Vodafone Czech Republic optimized its business model, and the subsequent new business model meant the transfer of selected activities, especially in the areas of sales, customer care, support, and marketing to new business partners. This change was enabled by a set of data warehouse (DWH) reports that covered information needs, in the areas of performance KPI’s (retention, productivity, contact history, call quality, etc.) and Commissions.

Solution: Oracle to Teradata Migration

Adastra consultants ensured the migration of 24 business critical reports from the original Oracle Data Warehouse to a new Teradata Enterprise Data Warehouse with no business interruption at Vodafone.

We delivered a complete re-implementation including analyses, development, testing and acceptance.

Due to the original DWH decommission, it was necessary to migrate all reports into a new Teradata Enterprise Data Warehouse to sustain business operations.

Unfortunately, fundamental differences in the architecture between the original and new DWH disallowed a simple transfer of required reports. The data  sources for each report were analyzed and, consequently, the reports were redesigned and re-implemented.

The majority of reports were created in SAP BusinessObjects. However, some MS Excel and QlikView reports were also migrated.

Four common BO Universes were assembled during the project:

  • Contact history
  • Call center performance
  • Subscriber value change
  • Adjustments

Impact

The new solution provided a 100% data quality match with the previous one. Adastra consultants ensured the migration of all the reports and successfully handed them over to Vodafone for operations.

All reports related to Vodafone business partners were redesigned and implemented by the Adastra team for the new Teradata Data Warehouse which allowed Vodafone Czech Republic to decommission the original Oracle Data Warehouse. There was no disruption and Vodafone’s business continuity around reporting on the new DWH ran like clockwork.

Need a similar solution?

Contact Form (Sidebar)

Share this story

Read More Success Stories

Need a similar solution? Get in touch with us, we can help.