Nothing found.

BigQuery SQL para GA4

O objetivo deste curso BigQuery para GA4 permite ter conhecimentos de como conectar, gratuitamente, os dados do GA4 ao BigQuery e obter a raw data. Com a raw data conseguimos fazer análises mais aprofundadas e se quisermos ir mais além com a criação de modelos preditivos

Ver certificado

Impacto imediato no desenvolvimento do trabalho com clientes!

Introdução ao BigQuery
  • Overview of SQL and its relevance in data analytics
  • Introduction to BigQuery and its features
Fundamentos de SQL
  • Basic SQL syntax and queries
  • Selecting and filtering data
  • Sorting and grouping data
  • Aggregation functions and grouping data
SQL Intermediário
  • Joins and subqueries
  • Nested fields and How to
  • Unnest them Working with date and time functions in SQL
Google Analytics 4 no BigQuery
  • Connecting to Google 4 data in BigQuery
  • Structure of Google Analytics 4 data in BigQuery
GA4 Hands On
  • Working with GA4 data tables
  • Applying to real-world scenarios
Data Visualization with Looker Studio
  • Connecting Bigquery to Data Studio and creating a report
  • Creating charts, tables, and other visualizations in Data Studio
  • Sharing and collaborating on Data Studio reports