Using BigQuery and Generative AI

Google Cloud is one of the major cloud providers in the world. But did you know it has now integrated Gemini Google's main LLM into it's cloud products. This course is about teaching you how to use Gemini with BigQuery. BigQuery being one of the most powerful SQL data warehouses in the world and it integrates very well with Google Analytics. This course will use public Google Analytics data to help you learn how you can improve your BigQuery usage to be more productive with Generative AI. c

google-cloud-authorized-trainer-img

google-cloud-certified-ml-engineer-img

google-cloud-certified-data-engineer-img

What you will learn
  • The basis of BigQuery
  • How to import data into BigQuery
  • How to use BigQuery with Google Analytics
  • How to build forecasting models using Google Analytics data
  • How to use generative AI to help you build, train, evaluate and predict with these
  • Learn to have Gemini debug, fix and improve your code
  • Customize your prompts for your BigQuery usage
  • Deploy models using BigQuery
  • Have Gemini pre-process and fix your data
  • Have a quick introduction into propensity models and matrix factorization in BigQuery
  • Learn to customize your LLM model to adapt to your needs
  • And more
Curriculum
  1. BigQuery basics
  2. Google Analytics Dataset
  3. Prompt Engineering with BigQuery
  4. Preparing a good forecasting dataset with BigQuery
  5. Building your model with Google's Gemini
  6. Evaluating your model with Gemini
  7. Fine tunning with Gemini
  8. Preparing your model for deployment
  9. Visualizing your results with Gemini and without

In summary, by the end of the program you will have:

Forecasting

Google Cloud

BigQuery ML

AutoML

Gemini

ARIMA