22-25 April 2026
Video unavailable
SQLBits 2022

Moving away from One Model to rule them all

A data warehouse is a method for providing a single source of truth, but there may be issues on relying on just one model as it does not meet the needs of all users or all types of data. In this session we will explore how to build a data environment which provides flexibility to different groups of users and examples of how to implement different types of technology to provide a broader set of solutions using Azure Synapse, Data lakes and Power BI.
Often times a single data warehouse is meant to be the one solution to provide data to an organization, a method some may describe as the Lord of the Rings Model as there is one model to rule them all. There are a number of different reasons why this approach is not suited to most organizations. Some of the reasons are technical, others include an inability for one model to meet the needs of different groups of users or data types. In this session we will explore how to build a data environment which provides flexibility to different groups of users and examples of how to implement different types of technology to provide a broader set of solutions using Azure Synapse, Data lakes and Power BI.

Feedback Link - https://sqlb.it/?7013