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 your data.
Overview
Syllabus
- GSP870
- Overview
- Setup and requirements
- Task 1. Open Google Sheets
- Task 2. Connect to a BigQuery dataset
- Task 3. Formulas
- Task 4. Charts
- Task 5. Pivot tables
- Task 6. Using Extract
- Task 7. Calculated columns
- Task 8. Refresh all / Scheduled refresh
- Congratulations!