The Challenge

To help the client realize their objective of transforming their existing warehouse built on a traditional data technology stack to a modern Lakehouse, we designed and implemented a solution built on Data bricks, Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, Python and Power BI.

Key Features

• Management of feeds from multiple data sources

• Multiple domain-specific rules-based calculation engines

• Near real-time data refresh with full audit trail and transaction history

• Extensive query and analysis functionality, including transaction drill-through

• Integration with existing Microsoft Excel and Power BI tools

• The Outcome

By moving the client to a cloud only architecture we achieved significant cost control and a flexible data warehouse which can scale on demand and flex to ever changing business needs.

Key Results

• Significant cost control

• Flexible data warehouse scaling

• Streamlined regulatory reporting