Create ML Models with BigQuery ML: Challenge Lab Reviews

curian L. · Reviewed ما يقرب من 5 سنوات ago

Ronny M. · Reviewed ما يقرب من 5 سنوات ago

Tejas D. · Reviewed ما يقرب من 5 سنوات ago

XinYang Y. · Reviewed ما يقرب من 5 سنوات ago

Jun Liang Y. · Reviewed ما يقرب من 5 سنوات ago

Namya V. · Reviewed ما يقرب من 5 سنوات ago

Final prediction task doesn't support inline query solution as below even though the solution is correct. SELECT AVG(predicted_duration_minutes) as average_predicted_trip_length FROM ML.PREDICT(MODEL bike.duration_model_2, (SELECT trips.duration_minutes, trips.start_station_name, trips.start_time, trips.subscriber_type FROM `bigquery-public-data.austin_bikeshare.bikeshare_trips` trips INNER JOIN (SELECT start_station_name, COUNT(*) AS trips FROM `bigquery-public-data.austin_bikeshare.bikeshare_trips` WHERE EXTRACT (YEAR from start_time) = 2019 GROUP BY start_station_name ORDER BY trips DESC LIMIT 1) busy_station on busy_station.start_station_name = trips.start_station_name WHERE EXTRACT (YEAR from trips.start_time) = 2019 AND trips.subscriber_type = "Single Trip") )

Patrick C. · Reviewed ما يقرب من 5 سنوات ago

For the prediction part, the 2020 data does not include any records when subscriber_type = 'Single Trip'. It only include records for 'Single Trip Ride'

Keith K. · Reviewed ما يقرب من 5 سنوات ago

Deri D. · Reviewed ما يقرب من 5 سنوات ago

Zhi Jian C. · Reviewed ما يقرب من 5 سنوات ago

Chong Chi Y. · Reviewed ما يقرب من 5 سنوات ago

Yayan S. · Reviewed ما يقرب من 5 سنوات ago

SINHAN C. · Reviewed ما يقرب من 5 سنوات ago

Broken assessment checker in Task 4: Evaluate the two machine learning models

Allan Khaw -. · Reviewed ما يقرب من 5 سنوات ago

Yayan S. · Reviewed ما يقرب من 5 سنوات ago

Aishah S. · Reviewed ما يقرب من 5 سنوات ago

ava g. · Reviewed ما يقرب من 5 سنوات ago

Mikołaj B. · Reviewed ما يقرب من 5 سنوات ago

HY Y. · Reviewed ما يقرب من 5 سنوات ago

nisha r. · Reviewed ما يقرب من 5 سنوات ago

Got bug, the busiest station is different

Yousoff E. · Reviewed ما يقرب من 5 سنوات ago

Andrea F. · Reviewed ما يقرب من 5 سنوات ago

nisha r. · Reviewed ما يقرب من 5 سنوات ago

Yan Y. · Reviewed ما يقرب من 5 سنوات ago

Jing Xiang G. · Reviewed ما يقرب من 5 سنوات ago