How Duolingo Plans to Reach 100M Users

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

BigQuery for Data Analysts

Google via Google Skills

Go to class Write review
Great Learning Ad

Cybersecurity: Ethical Hacking Fundamentals - Self Paced Online

Learn More → Coursera Ad

Google AI Professional Certificate - Learn AI Skills That Get You Hired

Learn More →

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.

Syllabus

  • Course Introduction
    • Course Introduction
  • BigQuery for Data Analysts
    • Module overview
    • Data analytics on Google Cloud
    • From data to insights with BigQuery
    • BigQuery demo
    • Real-world use cases of companies transformed through analytics on Google Cloud
  • Exploring and Preparing Your Data with BigQuery
    • Module overview
    • Common data exploration techniques
    • Analyze large datasets with BigQuery
    • Query basics
    • Lab intro: Exploring an Ecommerce Dataset using SQL in Google BigQuery
    • Exploring an Ecommerce Dataset using SQL in Google BigQuery
    • Working with functions
    • Lab intro: Troubleshooting Common SQL Errors with BigQuery
    • Troubleshooting Common SQL Errors with BigQuery
    • Enrich your queries with UNIONs and JOINs
    • Lab intro: Troubleshooting and Solving Data Join Pitfalls
    • Troubleshooting and Solving Data Join Pitfalls
  • Cleaning and Transforming your Data
    • Module overview
    • 5 principles of dataset integrity
    • Clean and transform data using SQL
    • Clean and transform data: other options
  • Ingesting and Storing New BigQuery Datasets
    • Module overview
    • Permanent versus temporary data tables
    • Lab intro: Creating new Permanent Tables
    • Creating Permanent Tables and Access-Controlled Views in BigQuery
    • Ingesting new datasets
    • External data sources
    • Lab intro: Ingesting and Querying New Datasets
    • Ingesting New Datasets into BigQuery
  • Visualizing Your Insights from BigQuery
    • Module overview
    • Data visualization principles
    • Connected Sheets
    • Lab intro: Connected Sheets Qwik Start
    • Connected Sheets: Qwik Start
    • Common data visualization pitfalls
    • Looker Studio
    • Lab intro: Explore and Create Reports with Looker Studio
    • Explore and Create Reports with Looker Studio
    • Analysis in a notebook
  • Developing scalable data transformations pipelines in BigQuery with Dataform
    • Module overview
    • What is Dataform ?
    • Getting started with Dataform
    • Demo
    • Lab intro: Create and execute a SQL workflow in Dataform
    • Create and execute a SQL workflow in Dataform
  • BigQuery Studio
    • Module overview
    • What is BigQuery Studio ?
    • Unified analytics
    • Asset management
    • Embedded assistance
    • Demo
    • Lab intro: Analyze Data with Duet AI Assistance
    • Analyze data with Gemini assistance
    • Generate Personalized Email Content with BigQuery Continuous Queries and Gemini
  • Summary
    • Summary
  • Your Next Steps
    • Course Badge

Tags

Reviews

Start your review of BigQuery for Data Analysts

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.