Google BigQuery for Data Analysts

BigQuery for data analysts

• Identify analytics challenges faced by data analysts, and compare big data on-premises versus in the cloud.
• Learn the purpose and value of BigQuery, Google Cloud’s enterprise data warehouse, and discuss its data analytics features.

Exploring and preparing your data with BigQuery

• List common data exploration techniques.
• Review SQL query basics.
• Enrich queries with functions, unions, and joins.
  
  • Lab: Exploring an Ecommerce Dataset using SQL in Google BigQuery
  • Lab: Troubleshooting Common SQL Errors with BigQuery
  • Lab: Troubleshooting and Solving Data Join Pitfalls

Cleaning and transforming your data

• Identify what makes a good dataset.
• Clean and transform data using SQL.
• Clean and transform data with other options.

Ingesting and storing new BigQuery datasets

• Review differences between permanent and temporary data tables.
• Ingest and store new BigQuery datasets.
• Discuss options for external data sources.
  
  • Lab: Creating New Permanent Tables
  • Lab: Ingesting and Querying New Datasets

Visualizing your insights from BigQuery

• Review data visualization principles and common visualization pitfalls.
• Use Connected Sheets and Looker Studio to visualize data insights from BigQuery.
• Discuss running analyses in a Jupyter Notebook.
  
  • Lab: Connected Sheets Qwik Start
  • Lab: Explore and Create Reports with Looker Studio

Developing scalable data transformation pipelines in BigQuery with Dataform

• Use Dataform to develop scalable data transformation pipelines in BigQuery.
• Learn how to get started with Dataform by creating a repository and development workspace.
• Create and execute a SQL workflow in Dataform.
  
  • Lab: Create and Execute a SQL Workflow in Dataform

BigQuery Studio

• Introduce BigQuery Studio.
• Use Duet AI in BigQuery to explain and generate SQL queries.
• Learn about new usability features and integrations with Dataform and Dataplex in the new BigQuery Studio interface.
  
  • Lab: Analyze Data with Duet AI Assistance
  • Lab: Generate Personalized Email Content with BigQuery Continuous Queries and Gemini