Case studies

Delivered in demanding environments.

Projects delivered by our technical leadership, directly or in partnership with consultancies. Client names are withheld for confidentiality; further detail can be shared in a meeting, subject to confidentiality agreements.

  • Government
  • Public health
  • Energy
  • Oil & gas
  • Water utilities
  • Semiconductors
  • Automotive
  • Manufacturing
Government Portugal

Data and reporting for a European government ministry

Challenge
Information scattered across systems and management reports assembled manually.
What we delivered
Data engineering and analytics to consolidate sources and deliver reliable management reporting.
  • SQL
  • Data engineering
  • Power BI
Public health Portugal

Prescription analytics for a national health service

Challenge
A complex analytical model that was hard to maintain and slow to answer management questions.
What we delivered
Model refactored into a star schema on Oracle, with Power BI dashboards.
  • Oracle
  • Power BI
  • DAX
  • Dimensional modelling
Health and social care Portugal

Data for a network of health and social care institutions

Challenge
Decentralised information across units and little consolidated visibility.
What we delivered
Data consolidation and management dashboards to monitor the network.
  • Data engineering
  • Power BI
Energy Portugal

Costing models moved from Excel to Power BI for a European energy group

Challenge
Critical costing models relying on large spreadsheets and manual steps.
What we delivered
Models migrated to Power BI, plus data platform work on Microsoft Fabric.
  • Power BI
  • DAX
  • Microsoft Fabric
Oil & gas Switzerland

Data platform for offshore oil & gas groups

Challenge
Operational data locked in legacy ETL and disconnected sources.
What we delivered
Microsoft Fabric/Azure data platform with PySpark pipelines and SSIS modernisation.
  • Microsoft Fabric
  • Azure
  • PySpark
  • SSIS
Water utilities United Kingdom

Data platform for a water and wastewater company

Challenge
Operational and commercial data needed consolidating on a modern platform.
What we delivered
Microsoft Fabric/Azure data platform with pipelines and an analytics layer.
  • Microsoft Fabric
  • Azure
  • PySpark
Semiconductors International

Data engineering for a global semiconductor manufacturer

Challenge
Large volumes of production and business data to integrate.
What we delivered
Pipelines and data models for analytics.
  • Data engineering
  • SQL
  • Python
Automotive Portugal Ongoing

Data for a multinational automotive group

Challenge
Operations spread across several countries and business units.
What we delivered
Data engineering and analytics for group operations.
  • Data engineering
  • Power BI
Manufacturing Brazil

Analytics for a multinational manufacturer

Challenge
Operational and commercial reporting relying on manual work.
What we delivered
Report automation and KPI dashboards.
  • Power BI
  • VBA
  • SQL

Want a similar result in your operation?

Tell us the challenge and we'll show how we'd solve it, with an estimate of the gain.