SKILL BENCHMARK
Machine Learning Using SQL with BigQuery ML Competency (Intermediate Level)
- 17m
- 17 questions
The Machine Learning Using SQL with BigQuery ML Competency (Intermediate Level) benchmark measures your ability to work with data using the bq command-line tool, Looker Studio, and DataPrep and train binary and multi-class classification models. You will be evaluated on your recognition of use cases for training clustering models and recommendation systems and time series analysis forecasting, knowledge of the components in an autoregressive integrated moving average (ARIMA) model, and ability to perform time series analysis on data. A learner who scores high on this benchmark demonstrates that they have good experience using the BigQuery framework to perform data analytics.
Topics covered
- balance skewed classes in data
- clean and prepare data in DataPrep
- create and use slots in BigQuery
- delete unwanted columns using DataPrep
- execute commands in Cloud Shell using bq
- 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
- perform hyperparameter tuning on a random forest
- perform K-means clustering on data
- perform multiple time series analysis for different categories
- perform time series forecasting using an autoregressive integrated moving average (ARIMA)
- perform windowing on time series data
- query and visualize data
- run a classification model and adjust it
- split and visualize data in Looker Studio
- visualize time series data in BigQuery
RECENTLY ADDED COURSES
Rating 2.5 of 2 users
(2)
