Create ML Models with BigQuery ML: Challenge Lab Reviews

Voosa T. · Reviewed about 2 years ago

Vitalik G. · Reviewed about 2 years ago

Ederson L. · Reviewed about 2 years ago

Ederson L. · Reviewed about 2 years ago

In my first attempt, I used dataset bigquery-public-data.google_analytics_sample.ga_sessions_20160801 for training and bigquery-public-data.google_analytics_sample.ga_sessions_20170801 for evaluation. Due to this the system did not perceive that the task was completed. In the task description, it would be good to specify that the entire dataset bigquery-public-data.google_analytics_sample.ga_sessions_* should be used.

Мар'ян Б. · Reviewed about 2 years ago

Old G. · Reviewed about 2 years ago

Daria T. · Reviewed about 2 years ago

I did everything as described in tasks 2 and 3, but neither of them confirmed the completion. It also seems that in task 4 the existing model has the same name as the model I need to create in task 2.

Мар'ян Б. · Reviewed about 2 years ago

Kostiantyn O. · Reviewed about 2 years ago

Krish M. · Reviewed about 2 years ago

Priyabrata P. · Reviewed about 2 years ago

JONAS JOSE M. · Reviewed about 2 years ago

easy by a single code

Pragyan G. · Reviewed about 2 years ago

Dmytro I. · Reviewed about 2 years ago

Yevhenii O. · Reviewed about 2 years ago

there's no clear acceptance criteria for Task 2 and Task 3, please explain more, thank you

Andriy S. · Reviewed about 2 years ago

Ігор М. · Reviewed about 2 years ago

Sahil S. · Reviewed about 2 years ago

Vlad L. · Reviewed about 2 years ago

Roman P. · Reviewed about 2 years ago

Task 2 for FORM_3 is incorect: it is propose use logical and linear in different part of task. My answer was: CREATE or REPLACE MODEL bqml_dataset.predicts_visitor_model OPTIONS (model_type='logistic_reg') AS SELECT device.operatingSystem, device.isMobile, totals.pageviews, geoNetwork.country, 0 as label FROM `bigquery-public-data.google_analytics_sample.ga_sessions_20170801` WHERE totals.transactions is null UNION ALL SELECT device.operatingSystem, device.isMobile, totals.pageviews, geoNetwork.country, 1 as label FROM `bigquery-public-data.google_analytics_sample.ga_sessions_20170801` WHERE totals.transactions is not null and it is not correct.

Ihor H. · Reviewed about 2 years ago

lalit s. · Reviewed about 2 years ago