Workshop with Roelant Vos

March 2018 in Munich, Germany

Significantly improve your delivery

Learn how model driven design and data integration (ETL) generation principles can be applied for Data Warehouse (DWH) solutions. The techniques you will learn will reduce time to value, and rapidly deliver a tested business solution with a solid and flexible Data Vault foundation.

Leveraging ETL generation techniques greatly reduces time spent on development by understanding patterns, concepts and architecture. Generation improves consistency and reduces the amount of customization, which enables you to spend time adding value elsewhere or improving other components of the design solution and data model.

Is this for me?

The training teaches how to generate ETL for a Data Vault implementation by discussing the Data Vault patterns and their various implementation nuances. These different scenarios are provided in the context of a sample case (model), where each scenario extends the metadata model by adding a new layer of functionality. At the end of the course you will understand how a metadata model can be defined and configured to suit specific needs, but also which exception cases need to be supported and how to value existing available metadata-driven approaches.

This course is relevant for anyone seeking to leverage ‘model-driven-design’ and pattern-based code-generation techniques to accelerate their Data Warehouse/ Business Intelligence programs. As advanced modeling and implementation techniques for Data Vault are also covered, this applies to a wide range of data professionals including BI and Data Warehouse professionals, data modelers and architects as well as DBAs and ETL specialists.

SQL and Biml (BI Markup Language) are used as techniques to generate ETL as they provide a flexible framework to support the training concepts. The ETL generation content used in this training has been developed with automation of development for the Microsoft BI suite in mind, but concepts and approaches covered in the training are directly applicable to other platforms and technology as well.


The training allows for an optional hands-on component which is run each day for one hour after the regular training content. The intent is to support configuring of a personal ETL generation environment and obtaining practical experience using generation techniques. Sample code and data will be provided for this.

Prerequisites

  • Familiarity with Data Vault modelling and architecture, e.g. following the CDVP2 training and certification
  • Understanding of Data Warehouse and ETL development
  • Some scripting / programming experience
  • Optional hands-on sessions only: pre-installed environment with SQL Server 2012, 2014 or 2016, Integration Services and Visual Studio BI Data Tools.

Download Outlines

Course Content

  • Overarching principles: what concepts should a solution support?
  • Data Vault implementation patterns, what kind of considerations are there?
  • What prerequisites need to be in place? (ETL framework, conventions, patterns)
  • How do database-level configurations support your Data Vault?
  • Develop Business Data Vault components from the Raw Data Vault
  • ETL generation - how does this fit in and how do I get started?
  • How does model driven design work, and what does it do for testing?
  • What metadata do you need and where do you store it?
  • How can I leverage virtualisation?
  • How to balance performance issues using helper constructs (e.g. PIT, Bridge)?
  • How can information from a Data Vault be exposed through (virtual) Data Marts?

Your Trainer

Roelant Vos has been active in Data Warehousing and Business Intelligence for more more than 20 years and is working for Allianz Worldwide Partners as the General Manager for Business & Customer Insights in Brisbane, Australia. In a role that is highly focused on analytics, Roelant is working on collecting, integrating, improving and interpreting data to support various business improvement initiatives. Passionate about improving quality and speed of delivery through model-driven design and development automation, he has been at the forefront of contemporary modeling and development techniques for many years. Whenever there is some time updates on these topics are published on his blog.

Location - Munich, Germany

Our workshop will take place in Munich, Germany.

Pricing

Workshop
  • 3 Days
2.975 (incl. VAT)

€ 2.500 - Net Price

Register

This course can’t be booked yet. Please enter your e-mail address and we will send more information to you soon.






If you have any further questions, contact us:

info@doerffler.com


Copyright: Roelant Vos
Image Sources - Impressum