100x faster insights from a 600TB data warehouse migration

Client Overview

A leading telecommunications company in Malaysia, serving millions of subscribers, faced growing challenges with its ageing data infrastructure. With a vast amount of critical data, including subscriber information, call records and mobile broadband usage, the organisation needed a modern, scalable solution to enhance decision-making, improve operational efficiency, and stay competitive in a rapidly evolving market.

Objective

The telco company wanted to migrate their data consisting of subscribers, call detail records, and mobile broadband usage, totaling 600 TB, from an aging data lake to a modern data warehouse. This new platform promised significant improvement in data retrieval efficiency and advanced analytics capabilities.

Problem Statement

Due to an ageing data warehouse infrastructure, the organisation faced operational inefficiencies in exploiting its vast data assets. This legacy system, containing 600 TB of critical data (including subscriber information, call detail records, and mobile broadband usage), could no longer support the company’s growing demands for rapid data retrieval and advanced analytics.

To stay competitive and improve decision-making, the telco needed a reliable, scalable data warehouse that could handle large volumes of data, enable faster query performance, and support complex analytics. This would enable the organisation to better understand customer behaviour and optimise network usage.

Solutions

Over 6,000 Database Tables Transferred

• The project involved the careful transfer of over 6,000 database tables, each containing complex, interrelated data vital to customer profiles, call history, network performance, and broadband usage.

More than 1,000 Data Transformation Scripts Reviewed, Optimized, and Migrated

• The migration project entailed a comprehensive review and optimisation of over 1,000 data transformation scripts used to prepare, cleanse, and enrich data for reporting and analytics.

600 TB of Data Migrated

• A total of 600 TB of critical data, spanning subscribers’ profiles, call detail records, and mobile broadband usage metrics, was successfully migrated from the legacy data lake to the new data warehouse.

Results/ Benefits

100x Productivity Boost: Data Queries that Used to Take Hours Now Complete in Seconds

• The migration to a high-performance data warehouse delivered an extraordinary productivity boost, with data query speeds improving by up to 100 times.

Deeper Insights: The Advanced Analytics Capabilities Unlocked Powerful Insights, Leading to a 20% Increase in Customer Retention through Targeted Marketing Campaigns and Personalized Offers

• With the enhanced data warehouse, the telco can now apply advanced analytics and machine learning algorithms to mine deeper insights into customer behaviour, preferences, and service usage patterns. These capabilities have enabled the company to implement highly targeted marketing campaigns and personalised service offers, directly contributing to a notable increase in customer retention by 20%.