LLMs write SQL; Humans architect solutions
Why the Advanced dbt-GA4 training is still relevant in the age of LLMs.
Hi,
You’re receiving this because you either signed up for the waitlist or finished the introductory course and asked to be the first to know when the Advanced dbt-GA4 curriculum was ready.
I’ll be the first to admit: this took much longer than I anticipated. I originally planned to launch this a year ago, but I've put about 200 hours into the course to ensure it covers the actual architecture needed for production environments.
The result is finally here: https://caretjuice.com/courses/advanced-dbt-ga4/
Why pay for a course in the age of LLMs?
If you ask an LLM how to customize a model in dbt-GA4, it will probably give you code that "works." But I’ve seen those prompts lead people down "painful" paths—like editing source seeds that break on every update which is actually probably worse than giving you an answer that's outright wrong.
This is why the "Advanced" in this course matters. AI can write the SQL, but the real, career-sustaining value is in understanding the connections between the stakeholders, the cost, and the architecture.
Moving from "Running Scripts" to "Architecting Solutions"
This course uses the dbt-GA4 package as a sandbox to teach professional analytics engineering patterns. Built on my experience as a lead author of the package and dozens of implementations for global B2B SaaS, e-commerce brands, and non-profits, we look at:
- dbt Design Patterns: Learn how to override package internals with intention. Use dbt as it was designed to be used, rather than just patching together snippets.
- The Professional Workflow: Navigating high-stakes IT security reviews and translating vague stakeholder requirements into robust models.
- The Architectural Foundation: Building a stable base across Git, dbt, and BigQuery. I’m not just teaching a specific scenario; I’m giving you the foundation to solve the problems I haven’t even taught yet.
- Production Optimization: Mastering partitioning and clustering, fine-tuning the dbt-GA4 package, and setting up cost monitoring so you can spot optimization opportunities.
Is this right for you?
This is a hands-on track designed for professionals who want to lead the implementation lifecycle. To follow along with the exercises, you will need a live GA4-to-BigQuery export and a billing-enabled Google Cloud project.
You can view the full curriculum and join here: https://caretjuice.com/courses/advanced-dbt-ga4/
Thanks for sticking with me. I can’t wait to see the solutions you architect with these models.
Regards,
Damon Gudaitis
Principal, Caret Juice Data Ltd.
You just read issue #1 of Caret Juice Data Updates. You can also browse the full archives of this newsletter.