Prerequisites
- SQL basics appreciated; no mandatory BigQuery prerequisite.
- Access to a sandbox project or sample datasets.
Duration
Modular pathway (full day or half-day format) with a custom forfait defined during scoping.
Access & timelines
Register via the contact form or email formation@woptimo.com; program and schedule are confirmed after a short call with a trainer.
Learning objectives
- Structure datasets, tables, and views to support BI and marketing use cases.
- Write robust analytical SQL (joins, windows, deduplication).
- Optimize costs and performance (partitioning, clustering, monitoring).
- Expose data to BI or activation (Looker Studio, Reverse ETL).
Training outline
- Getting started with BigQuery: dataset, tables, partitioning, and clustering
- Analytical SQL: joins, windows, aggregates, deduplication
- GA4 export schema: events, user_properties, ecommerce
- Cost and performance optimization, monitoring
- Exports to BI and activation (Looker Studio, Reverse ETL)
Training methods
- Live demos in BigQuery and guided exercises.
- Case studies on GA4 exports and marketing datasets.
- Materials, SQL snippets, and FinOps best practices.
Evaluation
Quiz, corrected SQL exercises, and review of an optimized query at the end.
Accessibility
Support and pace can be adapted; on-site sessions in accessible venues on request. Disability point of contact: handicap@woptimo.com.
Contacts & last update
formation@woptimo.com | contact form. Updated on December 10, 2025.
