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.
Learn more
This course is suitable for technology or finance roles managing Google Cloud costs. Learn to set up a billing account, organize resources, and manage access permissions. In hands-on labs, you view invoices and analyze billing data with BigQuery. You also use Google Sheets and create dashboards with Data Studio. You find references from the videos in this Additional Resources document.
Learn more
Complete the introductory Derive Insights from BigQuery Data skill badge course to demonstrate skills in the following: Write SQL queries.Query public tables.Load sample data into BigQuery.Troubleshoot common syntax errors with the query validator in BigQuery.Create reports in Data Studio by connecting to BigQuery data.
Learn more
Earn a skill badge by completing the Get Started with Looker skill badge course, where you learn how to analyze, visualize, and curate data using Looker Studio and Looker.
Learn more
Earn a skill badge by completing the Build a Secure Google Cloud Network skill badge course, where you will learn about multiple networking-related resources to build, scale, and secure your applications on Google Cloud.
Learn more
Complete the introductory Prepare Data for ML APIs on Google Cloud skill badge to demonstrate skills in the following: cleaning data with Dataprep by Trifacta, running data pipelines in Dataflow, creating clusters and running Apache Spark jobs in Managed Service for Apache Spark, and calling ML APIs including the Cloud Natural Language API, Google Cloud Speech-to-Text API, and Video Intelligence API.
Learn more
Earn a skill badge by completing the Set Up an App Dev Environment on Google Cloud skill badge course, where you learn how to build and connect storage-centric cloud infrastructure using the basic capabilities of the following technologies: Cloud Storage, Identity and Access Management, Cloud Functions, and Pub/Sub.
Learn more
Complete the introductory Implementing Cloud Load Balancing for Compute Engine skill badge to demonstrate skills in the following: creating and deploying virtual machines in Compute Engine and configuring network and application load balancers.
Learn more
Creating New BigQuery Datasets and Visualizing Insights
Earned нояб. 6, 2024 EST
Understand Your Google Cloud Costs
Earned окт. 30, 2024 EDT
Derive Insights from BigQuery Data
Earned окт. 23, 2024 EDT
[Deprecated] Get Started with Looker
Earned окт. 2, 2024 EDT
Build a Secure Google Cloud Network
Earned июля 20, 2023 EDT
Prepare Data for ML APIs on Google Cloud
Earned июля 14, 2023 EDT
Set Up an App Dev Environment on Google Cloud
Earned июля 7, 2023 EDT
Implementing Cloud Load Balancing for Compute Engine
Earned июля 7, 2023 EDT