Advanced dbt-GA4 Coaching

Current Status

Not Enrolled

Price

$2,699.00

Get Started

This course is currently closed

$2699 USD for 6 Sessions


The Advanced dbt-GA4 Coaching package covers roughly the same content as the Intro and Advanced On-Demand sessions but with customization to suit the learner’s needs and the development environment.

Each week there will be about an hour of homework assigned that needs to be completed before the next session. Coaching students get email support, with the possibility of live support where that makes sense, to ensure that students stay on pace for the next lesson.

Students should have a GA4 property that they want to use with BigQuery and a report that they want to create using this data. Ideally, this report will be something that can’t be done in the GA4 interface, although any report is fine.

Customization can include such things as:

  • Working with different Git providers
  • Working locally instead of dbt Cloud
  • Solving specific reporting challenges
  • Adhering to specific coding standards

Fill out this form for more information or to schedule a call to discuss course options.

Name(Required)
This field is for validation purposes and should be left unchanged.

Course Content

Connect
Set up dbt Cloud or dbt Core as preferred
Set up a Git Repository for dbt
Connect dbt to Google Cloud and Git
Install dbt-GA4 on dbt
Configure
Automate Event and Parameter Discovery
Add GA4 Recommended Events
Add Custom Parameters to Events
Add Custom Events
User Properties, Session Properties, and Query Parameters
Customize
Introduction to Dimensional Modeling
Mapping Business Requirements
Build GA4 Event Fact Table
Partition
Understand BigQuery Partitioning
Partitioning GA4 Event Fact Tables
Optimize
Data Mart Naming Conventions
Bridging Tables with Views
Build a Daily Aggregate Table
Merge
Understanding BigQuery Merge Strategies with dbt
Merging Aggregate tables

Coaching

Learn more about coaching options.

Name(Required)
This field is for validation purposes and should be left unchanged.