A Practical Dive Into Data Build Tool (dbt)
This learning path is designed to give you practical, hands-on experience with the Data Build Tool so you can use it confidently for creating data modeling and transforming projects.
We start by looking at how to create a dbt project, configure it to communicate with a database, and look at the most crucial feature dbt offers: models. We will then move to more advanced concepts such as Jinja macros, seeds uploading, and testing practices. We will then discuss how to organize a dbt project in a clear and expressive way.
Finally, your newly acquired skills will be put to the test with a lab challenge in which you will be assessed on your ability to perform tasks to create and test models, define schemas, and organize a dbt project.
By the end of this learning path, you're going to be confident when using the Data Build Tool for building data transformation processes. As an added bonus, this path also includes a lab playground in which you can have a go at using Data Build Tool to do whatever you want, and experiment with the tool.
- Understand basic principles of Data Build Tool
- Work with dbt models
- Define models' schemas and tests
- Upload static CSVs (seeds)
- Organize a dbt project
- Data engineers with a focus on data modeling and transformations methodologies
- Data analysts and Analytics engineers that need to extract useful insights from raw data
To get the most out of this learning path, you should have basic knowledge of SQL. Please consider taking our Learn SQL - From Newbie to Ninja learning path to brush up on your SQL skills, if necessary.
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.