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 In this hands-on dbt tutorial, you’ll learn step-by-step how to create a singular test to validate custom business rules using SQL. Unlike built-in generic tests (like unique or not_null), singular tests allow you to write fully customizable SQL logic to enforce strict data quality checks. ✅ Prerequisites ☑️ A...
📘 Introduction In this hands-on dbt tutorial, we’ll walk you step-by-step through how to set up data warehouse grants in dbt, ensuring the right users have access to the right layers and models. 📌 This is a must-know topic for the dbt Analytics Engineering Certification Exam, so mastering it now puts...
📘Introduction In this hands-on dbt tutorial, we’ll walk you step-by-step through how to make your SQL cleaner and more maintainable by using CTEs (Common Table Expressions) instead of deeply nested subqueries. ✅ Prerequisites ☑️ A dbt project set up ☑️ Source data loaded into your data warehouse ☑️ Source configurations defined in sources....
📘Introduction In this hands-on dbt tutorial, we’ll walk step by step through how to apply the Medallion Architecture to a real dataset using dbt. We’ll explore a sample dataset, visualize the dataflow, and move through all layers of the architecture: 1️⃣ 🛬 Landing Layer – Raw data ingestion 2️⃣ 🥉 Bronze...
📘 Introduction In this hands-on dbt tutorial, we’ll walk you step-by-step through how to create, use, and understand macros — one of dbt’s most powerful features for reusing logic and keeping your SQL clean, modular, and DRY (Don’t Repeat Yourself). By the end, you’ll be able to write...
📘 Introduction In this hands-on dbt tutorial, we’ll walk you step-by-step through how to connect dashboards and reports to your dbt DAG using exposures. This makes your data lineage more transparent, keeps stakeholders aligned, and ensures you know exactly how data assets are being consumed. 📌 This is a must-know topic...
📘 Introduction In this hands-on tutorial, we’ll walk step-by-step through scheduling dbt models with Dagster. By integrating Dagster, you can easily orchestrate your dbt workflows and automating model runs. ✅ Prerequisites 🐍☑️ Installed Python 📦☑️Installed Pip 🌐☑️ Created a virtual environment (venv) 🗂️☑️ A dbt project set up 🧪☑️ Existing dbt models defined in your...
📘 Introduction In this hands-on tutorial, we’ll walk you step-by-step through running dbt models directly from the Dagster UI. By integrating dbt with Dagster, you gain an easy way to orchestrate, run, and monitor your models — all from a clean web interface. ✅ Prerequisites 🐍☑️ Installed Python 📦☑️Installed Pip 🌐☑️ Created a virtual...
📘 Introduction n this hands-on tutorial, we’ll walk you step-by-step through the Dagster UI and show you where to find your dbt models, along with important details such as column descriptions, SQL code, and data lineage. ✅ Prerequisites 🐍☑️ Installed Python 📦☑️Installed Pip 🌐☑️ Created a virtual environment (venv) 🗂️☑️ A dbt project set...