BigQuery for Data Analysts
- Offered byCoursera
BigQuery for Data Analysts at Coursera Overview
Duration | 10 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
BigQuery for Data Analysts at Coursera Highlights
- Earn a certificate of completion
- Add to your LinkedIn profile
BigQuery for Data Analysts at Coursera Course details
- What you'll learn
- Learn the purpose and value of BigQuery, Google Cloud’s enterprise data warehouse, and discuss its data analytics features.
- Analyze, Clean and transform your data in BigQuery with SQL.
- Ingest new BigQuery datasets, and use Connected Sheets and Looker Studio to visualize data insights from BigQuery.
- Use Dataform to develop scalable data transformation pipelines in BigQuery.
- 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
- Note: This course refreshes many basic topics covered in the From Data to Insights specialization about using BigQuery as a data analyst, and also covers new products like Dataform
BigQuery for Data Analysts at Coursera Curriculum
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
Working with functions
Lab intro: Troubleshooting Common SQL Errors with BigQuery
Enrich your queries with UNIONs and JOINs
Lab intro: Troubleshooting and Solving Data Join Pitfalls
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
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
Ingesting new datasets
External data sources
Lab intro: Ingesting and Querying New Datasets
Lab: Creating new Permanent Tables
Lab: Ingesting and Querying New Datasets
Visualizing Your Insights from BigQuery
Module overview
Data visualization principles
Connected Sheets
Lab intro: Connected Sheets Qwik Start
Common data visualization pitfalls
Looker Studio
Lab intro: Explore and Create Reports with Looker Studio
Analysis in a notebook
Lab: Connected Sheets Qwik Start
Lab: Explore and Create Reports with Looker Studio
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
Lab: Create and execute a SQL workflow in Dataform
Summary
Summary
BigQuery for Data Analysts at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?