Skip to main content
DA-101Axalon Original

BigQuery ML for Business Analysts

Taught by Dan King, 4x Google Trainer of the Year

1 dayIntensiveIntermediateLoading...

Public class policy: Classes run with a minimum of 6 participants. If minimum enrollment isn't reached, you'll be notified 7 days before with options to transfer or receive a full refund.

Overview

Bridge the gap from SQL analyst to AI-enabled analyst. This intensive teaches you to build machine learning models using familiar SQL syntax—no Python required. Learn forecasting, classification, clustering, and text analysis using BigQuery ML, then apply these skills to real business problems.

What You'll Learn

  • Build ML models using SQL syntax in BigQuery
  • Apply forecasting models to business planning
  • Use classification for customer segmentation and churn prediction
  • Perform text analysis on unstructured data
  • Generate AI insights using ML.GENERATE_TEXT

Who Should Attend

Business analysts, data analysts, BI developers, financial analysts

Prerequisites

Intermediate SQL, BigQuery experience helpful

Products Covered

BigQueryBigQuery MLVertex AI

Course Modules

1

BigQuery ML Foundations

Topics

  • ML concepts for analysts (no PhD required)
  • BigQuery ML architecture and capabilities
  • Model types and when to use each
  • The CREATE MODEL syntax
2

Forecasting for Business Planning

Topics

  • Time series forecasting with ARIMA_PLUS
  • Revenue and demand forecasting
  • Seasonality and trend analysis
  • Forecast evaluation and accuracy
3

Classification & Segmentation

Topics

  • Logistic regression for binary outcomes
  • Customer churn prediction
  • Lead scoring models
  • K-means clustering for segmentation
4

Text Analysis & Generative AI

Topics

  • Sentiment analysis on customer feedback
  • Text classification for support tickets
  • ML.GENERATE_TEXT for AI-powered analysis
  • Combining structured and unstructured data
5

Production Workflows

Topics

  • Model deployment and scheduling
  • Monitoring model performance
  • Refreshing models with new data
  • Integrating predictions into reports

Get This Training

No public classes currently scheduled. Express interest below or request private training.

Request Private Session

Course Details

Course Code
DA-101
Duration
1 day
Format
Intensive
Level
Intermediate
Price
Loading...

Questions About This Course?

Contact us for custom scheduling, group discounts, or curriculum customization.

Contact Us
Starting fromLoading...