Machine Learning with BigQuery ML: Training Time Series Forecasting Models

BigQuery ML 2023    |    Intermediate
  • 8 videos | 57m 26s
  • Includes Assessment
  • Earns a Badge
Rating 2.5 of 2 users Rating 2.5 of 2 users (2)
Time series forecasting uses data collected over periodic intervals to understand and analyze how the variable changes over time. Time series analysis is used for forecasting problems, such as demand forecasting and revenue forecasting. The auto-regressive integrated moving average (ARIMA) model is widely used for time series forecasting. In this course, you will see how time series analysis works and how models such as the ARIMA model can help you forecast future values of time-varying data using historical values. You will also learn the differences between stationary and non-stationary time series data. Next, you will load and explore your time series data for store revenue prediction into BigQuery and visualize and explore this data using Looker Studio. Finally, you will use an ARIMA model to make revenue forecasts. You will see how BigQuery ML trains multiple ARIMA models to find the best auto-regressive, differencing, and moving average parameters for your data. You will also perform multiple time-series analysis by forecasting store revenue by region.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Provide an overview of time series analysis
    Visualize time series data in bigquery
    Query and visualize data
  • Perform time series forecasting using an autoregressive integrated moving average (arima)
    Perform windowing on time series data
    Perform multiple time series analysis for different categories
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 52s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 6m 36s
    After completing this video, you will be able to provide an overview of time series analysis. FREE ACCESS
  • Locked
    3.  Loading and Visualizing Time Series Data
    8m 28s
    In this video, you will learn how to visualize time series data in BigQuery. FREE ACCESS
  • Locked
    4.  Exploring and Understanding Data
    11m 52s
    Find out how to query and visualize data. FREE ACCESS
  • Locked
    5.  Fitting an ARIMA Model
    9m 33s
    In this video, discover how to perform time series forecasting using an autoregressive integrated moving average (ARIMA). FREE ACCESS
  • Locked
    6.  Using Windowing for Trend Smoothing
    7m 46s
    Learn how to perform windowing on time series data. FREE ACCESS
  • Locked
    7.  Performing Multiple Time Series Forecasting
    9m 20s
    Discover how to perform multiple time series analysis for different categories. FREE ACCESS
  • Locked
    8.  Course Summary
    1m 58s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.3 of 3 users Rating 4.3 of 3 users (3)
Rating 5.0 of 6 users Rating 5.0 of 6 users (6)
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)