Take Your Team's dbt Skills to the Next Level
In dbt Advanced, your team will move beyond the basics and master the advanced features and practices that make dbt powerful at scale. You will build scalable, cost-efficient models, implement best practices, deliver production-ready data products, and explore how AI can enhance analytics engineering. Every session is hands-on, real-world, and designed to prepare your team for large-scale production use of dbt.
Capture historical changes with snapshots and load static reference data with seeds. Track evolving business data, manage point-in-time reporting, and strengthen your project foundations.
Create incremental models that process only new or updated data. Implement append and merge strategies to reduce runtimes and optimize performance.
Analyze and minimize the compute and storage costs of your dbt models. Apply techniques to tune model performance, reduce warehouse usage, and build sustainable transformation workflows.
Organize your dbt projects using style and project best practices, folder structures, and modular patterns. Reuse components through dbt Packages and structure your project for team growth and collaboration.
Design governed, trusted dbt models with clear documentation and ownership. Build data products that are easy to maintain, audit, and scale while ensuring quality at every stage.
Discover how AI can automate documentation, testing, and transformation generation. Leverage dbt metadata and real-world examples to integrate AI into your analytics engineering workflow.
This course is ideal for:
6 half-days (recommended) or 3 full days
Virtual or on-site
Live co-instruction (two trainers)
Hands-on labs and exercises
Discover how modern analytics can transform your business. Dive into the essentials of AI-driven data strategies.