2025 Mastering dbt (Data Build Tool) - From Beginner to Pro

🎓 Unlock the Full Potential of dbt with the 2024 Mastering dbt Bootcamp! 🚀

Course Overview 🧐

Instructor Introduction

Jack Cook here, with over 8 years of experience in Analytics, Analytics Engineering, and Data Science, including a pivotal role in the rollout of dbt at Monzo Bank. I've distilled my extensive knowledge into this hands-on course to elevate your dbt skills from novice to expert.

Course Approach 🛠️

Master dbt the Practical Way: This isn't your typical theoretical marathon. We dive straight into practical applications, focusing on achieving advanced dbt proficiency swiftly. Each code-along session comes with lesson attachments and accompanying theory to solidify your learning experience. 📚✨

Dynamic Learning Experience 🌐

Evolving Content: Your feedback is crucial! This course is not set in stone; it's a living resource that will evolve with your input and the ever-changing landscape of dbt. Let's grow together!

Course Structure 📋

We'll embark on a structured journey through the world of dbt, starting from the basics to deploying our project on dbt Cloud. Here's how we'll break it down:

1. Introduction to dbt: Understanding the role of dbt and its impact on data stacks.

   • Theory (< 1 hour)

2. Tool Setup: Getting you ready with Python, GitHub, Google BigQuery, VSCode, and dbt.

   • Skip ahead if you're already familiar!

3. Building Our Basic dbt Project: Starting from scratch to create staging (stg), intermediate (int), and mart data models with proper documentation and testing.

4. Advanced dbt Testing: Enhancing our basic project with sophisticated tests, including using external packages for advanced test cases.

5. Advanced Data Modelling with dbt: Diving into reusable documentation, seed files, snapshots, and materialisation methods, focusing on incremental and ephemeral models with dbt version 1.5's governance features.

6. Advanced dbt Commands: Mastering the key dbt commands for project management and maintenance.

7. Advanced Jinja & Macros: Unlocking the power of Jinja to create custom macros for hooks, operations, and SQL models, with insights into common pitfalls and best practices.

8. dbt Cloud Deployment: Learning how to deploy and schedule your dbt project on dbt Cloud for seamless integration and automation.

What You'll Learn 🖥️

• Tool Setup: The foundational tools you need for a smooth dbt experience.
• Basic to Advanced dbt Skills: A comprehensive journey from the fundamentals to mastery.
• Data Modelling Techniques: Best practices in data modelling with dbt's powerful features.
• Automation and Deployment: How to automate your workflow and deploy it on dbt Cloud.
• Customisation and Optimisation: Using Jinja macros to enhance your dbt project's performance and scalability.

Embark on this transformative journey with dbt today, and prepare to become a dbt expert! 🌟 Join us and let's turn data into wisdom together. #dbtMasterclass #DataEngineering #AnalyticsEngineering