Skip to main content

Select your location

A data funnel for financial reporting

Media and telecommunications company

User looking at financial data graphs on a tablet device

Bringing the numbers together

  • Category: Data and Analytics

Our client is a provider of subscription television, internet and mobile services. It has an international reach totalling over 22 million customers, and a history of developing innovative products and entertainment content.

Financial analysis is a major factor in the client’s continuing success which, in turn, depended on a robust source of data. We were tasked with providing this single source of data (from a wide variety of locations) that would be easily accessible, trusted, and spanned all aspects of the business. This data also needed to be presented in an easily interpretable format for analysis and visualisation in Tableau.

From warehouse to cloud

To achieve this required us to migrate processes and business logic from a legacy data warehouse to a more effective cloud solution.

We embedded our experts within the in-house team and primarily focused on making changes and additions rapidly and flexibly in response to pressing needs. We also focused on knowledge transfer and upskilling internal analysts to better self-serve data.

Pipelines were constructed in Google Cloud Platform (GCP) using Apache Airflow DAGs to schedule an orchestrated data flow. BigQuery was used to transform, process and store data in excess of 40Tb. GCPComposer and Github were used for rigorous testing and analysis. Data quality was monitored with the Great Expectations Python package.

Better decisions all round

Our work has led to increased usage of data informed decision making within the organisation. Robust automated pipelines pull rich data together from a wide range of sources across the business including the huge customer base.

The Table delivered is used by several client teams downstream for business-critical reporting, insight analytics and prediction models. The Dataset is also used in a wide range of applications: from financial reporting and powering predictive Machine Learning models, all the way to informing board level decisions about pricing.

Good data in, good data out. Unlock the value of data.

Contact us