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

BigQuery for Data Analysts

via Udacity

Go to class Write review

Details

Go to class

Provider

Udacity
Pricing

Paid Course
Languages

English
Certificate

Certificate Available
Effort

10 hours
Sessions

Self-Paced
Level

Intermediate

Found in

Overview

This course, "BigQuery for Data Analysts," provides a comprehensive introduction to leveraging Google BigQuery for effective data analysis. Starting with foundational concepts, participants will learn how to connect to and load data seamlessly into BigQuery. The course emphasizes best practices for query optimization and cost management, ensuring efficient resource use. Learners will explore advanced techniques for table optimization, including partitioning and clustering, to enhance performance. Additionally, the importance of data governance and access control will be covered. A practical case study, SwiftHaul Logistics, will help reinforce the concepts learned, culminating in a thorough course review.

Syllabus

Course Introduction

Get started with BigQuery for Data Analysts—learn course goals, prerequisites, tools, and set up your cloud environment to begin hands-on analytics in the browser.

BigQuery Foundations

Learn BigQuery basics: creating datasets, tables, and views to analyze big data, reuse queries, and efficiently organize and explore cloud-based data.

Connecting and Loading Data in BigQuery

Learn to connect BigQuery to your data by loading native and external tables, understand use cases for each, and combine sources via SQL joins for rich analytics.

Query Optimization and Cost Management in BigQuery

Learn to manage cost and optimize queries in BigQuery by understanding pricing, using dry-run estimates, and writing efficient queries to process less data.

Table Optimization: Partitioning and Clustering Tables in BigQuery

Learn to optimize BigQuery tables with partitioning and clustering to reduce query costs and boost performance by aligning table structure to common query patterns.

Data Governance and Access Control in Google's BigQuery

Learn how BigQuery ensures data security through default encryption and fine-grained IAM access controls for projects, datasets, tables, and views, supporting robust data governance.

Course Review

Review key skills: managing datasets, connecting data sources, cost management, query optimization, and data governance. Keep practicing and developing your SQL skills.

SwiftHaul Logistics

Build a governed BigQuery analytics warehouse for SwiftHaul Logistics by loading, modeling, and optimizing shipment data to analyze delivery performance, costs, and carriers.