This post was originally published on this site
II would like to draw your attention to a special workshop „Data Warehouse Design Patterns – Implementation and Automation“ by Roelant Vos.
With his workshop, Roelant Vos not only teaches theory, but also how you can try out different models and variants for Data Vault using Roelant Vos tools. The tools are all open source and can be downloaded via GitHub in the source code!
Here is a short extract from the description of the workshop:
This Data Warehouse Design Patterns training is relevant for anyone, and everyone, seeking to understand how to leverage ‘model-driven-design’ and ‘pattern-based code-generation’ techniques to accelerate development.
By combining hybrid data modelling (e.g. Data Vault, Anchor and Ensemble Modelling approaches) with a Persistent Historical Data Store, and supporting this with code generation and process automation (‘DevOps’, ‘DataOps’) – we can reduce the repetitive aspects of data preparation whilst maintaining consistency in development
It is, in a way, an evolution in Data Warehouse automation thinking.
Regardless if you work on a Do-It-Yourself (DIY) solution, or have invested in any of the available Data Warehouse Automation (DWA) platforms, the concepts behind design patterns must be deeply understood to get the correct results. Success depends on correct modelling of the information, in combination with adequate application of the patterns – something software simply cannot replace yet.
Ultimately, leveraging code generation and automation techniques allows for a great degree of flexibility because you can quickly refactor and test different modelling approaches to understand which one is the best fit for you. This enables you to spend more time on higher value-adding work, such as improving the data models and delivery of your data.
As advanced modelling and implementation techniques are also covered, this training can be applied to a wide range of data professionals. The intent of the training is, after a brief introduction, to move to implementation and advanced techniques as quickly as possible.
I attended the course myself in June 2019 and can only recommend it. 
The workshop is offered by Trivadis together with Dörffler & Partner, and here you can register for the Roelant Vos workshop:
https://www.trivadis-training.com/de/training/data-warehouse-design-patterns-o-dwh-dp
There are currently very, very few places available. Do not hesitate to register.
