hands-on lab

Create Your First dbt (Data Build Tool) Project

Up to 40m
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.
Lab description

Every company that wants to make growth-oriented and customer-satisfying decisions should follow a data-driven strategy. Data provides us with completely objective information about what we are doing, how our business is performing, and how our customers feel about using our product or service. So, it is important to collect data, model it, and then leverage data as effectively as possible. When it comes to the need to model and transform data, there are two main approaches in the data engineering world: ETL (Extract, Transform, Load), and ELT (Extract, Load, Transform).

In the last years, the ELT approach has become very popular because it allows you to load raw data in your database, and then leverage the potential of the database technology in order to model and transform it. There are different technologies that enable the ELT approach, one of the most popular is dbt.

dbt stands for Data Build Tool, and it's a very powerful tool that allows you to start from raw data, apply transformations using SQL and Jinja functions (the synonym is macro), and create tables containing processed data.

In this lab, you will understand what is dbt and why it's super helpful to model and transform data. You will install it and create your first dbt project.

Learning Objectives

Upon completion of this lab, you will be able to:

  • Understand the basic principles of dbt
  • Install and initialize a dbt project

Intended Audience

  • Data engineers with a focus on data modeling and transformations methodologies
  • Developers who need a powerful tool to get insights from raw data


This lab has no prerequisites.

About the author
Learning paths

Stefano studies Computer Science and is passionate about technology. He loves working with Cloud services and learning all the best practices for them. Google Cloud Platform and Amazon Web Services are the cloud providers he prefers. He is a Google Cloud Certified Associate Cloud Engineer. Node.js is the programming language he always uses to code. When he's not involved in studying or working, Stefano loves riding his motorbike and exploring new places.

Covered topics
Lab steps
Understanding the Basic Principles of dbt
Connecting to the dbt Web IDE
Install dbt and Create a New Project