Create ML Models with BigQuery ML: Challenge Lab Reviews

Roman P. · Reviewed около 2 лет 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 около 2 лет ago

lalit s. · Reviewed около 2 лет ago

Miguel V. · Reviewed около 2 лет ago

Werner v. · Reviewed около 2 лет 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 около 2 лет ago

Bohdan B. · Reviewed около 2 лет ago

Elisdênia S. · Reviewed около 2 лет ago

Volodymyr P. · Reviewed около 2 лет ago

Юлія К. · Reviewed около 2 лет ago

Juandre L. · Reviewed около 2 лет ago

Sachin K. · Reviewed около 2 лет ago

Vladyslav C. · Reviewed около 2 лет ago

juan carlos H. · Reviewed около 2 лет ago

Anton B. · Reviewed около 2 лет ago

Miguel V. · Reviewed около 2 лет ago

Serhii V. · Reviewed около 2 лет ago

Sergey V. · Reviewed около 2 лет ago

Janice V. · Reviewed около 2 лет ago

Suchita B. · Reviewed около 2 лет ago

Maksym K. · Reviewed около 2 лет ago

Максим К. · Reviewed около 2 лет ago

Yuriy K. · Reviewed около 2 лет ago