This page contains hands-on dbt (Data Build Tool) tutorials. dbt is a powerful open-source technology that enables teams to transform raw data into valuable insights through SQL-based workflows. Here you will find hands-on tutorials and best practices for using dbt effectively. Our dbt tutorials also serve as a resource for anyone preparing for dbt Analytics Engineering Certification Exam.
📘 Introduction dbt Fusion is one of the biggest changes in the dbt ecosystem. If you already know dbt Core, you can think of Fusion as a new engine underneath the familiar dbt workflow. You still write models, define dependencies, configure YAML files, define tests, and build transformation logic in SQL....
📘 Introduction When you start learning dbt, you will quickly come across many new terms: models, materializations, seeds, snapshots, tests, macros, DAGs, packages, profiles, and targets. At first, these concepts can feel confusing, especially if you are new to analytics engineering or modern data pipelines. In this beginner-friendly guide, we’ll...
Exciting News! Our new book has been released! 📕🚀 ➡️ Building Modern Data Pipelines with dbt: From Raw Data to Gold Standard with the Medallion Architecture by Fabian Hanik and Manuel Hanik VIEW ON AMAZON 📕 What is this book about? dbt has become one of the most important tools in the modern...
📘 Introduction In the following you will find a fictional e-commerce dataset. The Deep Learning Nerds Academy Store is a fan shop that offers merchandise inspired by artificial intelligence and data science. Its product range includes hoodies, T-shirts, accessories, and other themed items designed for technology enthusiasts and fans of AI...
📘Introduction In this hands-on dbt tutorial, you'll learn how to use pre-hooks to automate tasks such as creating backup tables before a model runs. Pre-hooks allow you to execute SQL before your dbt model builds, which is useful for auditing, data quality checks, or preparing the environment. 🎓 Preparing...
📘Introduction In this hands-on dbt tutorial, you’ll learn how to configure your sources.yml file to handle multiple environments (DEV and PROD) dynamically using dbt’s powerful target variable. This will ensure that your models always connect to the correct database, based on the environment you are currently working...
📘Introduction When working with dbt (data build tool), YAML files are the backbone of your project’s configuration. They define how dbt behaves, how your models connect to data sources, and how metadata, documentation, and tests are managed. Understanding these YAML files and knowing where they are located within your...
📘Introduction In this hands-on dbt tutorial, you’ll learn how to switch between development (DEV) and production (PROD) environments using target variables in dbt. You’ll see how to dynamically control where your models are built, and easily run commands against different data warehouses — all without changing a single line...
📘Introduction In this hands-on dbt tutorial, you’ll learn how to configure separate development (DEV) and production (PROD) environments to safely build, test, and deploy your data models. We’ll walk through why environment separation matters and how to configure your profiles.yml so you can switch between environments with...