Loopskey-logo
Back to content
CourseTechnology

Analyze Customer Reviews with Gemini Using SQL

By External Provider

Price

Free

Go to content

Opens coursera.org in a new tab

Level

INTERMEDIATE

Duration

1 h 30 min

About this course

This is a self-paced lab that takes place in the Google Cloud console. Learn how to use BigQuery Machine Learning with remote models (Gemini) to analyze customer reviews using SQL.

What you will learn

  • Create a Cloud Resource connection in BigQuery. Create the dataset, and tables in BigQuery. Create the Gemini remote models in BigQuery
  • Prompt Gemini to analyze keywords and setiment (positive, or negative) for text based customer reviews and generate a report with the review count
  • Respond to customer reviews. Prompt Gemini to extract a summary and keywords for each customer review image