2024 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