Skip to main content

dbt and Data Vault 2.0

The Ultimate Data Warehousing Workshop

businessman giving presentations at conference room

What to expect

  • Get fluent in using dbt Cloud
  • Gather first-hand insights from our dbt experts
  • Retrieve practical experience in implementing a Data Vault 2.0 solution
  • Discover the benefits and features of Data Vault loading patterns with datavault4dbt
view Dates

Overview

  • In this training you learn to combine both to maximize the potential of your data. You will learn all required features and techniques to create a Data Vault 2.0 powered Data Warehouse from scratch, that leverages dbt Cloud to maximize efficiency.
  • Data Vault 2.0 helps accomplish enterprise vision in Data Warehousing and Information Delivery, through providing a fully pattern-based modeling framework.
  • Dbt is a Data Warehouse Automation Tool that offers full flexibility and a low entry barrier by providing a SQL-first experience.

Outcome

At the end of this course you will be able to start a Data Warehousing project that leverages dbt Cloud and Data Vault 2.0.

Agenda

  • Introduction to dbt Cloud and its workflow
  • Refreshing of basic Data Vault knowledge
  • Discovering dbt Cloud features and immediately use them in a practical Data Vault implementation
  • Build your own dbt Cloud environment with a Data Vault 2.0 powered Data Warehouse

Target Audience

  • Developers
  • Data Analysts
  • Data Scientists
  • Data Architects
  • Project Managers
  • Product Owners
  • Data Modelers
  • ETL Developer
  • Head of DWH

Prerequisites

  • Basic Data Warehouse Knowledge
  • Basic Data Vault Knowledge
  • Basic SQL Knowledge

Technical Requirements

  • A laptop and optionally a mouse
  • Have Chrome installed

UPCOMING Courses

September

tue03sep(sep 3)9:00 amwed04(sep 4)5:00 pmDBT & DATA VAULT 2.0: THE ULTIMATE DATA WAREHOUSING COURSE - (ENGLISH) (SEPTEMBER 2024) – AMSTERDAM– 2 DAYS

Inhouse training available

Our inhouse training option allows you to book a training session exclusively for your team. This is a great opportunity to learn together and have discussions with the trainer about internal matters. It fosters teamwork and collaboration, ensuring that your team is on the same page and working towards a common goal. Book our inhouse training and take your team’s skills to the next level!

Book Inhouse Training

Trainer

Tim has a Bachelor’s degree in Applied Mathematics and has been working as a BI consultant for Scalefree since the beginning of 2021. He’s an expert in the design and implementation of BI solutions, with focus on the Data Vault 2.0 methodology. His main areas of expertise are dbt, Coalesce, and BigQuery.

Tim KirschkeSenior Consultant

Frequently Asked Questions

How long does the training take?

2 full days, from 9am to 5pm.

How many breaks are included?

15 minutes in the morning, 15 minutes in the afternoon, 30 minutes for lunch.

Is there a certification exam included?

No, there is no certification exam included, but you will get a certificate of participation.

Do I have to prepare something for the training?

Due to some corporate firewall restrictions, you might want to check if your work laptop can access https://cloud.getdbt.com/ and https://app.snowflake.com.

What do I have to bring to the training?

You only need to bring a laptop with a charger, a mouse is recommended but not required.

Interested in our Data Warehousing Course?

Contact Us

Profile Photo of Jürgen Dackweiler
JÜRGEN DACKWEILER

SALES MANAGER

Phone: +49 (511) 879 89342
Mobile: +49 (175) 811 0336