EDW Automation and Design Best Practices by Bob Duffy

Session Title: EDW Automation and Design Best Practices
Speaker: Bob Duffy

Abstract: Star schema can be very slow to develop an expensive to maintain. You need to add a column to a dimension or a new Fact table. Does that take hours, weeks, an entire development sprint, or is this just too expensive to even think about ?

In this session we will recap good design best practices and demo how to use meta data to build an EDW which scores highly on Agility, Extensibility, Performance, Design Complexity, Conformity and Supportability using SQL Dedicated Pools in Synapse. Concepts are applicable to many other platforms too.

Come along if you are a data Architect or Engineer looking to see how we build for and measure architectural principles such as agility and extensibility.