Machine Learning with BigQuery ML: Building Classification Models
BigQuery ML 2023
| Intermediate
- 13 videos | 1h 47m 1s
- Includes Assessment
- Earns a Badge
Predictive models that output discrete classes or categories are classification models. Classification is widely used in the real world for use cases such as sentiment analysis of text and identifying objects in images. In this course, you will review how classification models can be used to categorize or classify input records. You will learn how metrics such as accuracy, precision, and recall can be used to evaluate classification models and the conditions under which you would choose to use precision and recall over accuracy for model evaluation. Next, you will use the BigQuery command-line tool bq to create a BigQuery dataset and table and load data into that table. You will see how you can run queries and explore your data, all using the command line. You will use Looker Studio for data visualization and DataPrep to clean and prepare your classification data. Finally, you will train a binary classification model and a multi-class classification model. You will improve the model's performance by balancing the records in the different categories and by using hyperparameter tuning to find the best model for your data.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this course
Provide an overview of how classification models work and their use cases
Execute commands in cloud shell using bq
Clean and prepare data in dataprep
Split and visualize data in looker studio
Run a classification model and adjust it
Balance skewed classes in data -
Remove columns with low predictive power
Extract numeric values from text columns
Impute missing values and clean outliers
Compare logistic regression and boosted tree models
Perform hyperparameter tuning on a random forest
Summarize the key concepts covered in this course
IN THIS COURSE
-
1m 42sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
6m 52sAfter completing this video, you will be able to provide an overview of how classification models work and their use cases. FREE ACCESS
-
3. Loading and Exploring Data using the bq Command-line Utility8m 39sLearn how to execute commands in Cloud Shell using bq. FREE ACCESS
-
4. Cleaning and Preparing Data12m 11sFind out how to clean and prepare data in DataPrep. FREE ACCESS
-
5. Running the DataPrep Pipeline and Data Exploration7m 58sIn this video, find out how to split and visualize data in Looker Studio. FREE ACCESS
-
6. Training and Evaluating a Logistic Regression Model10m 30sIn this video, you will learn how to run a classification model and adjust it. FREE ACCESS
-
7. Balancing Skewed Data in Logistic Regression Models9m 21sLearn how to balance skewed classes in data. FREE ACCESS
-
8. Loading Data and Deleting Unwanted Columns7m 47sFind out how to remove columns with low predictive power. FREE ACCESS
-
9. Data Cleaning and Imputing Missing Values10m 31sIn this video, find out how to extract numeric values from text columns. FREE ACCESS
-
10. Extracting Data and Outlier Treatment10m 34sLearn how to impute missing values and clean outliers. FREE ACCESS
-
11. Training Models for Multi-class Classification7m 17sLearn how to compare logistic regression and boosted tree models. FREE ACCESS
-
12. Performing Hyperparameter Tuning of a Random Forest Model11m 30sFind out how to perform hyperparameter tuning on a random forest. FREE ACCESS
-
13. Course Summary2m 11sIn 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.
