Final Exam: Machine Learning Using SQL with BigQuery ML

WHAT YOU WILL LEARN

• 

  Differentiate between the different kinds of machine learning (ml) models
  

  create and load data into a bigquery table
  

  visualize bigquery data in looker studio
  

  build a random forest regression model
  

  evaluate and understand an ml model
  

  process and split data for training and test
  

  execute commands in cloud shell using bq
  

  balance skewed classes in data
  

  impute missing values and clean outliers
  

  perform hyperparameter tuning on a random forest
• 

  remove columns with low predictive power
  

  split and visualize data in looker studio
  

  run a recommendation model in bigquery
  

  implement hyperparameter tuning on a clustering model
  

  explore and visualize data in bigquery and looker studio
  

  load data from google cloud platform (gcp) into bigquery
  

  perform hyperparameter tuning on a clustering model
  

  query and visualize data
  

  perform multiple time series analysis for different categories
  

  perform time series forecasting using an autoregressive integrated moving average (arima)