Workshop with Roelant Vos

12th to 14th June 2017 in Cologne, 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 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 - Cologne, Germany

Our workshop will take place in Cologne, Germany.

Venue - Radisson Blu Hotel, Cologne

Located just a few minutes from the historic city center, the Radisson Blu Hotel, Cologne lies directly opposite the famous Koelnmesse trade fair, close to the river Rhine.

The venue is just 1000m (12 Min. walk) or 1 tram station (line 3) from Railwaystation "Köln Messe/Deutz". There are direct long-distance trains to "Köln Messe/Deutz" from Frankfurt Hbf (< 1:15 h) or Amsterdam Centraal (< 3:00 h).

RADISSON BLU HOTEL, COLOGNE
Messe Kreisel 3
50679 Cologne
Germany

Hotel Tel: +49 221 277 20 0
Website: www.radissonblu.com
Mail: Info.Cologne@RadissonBlu.com

Use our Promo Code DVI-Workshop
or this link to book a room.

Pricing

Workshop
  • 3 Days
2.975 (incl. VAT)

€ 2.500 - Net Price

Register





If you have any further questions, contact us:

info@doerffler.com


Copyright: Roelant Vos
Image Sources - Impressum