Creating New BigQuery Datasets and Visualizing Insights
5.0 /5- Offered byCoursera
- Public/Government Institute
Creating New BigQuery Datasets and Visualizing Insights at Coursera Overview
Duration | 11 hours |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
Creating New BigQuery Datasets and Visualizing Insights at Coursera Highlights
- 40% started a new career after completing these courses.
- 43% got a tangible career benefit from this course.
- 14% got a pay increase or promotion.
Creating New BigQuery Datasets and Visualizing Insights at Coursera Course details
- 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.
- >>> By enrolling in this specialization you agree to the Qwiklabs Terms of Service as set out in the FAQ and located at: https://qwiklabs.com/terms_of_service <<<
Creating New BigQuery Datasets and Visualizing Insights at Coursera Curriculum
Introduction
Course Introduction
Qwiklabs Introduction
Recap of Google Analytics ecommerce dataset
Creating Permanent Tables
Demo: Importing JSON Data
Temporary Tables and Query Results
Performance Preview: Query Cache
Creating Logical Views
Lab Overview
Lab Solution
Module Quiz
Ingesting New Datasets into Google BigQuery
Ingesting New Data into BigQuery
Demo: Loading Data into BigQuery
Lab Intro
Lab Solution
Background: Partitioned Tables
Module Quiz
Introducing JOINs and UNIONs
Introducing BigQuery Table Wildcards for Easy Merges
SQL JOIN Syntax
Walkthrough: SQL Join Types
Avoiding Pitfalls when Merging Datasets
Ecommerce Dataset Recap
Lab Intro
Lab Solution
Module Quiz
Data Visualization
Overview of Data Visualization principles
Comparing Good and Bad Visualizations
Dimensions, Measures, and Reports
Introducing Google Data Studio
Demo: Data Studio Walkthrough
Lab Intro
Lab Solution
Building a Monitoring Dashboard
Module Quiz
End of Course Recap
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?