BigQuery ML for Business Analysts
Taught by Dan King, 4x Google Trainer of the Year
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
Course Modules
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
Forecasting for Business Planning
Topics
- Time series forecasting with ARIMA_PLUS
- Revenue and demand forecasting
- Seasonality and trend analysis
- Forecast evaluation and accuracy
Classification & Segmentation
Topics
- Logistic regression for binary outcomes
- Customer churn prediction
- Lead scoring models
- K-means clustering for segmentation
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
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.
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