Introduction to dbt: Data Modeling for Analysts

Name: Introduction to dbt: Data Modeling for Analysts
Rating: 3.0 (1 reviews)

Learn how to use dbt to build custom data models, scale a data warehouse, and develop production-ready data layers.

Created byJustin Butlion

Last updated 7/2025

English

What you'll learn

How to setup dbt
How to create models in dbt
How to use jinga, variables and table references to build models quickly
How to push models back into a data warehouse
How to use dbt docs to create documentation on the models that have been developed

Course content

1 section • 9 lectures • 2h 54m total length

Getting started with dbt27:50
Creating our first model in dbt28:57
Creating our first model in dbt (continued)6:28
Building the production layer, table references, and our first custom model22:07
Enhancing our dbt project using jinga and variables24:27
Merging our code to the main branch, and setting up a job in dbt23:51
Introduction to dbt docs and persistent docs (BigQuery)16:57
Introduction to dbt seeds14:36
Reviewing a complete dbt project (9-figure DTC brand example)9:07
Quiz: Introduction to dbt

Requirements

Basic understanding of SQL and databases is required.

Description

Do you want to learn how to build advanced data models within a data warehouse and become more like a data engineer?

The Introduction to dbt: Data Modeling for Analysts course will reach you the fundamentals of the dbt platform and walk you through the exact steps needed to turn raw data into powerful business-ready datasets for analyses and dashboards.

The course covers the following topics:

Getting started with dbt --> How to set up dbt, connect it to your data warehouse and code repository solution.
Building your first data models in dbt --> How to navigate the IDE and start writing SQL-based data models.
How to leverage jinga, variables and other advanced funtionality within dbt.
How to work with Github, set up jobs in dbt, leverage dbt docs and seeds, and more.

At the end of the course you will find a 10 question quiz to help you test your knowledge.

The course moves at a slow to medium pace allowing you to take in the key concepts and get to know the fundamentals of dbt. Go through the videos in order and build on your knowledge through each lesson.

This 3 hour course will give you the knowledge you need to significantly enhance a data warehouse and provide massive value to your employer or clients.

Who this course is for:

Analysts
Data engineers
Marketers and ops specialists that want to learn how to build data layers in a data warehouse