Course Overview
This course is designed for data analysts who want to learn about using BigQuery for their data analysis needs. Through a combination of videos, labs, and demos, we cover various topics that discuss how to ingest, transform, and query your data in BigQuery to derive insights that can help in business decision-making.
Who should attend
- Data analysts who want to learn how to use BigQuery for their data analysis needs.
Prerequisites
Course Objectives
- Learn the purpose and value of BigQuery, Google Cloud’s enterprise data warehouse, and discuss its data analytics features.
- Analyze large datasets in BigQuery with SQL.
- Clean and transform your data in BigQuery with SQL.
- Ingest new BigQuery datasets, and discuss options for external data sources.
- Review visualization principles, and use Connected Sheets and Looker Studio to visualize data insights from BigQuery.
- Use Dataform to develop scalable data transformation pipelines in BigQuery.
- Use new integrations and assistive capabilities introduced with BigQuery Studio.