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™

Snowflake for Data Engineers

Snowflake for Data EngineersAndreas Kretz

Category: Data processing and analysis
Duration 2 hours 4 minutes 8 seconds
Data Engineering with Hadoop

Data Engineering with HadoopSuyog Nagaokar

Category: Data processing and analysis
Duration 7 hours 3 minutes
Data Engineering on Azure

Data Engineering on AzureKristijan Bakarić

Category: Azure, Data processing and analysis
Duration 1 hour 20 minutes 57 seconds
Becoming a Better Data Engineer

Becoming a Better Data EngineerAndreas Kretz

Category: Data processing and analysis
Duration 1 hour 46 minutes 10 seconds
TensorFlow Developer Certificate in 2023: Zero to Mastery

TensorFlow Developer Certificate in 2023: Zero to Masteryzerotomastery.io

Category: Data processing and analysis
Duration 62 hours 43 minutes 54 seconds
MongoDB Fundamentals

MongoDB FundamentalsAndreas Kretz

Category: MongoDB, Data processing and analysis
Duration 1 hour 23 minutes 19 seconds
Case Study in Causal Analysis

Case Study in Causal AnalysisLunarTech

Category: Data processing and analysis
Duration 2 hours 3 minutes 34 seconds
Modern Data Warehouses & Data Lakes

Modern Data Warehouses & Data LakesAndreas Kretz

Category: Data processing and analysis
Duration 58 minutes 9 seconds
Machine Learning: Natural Language Processing in Python (V2)

Machine Learning: Natural Language Processing in Python (V2)udemy

Category: Python, Data processing and analysis
Duration 22 hours 4 minutes 2 seconds
Case Study in Product Data Science

Case Study in Product Data ScienceLunarTech

Category: Data processing and analysis
Duration 1 hour 4 minutes 47 seconds