Create ML Models with BigQuery ML: Challenge Lab Reviews

Vlad L. · Reviewed أكثر من سنتين ago

Roman P. · Reviewed أكثر من سنتين 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 أكثر من سنتين ago

lalit s. · Reviewed أكثر من سنتين ago

Miguel V. · Reviewed أكثر من سنتين ago

Werner v. · Reviewed أكثر من سنتين 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 أكثر من سنتين ago

Bohdan B. · Reviewed أكثر من سنتين ago

Elisdênia S. · Reviewed أكثر من سنتين ago

Volodymyr P. · Reviewed أكثر من سنتين ago

Юлія К. · Reviewed أكثر من سنتين ago

Juandre L. · Reviewed أكثر من سنتين ago

Sachin K. · Reviewed أكثر من سنتين ago

Vladyslav C. · Reviewed أكثر من سنتين ago

juan carlos H. · Reviewed أكثر من سنتين ago

Anton B. · Reviewed أكثر من سنتين ago

Miguel V. · Reviewed أكثر من سنتين ago

Serhii V. · Reviewed أكثر من سنتين ago

Sergey V. · Reviewed أكثر من سنتين ago

Janice V. · Reviewed أكثر من سنتين ago

Suchita B. · Reviewed أكثر من سنتين ago

Maksym K. · Reviewed أكثر من سنتين ago