Public Sector • Azure Data Engineering

Data Lake Creation for a Public Sector Body

Built a data lake on Azure with ingestion, transformation and loading processes to centralise data for the organisation.

Ref: DMSFT103002

Video story · 1:01

The challenge

The organisation needed a data lake to bring its data together in a central, governed environment.

The approach

Kumulus structured ingestion, transformation and loading processes with validation, traceability and failure handling, using Microsoft Azure, APIs, ETL/ELT and SQL.

The outcome

Public-sector analytics now has a centralised, traceable data foundation for reporting. The Azure lakehouse brings together up to five SQL Server tables and data from two judicial APIs, with validated ingestion and transformation.

Built on Azure Powered by

Could this work for your organisation?

The AI Audit shows where data and AI will deliver measurable value for you first.