About this course: This is the second course in the Data to Insights specialization. Here we will cover how to ingest new external datasets into BigQuery and visualize them with Google Data Studio. We will also cover intermediate SQL concepts like multi-table JOINs and UNIONs which will allow you to analyze data across multiple data sources. Note: Even if you have a background in SQL there are BigQuery specifics (like handling query cache and table wildcards) that may be new to you.
Who is this class for: This is course is primarily aimed at new Data Analysts, Business Analysts, and Business Intelligence professionals. It is also intended for Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform.
Created by: Google Cloud
| Basic Info | Course 2 of 4 in the From Data to Insights with Google Cloud Platform Specialization |
| Level | Beginner |
| Commitment | 1 week of study, 5-7 hours/week |
| Language | English |
| Hardware Req | You'll need a desktop web browser to run this course's interactive labs via Qwiklabs. |
| How To Pass | Pass all graded assignments to complete the course. |
| User Ratings |
Preview
Syllabus
WEEK 1
Module 6: Storing and Exporting Data
Create new permanent and temporary tables from your query results
6 videos
- Video: Creating Permanent Tables
- Video: Temporary Tables and Query Results
- Video: Performance Preview: Query Cache
- Video: Creating Logical Views
- Video: Lab 5 Overview
- LTI Item: Lab 5: Creating new Permanent Tables
- Video: Lab 5 Solution
Graded: Module 6 Quiz
Module 7: Ingesting New Datasets into Google BigQuery
Load and create new datasets inside BigQuery
4 videos
- Video: Ingesting New Data into BigQuery
- Video: Demo: Loading Data into BigQuery
- Video: Lab 6 Intro
- LTI Item: Lab 6: Ingesting and Querying New Datasets
- Video: Lab 6 Solution
Graded: Module 7 Quiz
Module 8: Data Visualization
Compare data visualizations and learn how to use Google Data Studio
7 videos
- Video: Overview of Data Visualization principles
- Video: Comparing Good and Bad Visualizations
- Video: Dimensions, Measures, and Reports
- Video: Introducing Google Data Studio
- Video: Demo: Data Studio Walkthrough
- Video: Lab 7 Intro
- LTI Item: Lab 7: Exploring a Dataset in Google Data Studio
- Video: Lab Solution
Graded: Module 8 Quiz
Module 9: Joining and Merging Datasets
Understand the differences between SQL JOINs and UNIONs and when to use each
7 videos
- Video: Introducing JOINs and UNIONs
- Video: Introducing BigQuery Table Wildcards for Easy Merges
- Video: SQL JOIN Syntax
- Video: Walkthrough: SQL Join Types
- Video: Avoiding Pitfalls when Merging Datasets
- Video: Lab 8 Intro
- LTI Item: Lab 8: UNIONING and JOINING Datasets
- Video: Lab 8 Solution
Graded: Module 9 Quiz
FAQs
How It Works
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
Creators
Google Cloud
We help millions of organizations empower their employees, serve their customers, and build what’s next for their businesses with innovative technology created in—and for—the cloud. Our products are engineered for security, reliability, and scalability, running the full stack from infrastructure to applications to devices and hardware. Our teams are dedicated to helping customers apply our technologies to create success.
Pricing
| Purchase Course | |
|---|---|
| Access to course materials | Available |
| Access to graded materials | Available |
| Receive a final grade | Available |
| Earn a shareable Course Certificate | Available |
Ratings and Reviews
UNIONS and JOINS were explained very well here thank you!
An excellent course on BigQuery, supported SQL features and Data Studio for presenting prepared and filtered data. Thank you!
Need more training sessions on api part
Coursera provides universal access to the world’s best education,
partnering with top universities and organizations to offer courses online.
© 2018 Coursera Inc. All rights reserved.
Excelent...