With GA4 putting web and behavioural data in a data warehouse into the hands of more analysts than ever before, you may be wondering how to get the best from your data in BigQuery (or any data warehouse), keep costs manageable, and how to give your users the best performance possible. This talk will cover different approaches to data modelling, the trade-offs associated with each approach, and how the dashboard/BI tool you’re using (whether it be Looker or Looker Studio, Tableau, Power BI etc) impacts your data modelling.

The usage of GA4 and BigQuery real-time reports features can be quite challenging, especially in high-traffic volume websites and other demanding environments. For example, assuming that you find a viable solution for a specific project, it is crucial to determine in advance the projected BigQuery expenses, in order to avoid unpleasant surprises. Architecture, data management, limits and quotas on API Requests are also part of this complex equation. Matteo and Roberto will share some real-world solutions for GA4 and BigQuery real-time needs tested with several clients in different industries.