Coursera
Explore
  • Browse
  • Search
  • For Enterprise
  • Log In
  • Sign Up

Creating New BigQuery Datasets and Visualizing Insights

OverviewPreviewFAQsCreatorsPricingRatings and Reviews

HomeInformation TechnologyData Management

Creating New BigQuery Datasets and Visualizing Insights

Google Cloud

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
Google Cloud
Basic Info
Course 2 of 4 in the From Data to Insights with Google Cloud Platform Specialization
LevelBeginner
Commitment1 week of study, 5-7 hours/week
Language
English
Hardware ReqYou'll need a desktop web browser to run this course's interactive labs via Qwiklabs.
How To PassPass all graded assignments to complete the course.
User Ratings
4.6 stars
Average User Rating 4.6See what learners said
Preview
Syllabus
WEEK 1
Module 6: Storing and Exporting Data
Create new permanent and temporary tables from your query results
6 videos
  1. Video: Creating Permanent Tables
  2. Video: Temporary Tables and Query Results
  3. Video: Performance Preview: Query Cache
  4. Video: Creating Logical Views
  5. Video: Lab 5 Overview
  6. LTI Item: Lab 5: Creating new Permanent Tables
  7. 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
  1. Video: Ingesting New Data into BigQuery
  2. Video: Demo: Loading Data into BigQuery
  3. Video: Lab 6 Intro
  4. LTI Item: Lab 6: Ingesting and Querying New Datasets
  5. 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
  1. Video: Overview of Data Visualization principles
  2. Video: Comparing Good and Bad Visualizations
  3. Video: Dimensions, Measures, and Reports
  4. Video: Introducing Google Data Studio
  5. Video: Demo: Data Studio Walkthrough
  6. Video: Lab 7 Intro
  7. LTI Item: Lab 7: Exploring a Dataset in Google Data Studio
  8. 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
  1. Video: Introducing JOINs and UNIONs
  2. Video: Introducing BigQuery Table Wildcards for Easy Merges
  3. Video: SQL JOIN Syntax
  4. Video: Walkthrough: SQL Join Types
  5. Video: Avoiding Pitfalls when Merging Datasets
  6. Video: Lab 8 Intro
  7. LTI Item: Lab 8: UNIONING and JOINING Datasets
  8. Video: Lab 8 Solution
Graded: Module 9 Quiz

FAQs
How It Works
Coursework
Coursework

Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.

Help from Your Peers
Help from Your Peers

Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.

Certificates
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
Rated 4.6 out of 5 of 82 ratings
Héctor Noel Chacón Salazar

Excelent...

LK

UNIONS and JOINS were explained very well here thank you!

Harold Lawrence Marzan Mercado

An excellent course on BigQuery, supported SQL features and Data Studio for presenting prepared and filtered data. Thank you!

VD

Need more training sessions on api part



You May Also Like
Google Cloud
Achieving Advanced Insights with BigQuery
1 course
Google Cloud
Achieving Advanced Insights with BigQuery
View course
Google Cloud
Applying Machine Learning to your Data with GCP
1 course
Google Cloud
Applying Machine Learning to your Data with GCP
View course
Google Cloud
Exploring ​and ​Preparing ​your ​Data with BigQuery
1 course
Google Cloud
Exploring ​and ​Preparing ​your ​Data with BigQuery
View course
Google Cloud
Securing and Integrating Components of your Application
1 course
Google Cloud
Securing and Integrating Components of your Application
View course
Google Cloud
Getting Started With Application Development
1 course
Google Cloud
Getting Started With Application Development
View course
Coursera
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.
Download on the App StoreGet it on Google Play
  • Coursera
  • About
  • Leadership
  • Careers
  • Catalog
  • Certificates
  • Degrees
  • For Business
  • For Government
  • Community
  • Partners
  • Mentors
  • Translators
  • Developers
  • Beta Testers
  • Connect
  • Blog
  • Facebook
  • LinkedIn
  • Twitter
  • Google+
  • Tech Blog
  • More
  • Terms
  • Privacy
  • Help
  • Accessibility
  • Press
  • Contact
  • Directory
  • Affiliates