SQLBits 2023

The Metadata Driven Data Warehouse

Tired of writing the same old Insert/Update/Delete statements over and over? Is your pipelines folder overflowing? Need to get your new data warehouse up and running as fast as possible? Metadata (data about data) comes to the rescue and in this session we’ll show you how.
Tired of writing the same old Insert/Update/Delete statements over and over? Is your pipelines folder overflowing? Need to get your new data warehouse up and running as fast as possible? Simply need to figure out what the contents of a table looks like?

Metadata (data about data) comes to the rescue and in this session we’ll show you how.

We’ll walk through the process of building a data warehouse using meta data every step of the way. From analysing what’s in source systems through driving your pipelines and merging new data into the data warehouse all the way up to creating measures in Power BI.

By the end of the session you’ll be ready to start finding new ways to work with your data through the magic of metadata.