SKILL BENCHMARK

Machine Learning Using SQL with BigQuery ML Awareness (Entry Level)

  • 11m 58s
  • 12 questions
Explore all Skills Benchmarks
The Machine Learning Using SQL with BigQuery ML Awareness (Entry Level) benchmark measures your ability to identify how to use BigQuery to work with data and machine learning models. You will be evaluated on your recognition of different kinds of machine learning (ML) models and use cases for regression analysis. A learner who scores high on this benchmark demonstrates that they have a basic understanding of how to use the BigQuery framework to perform data analytics.

Topics covered

  • build a boosted tree regression model
  • build a random forest regression model
  • create and load data into a BigQuery table
  • differentiate between the different kinds of machine learning (ML) models
  • evaluate and understand an ML model
  • outline how BigQuery and BigQuery ML work
  • outline how regression models work and identify their use cases
  • process and split data for training and test
  • process data using DataPrep
  • set up Google Cloud Platform (GCP) and BigQuery
  • train a linear regression model
  • visualize BigQuery data in Looker Studio