Predict Visitor Purchases with a Classification Model in BigQuery ML

In this lab you will use a newly available ecommerce dataset to run some typical queries that businesses would want to know about their customers’ purchasing habits.

• GSP229
• Overview
• Set up
• Task 1. Explore ecommerce data
• Task 2. Identify an objective
• Task 3. Select features and create your training dataset
• Task 4. Create a BigQuery dataset to store models
• Task 5. Select a BigQuery ML model type and specify options
• Task 6. Evaluate classification model performance
• Task 7. Improve model performance with Feature Engineering
• Task 8. Predict which new visitors will come back and purchase
• Task 9. Analyze results and additional information
• Task 10. Test your knowledge
• Congratulations!