Creating New BigQuery Datasets and Visualizing Insights
This is the second course in the Data to Insights course series. Here we will cover how to ingest new external datasets into BigQuery and visualize them with Looker 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. After completing this course, enroll in the Achieving Advanced Insights with BigQuery course.
Buy Now AED 170.99 + VAT
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- Duration 9 hours
- Course by Google Cloud
-
Offered by
About
This is the second course in the Data to Insights course series. Here we will cover how to ingest new external datasets into BigQuery and visualize them with Looker 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. After completing this course, enroll in the Achieving Advanced Insights with BigQuery course.Modules
Introduction
-
2
Videos
2
Videos
- Course Introduction
- Recap of Google Analytics ecommerce dataset
Creating Permanent Tables
-
6
Videos
-
1
ExternalTool
-
1
Assignment
1
Assignment
- Module Quiz
1
External Tool
- Creating Permanent Tables and Access-Controlled Views in BigQuery
6
Videos
- Creating Permanent Tables
- Temporary Tables and Query Results
- Performance Preview: Query Cache
- Creating Logical Views
- Lab Intro: Creating Permanent Tables and Access-Controlled Views in BigQuery
- Getting Started with Google Cloud Platform and Qwiklabs
Ingesting New Data into BigQuery
-
2
Videos
-
1
ExternalTool
-
1
Assignment
1
Assignment
- Module Quiz
1
External Tool
- Ingesting New Datasets into BigQuery
2
Videos
- Ingesting New Data into BigQuery
- Lab Intro: Ingesting New Datasets into BigQuery
Creating and Managing Tables with Partitions
-
1
Readings
-
1
ExternalTool
1
External Tool
- Creating Date-Partitioned Tables in BigQuery
1
Readings
- Background: Partitioned Tables
SQL JOINs and UNIONs
-
7
Videos
-
2
ExternalTool
-
1
Assignment
1
Assignment
- Module Quiz
2
External Tool
- Troubleshooting and Solving Data Join Pitfalls
- Lab: Unioning and Joining Datasets
7
Videos
- Introducing JOINs and UNIONs
- Use table wildcards for easy merges
- Linking data across multiple tables
- SQL Join examples
- Avoiding Pitfalls when Merging Datasets
- Recap of Google Analytics ecommerce dataset
- Lab Intro: Unioning and Joining Datasets
Overview of Data Visualization principles
-
4
Videos
4
Videos
- Overview of Data Visualization principles
- Comparing Good and Bad Visualizations
- Dimensions, Measures, and Reports
- Introducing Looker Studio
Exploring a Dataset in Google Data Studio
-
1
Videos
-
1
ExternalTool
-
1
Assignment
1
Assignment
- Module Quiz
1
External Tool
- Explore and Create Reports with Looker Studio
1
Videos
- Lab Intro: Explore and Create Reports with Looker Studio
Course summary
-
1
Videos
1
Videos
- Course summary
Auto Summary
Unlock the power of BigQuery with Coursera's "Creating New BigQuery Datasets and Visualizing Insights." This foundational course, ideal for IT and Computer Science enthusiasts, teaches you to ingest external datasets and create visualizations using Looker Studio. Master intermediate SQL concepts, including multi-table JOINs and UNIONs, over 540 minutes of immersive content. Available via Starter, Professional, and Paid subscription options, it's perfect for those looking to deepen their data analytics skills.
Google Cloud Training