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
Upcoming Classes
26 May 2026
09:00:00 - 17:00:00 Australia/Brisbane
Virtual
12 seats left
Seats:
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 UsStarting fromLoading...