Google BigQuery for Marketers and Agencies

About Google BigQuery for Marketers and Agencies

Welcome to

Google BigQuery for Marketers and Agencies

,

By the end of the course, you will be able to:

Explore eCommerce and CRM user-level data in Google Analytics 360 (Project #1)

Visualize active queries and data tables in Google Data Studio (Project #2)

Explore semi-structured data with ARRAY_AGG, UNNEST and STRUCT

Filter values with the WHERE clause to identify insights

Ingest .CSV files and create permanent BigQuery tables

Combine multiple data tables with different types of JOINs - INNER, LEFT and RIGHT

Aggregate data with SUM, COUNT and GROUP BY

Create nested queries by using the WITH clause

What are the students who took the course saying?

_"Very good course that shows you the basics of Google Big Query and its integration with Data Studio. The teacher shows you, step by step, the most important things to know with passion. I recommend this course to anyone who wants to take the first steps in the Big Query World."_ - Massimo _"Very good course! I am glad that I have chosen it. Materials are easy for understanding. I was familiar with SQL before, but never worked with it in BigQuery. Now I know how to do it. Thank you very much!"_ - Mariia _"This course is brilliant! really! I have been collecting data with Google Analytics for a few years. But this course taught how to take that data to the next step and now I can speak to what can be done with this data, and how it can be combined with other data sources etc. I especially like the way Lachezar explains key concepts that helped me put together the puzzle of GA data to BigQuery and from there to data visulization. Thanks Lachezar."_ - Muhammad

Who is the instructor?

Lachezar Arabadzhiev is a digital markitech with 4+ years of experience in performance analytics and data visualization. Lachezar began his career as a digital marketer at Microsoft, but soon transitioned to the measurement and analytics world, where he has had the opportunity to work with major brands such as Air Canada, RBC, Kimberly-Clark, Mazda and HSBC. Lachezar has been working with Data Studio and BigQuery since early 2017 and has built a wide variety of visualizations and automation flows. From performance-based dashboards with joined GMP sources (Google Analytics 360, Campaign Manager and Display & Video 360) to audience-driven segmentation views with user-level eCommerce data. Lachezar is a certified GMP expert and an official speaker at the Canadian Google Data & Analytics Summit, 2018.