Challenge

A major European telecom operator needed to phase out 2G and 3G networks while ensuring a smooth transition to 4G and 5G services across multiple countries. The process was hindered by:

• Limited visibility into how many customers were still using legacy networks.

• Manual, inconsistent data handling across regions.

• No clear tracking of device upgrades to 4G/5G.

• Slow, fragmented reporting that delayed strategic decisions.

Solution

Automated Data Pipeline:

Unified Storage & Analysis:

Live Dashboards: 

Looker Studio dashboards provided instant insights into device usage, IoT connections, coverage, and user migration.

Scalable Automation:

Real-time collection, cleaning, and processing of data from all regions using Google Cloud Functions and Python scripts.

Standardized data stored in Google Cloud Storage and analyzed via BigQuery.

Updates triggered automatically with every new file upload, eliminating manual work.

We developed a fully automated, cloud-based monitoring system that streamlined the entire transition process:

Impact

The new system enabled the operator to:

• Access instant updates for faster decision-making.

• Support smarter planning for network shutdowns and resource allocation.

• Save time and effort by removing manual processes.

• Gain clear, consistent insights across multiple countries.

• Strengthen monitoring with monthly trend reports, ensuring smooth customer migration to 4G/5G.

“Monitoring telecom network performance across countries with real-time data and automated reporting.”