Create ML Models with BigQuery ML: Challenge Lab Reviews

Roman P. · Reviewed yaklaşık 2 yıl 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 yaklaşık 2 yıl ago

lalit s. · Reviewed yaklaşık 2 yıl ago

Miguel V. · Reviewed yaklaşık 2 yıl ago

Werner v. · Reviewed yaklaşık 2 yıl 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 yaklaşık 2 yıl ago

Bohdan B. · Reviewed yaklaşık 2 yıl ago

Elisdênia S. · Reviewed yaklaşık 2 yıl ago

Volodymyr P. · Reviewed yaklaşık 2 yıl ago

Юлія К. · Reviewed yaklaşık 2 yıl ago

Juandre L. · Reviewed yaklaşık 2 yıl ago

Sachin K. · Reviewed yaklaşık 2 yıl ago

Vladyslav C. · Reviewed yaklaşık 2 yıl ago

juan carlos H. · Reviewed yaklaşık 2 yıl ago

Anton B. · Reviewed yaklaşık 2 yıl ago

Miguel V. · Reviewed yaklaşık 2 yıl ago

Serhii V. · Reviewed yaklaşık 2 yıl ago

Sergey V. · Reviewed yaklaşık 2 yıl ago

Janice V. · Reviewed yaklaşık 2 yıl ago

Suchita B. · Reviewed yaklaşık 2 yıl ago

Maksym K. · Reviewed yaklaşık 2 yıl ago

Максим К. · Reviewed yaklaşık 2 yıl ago

Yuriy K. · Reviewed yaklaşık 2 yıl ago

Atharva D. · Reviewed yaklaşık 2 yıl ago