From the course: Complete Guide to Google BigQuery for Data and ML Engineers
Join today to access over 25,300 courses taught by industry experts.
Building and evaluating a classification model - BigQuery Tutorial
From the course: Complete Guide to Google BigQuery for Data and ML Engineers
Building and evaluating a classification model
- Now that we've discussed some of the theory and practice around building classification or regression models, let's dive into actually creating some models. We're going to begin by building and evaluating a classification model. So I've navigated to the BigQuery console here, and what we're going to do is at this point I'm going to create a new dataset. I'm going to call it the ML dataset, and we'll use that for our data. So I'm going to create a dataset. and I'll call this ML underscore dataset. And I will use a regional location type and I'll use us-west1, and I'll create the data set. And now I see the dataset is here. And now I'm going to go ahead and create a table in here. And for that I'm going to create a table and I'm going to start with an upload, and the file I'm going to use. So what I have here is two files that I'm going to be using with our classification model. One of them is the SQL statements that I'll be using, but one is called the synthetic cancer dataset. So…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.