Building Modern Data Pipelines with dbt: From Raw Data to Gold Standard with the Medallion Architecture

dbt has become one of the most important tools in the modern data stack. It enables data teams to transform raw data into clean, validated, and well-documented datasets using software engineering principles — version control, modularity, testing, and documentation — directly within SQL.This book will take you step by step through building data pipelines from scratch with dbt. You’ll follow a hands-on approach, supported by practical examples and clear visualizations that make complex concepts easy to understand.LEARN DBT FROM SCRATCHMaster the essentials of dbt - from setting up your first dbt project to building efficient data models. Explore advanced features like custom macros, data tests, data contracts, exposures, and managing access with grants.HANDS-ON PROJECTWork through a complete project using a fictional dataset. Implement each step yourself and gain practical, real-world dbt skills along the way.MEDALLION ARCHITECTURELearn how to structure your project with the Medallion Architecture for scalable, high-quality data pipelines. Process your data step by step, from its raw form in the Bronze layer, through the refined Silver layer, into a business-ready format in the Gold layer.PERFECT FOR PROFESSIONALS AND NEWCOMERSThis book is suitable for both beginners and experienced professionals in the data world. A basic understanding of data concepts, as well as some initial experience with SQL, is beneficial in certain sections. The book is intended for:Beginners who want to explore dbt in greater depth and are looking for a hands-on, practical introduction.dbt users who want to extend their knowledge, such as learning how to combine dbt with the medallion architecture or preparing for the dbt Analytics Engineering Exam.Data professionals, such as data engineers, data scientists, and data analysts, who want to discover the potential of dbt as a core transformation and analytics engineering tool.Students and aspiring data professionals who want to learn how end-to-end data projects can be efficiently implemented in practice using dbt.Decision-makers who want to develop and implement an effective, scalable data strategy based on modern analytics engineering principles. Read more