dbt
Learn

11 March, 2024Virtual

3 days
Virtual
Data Engineering

Welcome to our dbt Learn course! With this open-source piece of magic, you can transform data in warehouses simply with the power of SQL select statements. You will learn about modeling strategies, automated testing, and performance optimization. 

Book this training

Book now

Looking to upskill your team(s) or organization?

Nico will gladly help you further with custom training solutions.

Get in touch

Duration

3 days

Time

13:00 – 17:00

Language

English

Lunch

Excluded

Certification

Yes

Level

Professional

What will you learn?

After the training, you will be able to:

Use SQL select statements to build robust models for your data.

Use Jinja to create scalable and advanced SQL statements. 

Take part in the dbt community by sharing knowledge. 

Key takeaways

dbt Foundations

  1. Build models to shape your data from raw data to transformed data. 
  2. Configure and run tests on your data to meet your expectations. 
  3. Write, generate, and view documentation while you develop.  

dbt Applications

  1. Leverage Jinja and Macros to write DRY code. 
  2. Creator and implement existing packages to create robust, scalable projects.
  3. Deploy your dbt Project to run on a schedule with dbt Cloud. 

Program

The initial two days focus on establishing a solid foundation in analytics engineering. Participants will learn about the pivotal role of an analytics engineer, and delve into distributed dbt norms. They will grasp the fundamentals of dbt and gain proficiency in project design. Additionally, attendees will be taught how to rigorously test transformations and source data, a crucial aspect of data reliability.

The third day of the program concentrates on practical applications of dbt. Attendees will refine their dbt projects, gaining expertise in using Jinja within dbt for more complex transformations. They will also learn how to leverage packages and tasks effectively. The curriculum covers the strategic utilization of dbt Materializations, a key concept in data modeling. Participants will understand the concept of incremental models and discern the scenarios where they offer the most benefit. Moreover, an overview of various data warehouses will be provided, ensuring participants are well-versed in different environments. The day culminates with an exploration of advanced techniques in the field of analytics engineering.

By the end of this program, participants will have acquired a robust skill set in analytics engineering using dbt, enabling them to tackle real-world data challenges confidently.

  • Learn about the role of an analytics engineer 
  • Distributed dbt Learn norms 
  • Fundamentals of dbt and Project Design
  • Learn how to test your transformations and source data 
  • Document your transformations to improve collaboration 
  • Deploy your dbt projects 
  • Polishing your dbt project 
  • Using Jinja within dbt 
  • How to use packages and projects 
  • When and where to use dbt Materializations 
  • Incremental Models and where to use them 
  • Techniques of the trade: Top 10 advanced tips to continue learning

Who is it for?

This training is perfect for anyone wanting to become proficient in data engineering and leverage the power of dbt, especially analytics engineers, data engineers, and BI professionals. The training program will equip you with the knowledge needed to excel in the field of data engineering. 

Requirements

Basic knowledge of data engineering concepts and experience with SQL will be necessary. 

Why should I follow this training?

Build robust data models

Write advanced SQL statements

Leverage Jinja and Macros for efficient code 

Deploy dbt Projects on a schedule

Exam and Certification

After the training you will be invited to complete the dbt Fundamentals quiz, after which you will receive a dbt Fundamentals certification and badge!

What else
should I know?

After registering for this training, you will receive a confirmation email with practical information. A week before the training, we will ask you about any dietary requirements and share literature if you need to prepare.

See you soon!

Course information

All literature and course materials are included in the price. 

All literature and course materials are included in the price. 

After registering for this course, you will receive a confirmation email with practical information. 

Meet the trainer

Lucy Sheppard 

Meet Lucy Sheppard, trainer at Xebia Academy. Lucy is a data science trainer and teaches many Python courses as well as dbt Learn.

Also interesting for you

View all training courses
Developing Data Models with LookML

This course empowers you to develop scalable, performant LookML (Looker Modeling Language) models that provide your business users with the standardized, ready-to-use data they need to answer their questions. Upon completing this course, you will be able to start building and maintaining LookML models to curate and manage data in your organization’s Looker instance.

Data Analytics
View training
Analyzing and Visualizing Data in Looker

In this course, you learn how to do the kind of data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts. Upon completing this course, you will be able to leverage Looker’s modern analytics platform to find and explore relevant content in your organization’s Looker instance, ask questions about your data, create new metrics as needed, and build and share visualizations and dashboards to facilitate data-driven decision-making.

Data Analytics
View training
Data Science Bootcamp

Transform into a certified Data Scientist in just 12 weeks. This boot camp will kick-start your Data Science career with Python.

Lysanne van Beek

Data Science
Python
11 days
Virtual

Next:

25 Jan, 2024

From:

€2625

View training
Advanced Power BI – DAX and Data Modeling

Increased your PowerBI knowledge with DAX & Data Modeling. Get started now!

Juan Manuel Perafan

Data Analytics
Microsoft
PowerBI
2 days
Virtual

Next:

11 – 12 Dec, 2023

From:

€1465

View training
Time Series Analysis & Forecasting

Learn how to extract insights, interpret seasonality and build forecasting models from time series data.

Data Science
4 days
Virtual

Next:

4 Mar, 2024

From:

€1355

View training

Can’t find the course you’re looking for? There’s more!