Automation for an Enterprise Datawarehouse in Synapse - Beginner/Intermediate

Synopsis
Star schemas can be very slow to develop and 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 DW Automation to build an EDW that scores almost perfect design scores on Agility, Extensibility, Performance, Design Complexity, Conformity, and Supportability using SQL Dedicated Pools. Concepts are applicable to many other platforms too.

Come along if you are a data professional looking to see how other data architects build and measure architectural principles such as agility and extensibility and a demo of the end result.

Speaker BIO
Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM and now Analysis Services “Maestro” certified.

Bob used to work for Microsoft Consulting Services as a Senior Consultant and subject matter expert for BI/data. He now works at the Prodata SQL Centre of Excellence in Dublin, Ireland where he helps enterprise customers with design, performance tuning, benchmarking, and pretty much anything to do with SQL Server or Business Intelligence.

Organizers Note about Bob
Bob is one of the best in the business when it comes to designing/building and fixing data solutions built on Microsoft Data technologies. He has a vast amount of knowledge and skills and is one of the most engaging speakers on the data tech scene. I believe this is his 6th time speaking at a Cork event, so welcome back Bob.