Google Skills Courses

Use Functions, Formulas, and Charts in Google Sheets: Challenge Lab

In this challenge lab you demonstrate your knowledge of Google Sheets that you learned from the Use Functions, Formulas and Charts in Google Sheets quest.

• Google Skills
• On-Demand
• Free Online Course

Using BigQuery in the Google Cloud Console

This lab shows you how to query public tables and load sample data into BigQuery using the GCP Console. Watch the following short video <A HREF="https://youtu.be/m0rqccviLNM">Get Meaningful Insights with Google BigQuery</A>.

• Google Skills
• On-Demand
• Free Online Course

Validate Data in Google Sheets

Ensure that your data is valid and prepared for analysis using Google Sheets features and functions to organize, standardize, and clean data.

• Google Skills
• On-Demand
• Free Online Course

Google Meet: Getting Started

Use Google Meet to hold impromptu video meetings, virtual training classes around the world, remote interviews, and much more. After you complete this lab, use any extra time to explore Google Meet features.

• Google Skills
• On-Demand
• Free Online Course

Google AppSheet: Getting Started

Learn how to use Google AppSheet to enable everyone in your organization to build and extend applications without coding.

• Google Skills
• On-Demand
• Free Online Course

Creating Measures and Dimensions Using LookML

In this lab, you will build dimensions and measures and practice these features in LookML to learn different types of dimensions and measures Looker supports.

• Google Skills
• 1 hour
• On-Demand
• Free Online Course

Get Started with Looker: Challenge Lab

This challenge lab tests your skills and knowledge from the labs in the <b>Get Started with Looker<b> quest. You should be familiar with the content of the labs before attempting this lab.

• Google Skills
• On-Demand
• Free Online Course

Connected Sheets: Qwik Start

Connected Sheets, you can analyze billions of rows and petabytes of data in Google Sheets without specialized knowledge of computer languages like SQL. In this hands-on-lab, you will learn how to connect a BigQuery dataset to Google Sheets and analyze yo…

• Google Skills
• 1 hour
• On-Demand
• Free Online Course

Filtering and Sorting Data in Looker

In this lab, you will learn how to filter and sort data, and create looks with Looker.

• Google Skills
• 1 hour
• On-Demand
• Free Online Course

Creating Derived Tables Using LookML

In this lab, you create SQL derived and native derived tables in LookML to define new tables that do not already exist in the underlying database.

• Google Skills
• On-Demand
• Free Online Course

Optimizing Performance of LookML Queries

In this lab, you'll learn the best methods to optimize query performance in Looker.

• Google Skills
• 1-2 hours
• On-Demand
• Free Online Course

Weather Data in BigQuery

In this lab you analyze historical weather observations using BigQuery and use weather data in conjunction with other datasets. This lab is part of a series of labs on processing scientific data.

• Google Skills
• On-Demand
• Free Online Course

Creating dynamic SQL derived tables with LookML and Liquid

In this lab you will learn how to create and update SQL derived tables to generate dynamic values.

• Google Skills
• 1 hour
• On-Demand
• Free Online Course

Explore and Create Reports with Data Studio

In this lab, you learn how to connect Google Data Studio to Google BigQuery data tables, create charts, and explore the relationships between dimensions and measures.

• Google Skills
• On-Demand
• Free Online Course

Modularizing LookML Code with Extends

In this lab you will learn how to modularize LookML code with Extends.

• Google Skills
• 1 hour
• On-Demand
• Free Online Course