Data Analytics with Google Cloud BigQuery and Looker Studio
1 Visualizing Big Quary data as line charts in looker studio
This introductory section focuses on the fundamentals of connecting to data. You learn how to access public datasets (like the GSOD weather data) within BigQuery, run basic SQL queries using aggregation functions, and perform operations across multiple tables. The section culminates in creating your first visualization, a line chart to track global temperature changes over time.
2 Dimensions and column charts in looker studio
This second section moves into more advanced data manipulation and diverse visualization types. It covers:
Joining datasets in BigQuery to combine different data sources.
Using string functions to clean or transform data labels.
Working with dimensions to break down data in line and column charts.
The practical step of updating existing data sources in Looker Studio when your underlying BigQuery data changes.
3 Intermediate SQL transformation and geo charts in looker studio
The final section focuses on geographical analysis and complex data structures. You learn how to build geo charts to visualize data across different countries or regions. A significant portion is dedicated to deconstructing the “anatomy of a complex SQL query,” teaching you how to handle multi-step transformations before the data ever reaches the visualization stage.