The Data Bootcamp: Transform your Data using dbt™

4h 10m 51s
English
Paid

Are you looking for a cutting-edge way to extract load and transform your data? Do you want to know more about dbt™ and how to use it? Well, this is the course for you. Welcome to The dbt Bootcamp: Transform your Data using dbtIn this course you are going to learn all about dbt™, from setting up dbt™ cloud, connecting it to Snowflake or a warehouse of your choice, developing models, creating sources, doing testing, working with the documentation and much more. 

Read more about the course

This course is for beginners, we will go through a realistic project and cover each of the steps mentioned in a practical approach.
dbt™ is a data modelling tool that makes life much easier for analysts and engineers. It allows you to write SQL queries without having to worry about dependencies. dbt™, like traditional databases, is built on SQL, but it has additional functionality built on top of it utilizing templating engines such as JINJA.

This effectively lets you to retrieve, rearrange, and organize your data using additional logic in your SQL. You may then compile and run this code using dbt's™ run command to retrieve just the pieces you need in the transformations. It can also be swiftly coded, tested, and adjusted without having to wait for it to process all your data. In addition to that, it’s automated documentation is a big time saver.

The project we will be working on is about a fictitious company called GlobalMart. GlobalMart sells household items like furniture, office equipment, Appliances and Electronics. They are in the process of hiring a small data team and would like to try out dbt™ for their data transformations. They require some reporting tables about their profits and want to use dbt™ to transform their data to get them what they want.

Watch Online The Data Bootcamp: Transform your Data using dbt™

Join premium to watch
Go to premium
# Title Duration
1 Introduction to the Course 02:47
2 What is dbt? 04:08
3 ELT vs ETL - What is better? 04:46
4 How the Course is Structured 01:57
5 Reading the Project Brief 01:57
6 Setting up dbt Cloud 02:17
7 Setting up Snowflake Data Warehouse 17:53
8 Setting up Github 03:00
9 Connecting to the Database and Github 09:51
10 Initialising dbt Cloud 04:44
11 Taking a Tour of dbt Cloud 17:11
12 Developing Models in dbt 19:13
13 Understanding Modularity and REF Functions in dbt 31:26
14 Working with dbt_project.yml 06:52
15 Working with Sources in dbt 14:00
16 Introduction to Testing in dbt 03:05
17 How to Create Generic Tests in dbt 20:17
18 How to Create Singular Tests in dbt 10:32
19 How to Generate and work with dbt Documentation 16:36
20 How to use JINJA in dbt 13:02
21 How to Create Macros in dbt 13:16
22 How to use Packages in dbt 08:43
23 How to use Seeds (CSV files) in dbt 08:01
24 Deploying on dbt 14:33
25 A Quick Goodbye Note 00:44

Similar courses to The Data Bootcamp: Transform your Data using dbt™

Machine Learning A-Z : Become Kaggle Master

Machine Learning A-Z : Become Kaggle Masterudemy

Category: Python, Data processing and analysis
Duration 36 hours 23 minutes 54 seconds
Statistics Bootcamp (with Python): Zero to Mastery

Statistics Bootcamp (with Python): Zero to Masteryzerotomastery.io

Category: Python, ChatGPT, Data processing and analysis
Duration 20 hours 50 minutes 51 seconds
Python for Data Engineers

Python for Data EngineersAndreas Kretz

Category: Python, Data processing and analysis
Duration 2 hours 21 minutes 18 seconds
Time Series Analysis, Forecasting, and Machine Learning

Time Series Analysis, Forecasting, and Machine Learningudemy

Category: Python, Data processing and analysis
Duration 22 hours 47 minutes 45 seconds
Machine Learning in JavaScript with TensorFlow.js

Machine Learning in JavaScript with TensorFlow.jsudemy

Category: JavaScript, Data processing and analysis
Duration 6 hours 42 minutes 20 seconds
Becoming a Better Data Engineer

Becoming a Better Data EngineerAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 46 minutes 10 seconds
PyTorch for Deep Learning with Python Bootcamp

PyTorch for Deep Learning with Python Bootcampudemy

Category: Python, Data processing and analysis
Duration 17 hours 2 minutes 14 seconds
Deep Learning A-Z™: Hands-On Artificial Neural Networks

Deep Learning A-Z™: Hands-On Artificial Neural Networksudemy

Category: Python, Data processing and analysis
Duration 22 hours 36 minutes 30 seconds
Mathematical Foundations of Machine Learning

Mathematical Foundations of Machine Learningudemy

Category: Python, Data processing and analysis
Duration 16 hours 25 minutes 26 seconds
Machine Learning with Python : COMPLETE COURSE FOR BEGINNERS

Machine Learning with Python : COMPLETE COURSE FOR BEGINNERSudemy

Category: Python, Data processing and analysis
Duration 13 hours 12 minutes 31 seconds