163 results

1. Course Featured

   Engineer Data for Predictive Modeling with BigQuery ML

   Complete the intermediate Engineer Data for Predictive Modeling with BigQuery ML skill badge to demonstrate skills in the following: building data transformation pipelines to BigQuery using Dataprep by Trifacta; using Cloud Storage, Dataflow, and BigQuery to build extract, transform, and load (ETL) workflows; and …

2. Lab Featured

   Predict Visitor Purchases with a Classification Model in BigQuery ML

   In this lab, you use an available ecommerce dataset to create a classification (logistic regression) model in BigQuery ML that predicts customers' purchasing habits.

3. Lab Featured

   Troubleshooting Common SQL Errors with BigQuery

   In this lab, you use the BigQuery query editor and query validator to troubleshoot common SQL syntax and logic errors.

4. Lab Featured

   Using BigQuery and Cloud Logging to Analyze BigQuery Usage

   In this lab you view the BigQuery logs inside Cloud Logging, set up a sink to export them back into BigQuery, and then use SQL to analyze the logs.

5. Lab Featured

   Build a Data Warehouse with BigQuery: Challenge Lab

   This challenge labs tests your skills in building a data warehouse using BigQuery.

6. Lab Featured

   Explore an Ecommerce Dataset with SQL in BigQuery

   In this lab, you learn how to use BigQuery to find data, query the data-to-insights public dataset, and write and execute queries.

7. Lab Featured

   ETL Processing on Google Cloud Using Dataflow and BigQuery (Python)

   In this lab, you build several data pipelines that ingest and transform data from a publicly available dataset into BigQuery.

8. Lab Featured

   Predict Taxi Fare with a BigQuery ML Forecasting Model

   In this lab, you explore millions of New York City yellow taxi cab trips available in a BigQuery Public Dataset, create a machine learning model inside of BigQuery to predict the fare, and evaluate the performance of your model to make predictions.

9. Lab Featured

   Streaming Analytics into BigQuery: Challenge Lab

   This challenge lab tests your skills and knowledge from the labs in the Streaming Analytics into BigQuery quest. You should be familiar with the content of labs before attempting this lab.

10. Lab Featured

    Deploy a BigQuery ML Customer Churn Classifier to Vertex AI for Online Predictions

    In this lab, you will train, tune, evaluate, explain, and generate batch and online predictions with a BigQuery ML XGBoost model. You will use a Google Analytics 4 dataset from a real mobile application, Flood it!, to determine the likelihood of users returning to the application. You will generate batch predictio…