BigQuery for Data Analysts focuses on the tools and workflows used to analyze, transform, and visualize large datasets with BigQuery on Google Cloud.
Designed for professionals who are fluent in data analytics, this course builds practical knowledge of Google Cloud’s enterprise data warehouse and the tools used to uncover insights from data. You’ll work with SQL to query datasets, prepare data for analysis, and support data-driven decision-making.
This course explores the key fundamentals of data analysis with BigQuery, including:
- Using SQL to analyze, clean, and transform large datasets
- Ingesting new datasets and connecting BigQuery to external data sources
- Visualizing insights with Connected Sheets and Looker Studio
- Using Dataform to develop scalable data transformation pipelines directly in BigQuery
You’ll learn how to move data into BigQuery, and apply visualization best practices to communicate the data and its associated insights clearly to non-technical audiences.
By the end of this course, you’ll be able to query and transform data in BigQuery, connect analytics and visualization tools, and develop scalable data transformation pipelines to support data analysis on Google Cloud.
