Gemini in BigQuery for Data Practitioners

Overview

This course demonstrates how to use AI and machine learning models for generative AI tasks in BigQuery. Learners will work through a practical use case involving customer relationship management and follow step-by-step guidance for coding solutions using SQL queries and Python notebooks. The course aims to help data professionals understand and apply Gemini models in BigQuery to solve business problems.

Prerequisites

Participants should have:

• Prior experience with programming languages including SQL and/or Python
• Basic knowledge of machine learning and generative AI

Target audience

This course is designed for:

• Data analysts, data engineers, and other data professionals who wish to use Gemini in BigQuery to boost productivity and understand their unstructured data

Objectives

By the end of this course, learners will be able to:

• Define the features of Gemini in BigQuery that aid the data to-AI pipeline
• Explore data with Insights and Table Explorer
• Develop code with Gemini assistance
• Discover and visualise workflow with data canvas
• Explain the workflow of using AI and machine learning models for predictive and generative tasks in BigQuery
• Create a solution for leveraging Gemini models in BigQuery with SQL queries and Jupyter Notebooks

Outline

Gemini on BigQuery

• Overview of Gemini on Google Cloud
• Overview of Gemini on BigQuery
• Introduction to course use case
• Capabilities of Gemini on Google Cloud and BigQuery

Data Exploration and Preparation

• Data exploration and preparation tools
• Insights and Table Explorer features, benefits, and restrictions
• Data cleaning and pipeline development features in BigQuery

Code Development with Gemini

• Using Gemini for writing code
• Troubleshooting and testing with Gemini
• Prompting best practices

Data Canvas

• Introduction to Data Canvas
• Data Canvas capabilities
• Prompting best practices for Data Canvas

Working with Gemini Models in BigQuery

• BigQuery ML capabilities
• Using Gemini in SQL queries
• Using Gemini in Jupyter Notebooks

Exams and assessments

There are no exams or assessments associated with this course.

Hands-on learning

• Lab: Explore data with Gemini in BigQuery
• Lab: Develop code with Gemini in BigQuery
• Lab: Use Data Canvas to visualise and design queries
• Lab: Analyse customer reviews with SQL
• Lab: Analyse customer reviews with Python Notebook