Introduction To Dbt: Data Modeling For Analysts
Published 7/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.98 GB | Duration: 2h 54m
Published 7/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.98 GB | Duration: 2h 54m
Learn how to use dbt to build custom data models, scale a data warehouse, and develop production-ready data layers.
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
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.
Overview
Section 1: Introduction to dbt
Lecture 1 Getting started with dbt
Lecture 2 Creating our first model in dbt
Lecture 3 Creating our first model in dbt (continued)
Lecture 4 Building the production layer, table references, and our first custom model
Lecture 5 Enhancing our dbt project using jinga and variables
Lecture 6 Merging our code to the main branch, and setting up a job in dbt
Lecture 7 Introduction to dbt docs and persistent docs (BigQuery)
Lecture 8 Introduction to dbt seeds
Lecture 9 Reviewing a complete dbt project (9-figure DTC brand example)
Analysts,Data engineers,Marketers and ops specialists that want to learn how to build data layers in a data warehouse