Create ML Models with BigQuery ML: Challenge Lab Reviews

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

Miguel V. · Reviewed about 2 years ago

Werner v. · Reviewed about 2 years ago

Task 2 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

Bohdan B. · Reviewed about 2 years ago

Elisdênia S. · Reviewed about 2 years ago

Volodymyr P. · Reviewed about 2 years ago

Юлія К. · Reviewed about 2 years ago

Juandre L. · Reviewed about 2 years ago

Sachin K. · Reviewed about 2 years ago

Vladyslav C. · Reviewed about 2 years ago

juan carlos H. · Reviewed about 2 years ago

Anton B. · Reviewed about 2 years ago

Miguel V. · Reviewed about 2 years ago

Serhii V. · Reviewed about 2 years ago

Sergey V. · Reviewed about 2 years ago

Janice V. · Reviewed about 2 years ago

Suchita B. · Reviewed about 2 years ago

Maksym K. · Reviewed about 2 years ago

Максим К. · Reviewed about 2 years ago

Yuriy K. · Reviewed about 2 years ago

Atharva D. · Reviewed about 2 years ago

Simone S. · Reviewed about 2 years ago