Create ML Models with BigQuery ML: Challenge Lab Reviews

Guilherme M. · Reviewed 12 months ago

Luiz Antonio C. · Reviewed 12 months ago

Mônica F. · Reviewed 12 months ago

No way to check as done task 4. --busiest bike sharing station in 2019 (based on the number of trips per station in 2019) where the subscriber type is 'Single Trip'. WITH t1 AS ( select start_station_name, count(*) as trips FROM `bigquery-public-data.austin_bikeshare.bikeshare_trips` WHERE EXTRACT(YEAR FROM start_time) = 2019 AND subscriber_type = 'Single Trip' GROUP BY 1 ORDER BY 2 DESC LIMIT 1 ) --predict the average trip duration for all trips from the busiest bike sharing station in 2019 (based on the number of trips per station in 2019) where the subscriber type is 'Single Trip'. SELECT AVG(predicted_duration_minutes) as avg_predicted_duration_minutes, AVG(duration_minutes) as avg_duration_minutes FROM ML.PREDICT( MODEL `qwiklabs-gcp-01-fff487b8bf0c.austin.subscriber_model`, ( SELECT -- label col bkt.duration_minutes AS duration_minutes, --features bkt.start_station_name, EXTRACT(HOUR FROM bkt.start_time) AS start_hour, bkt.subscriber_type as subscriber_type, FROM `bigquery-public-data.austin_bikeshare.bikeshare_trips` bkt WHERE 1=1 AND EXTRACT(YEAR FROM bkt.start_time) = 2019 AND bkt.subscriber_type = 'Single Trip' AND bkt.start_station_name = (select t1.start_station_name from t1) ))

Miguel M. · Reviewed 12 months ago

Arvind P. · Reviewed 12 months ago

Rosana A. · Reviewed 12 months ago

Natalia S. · Reviewed 12 months ago

kirandeep k. · Reviewed 12 months ago

Heejung K. · Reviewed 12 months ago

Noor A. · Reviewed 12 months ago

Kaushik D. · Reviewed 12 months ago

No way to check as done task 4.

Miguel M. · Reviewed 12 months ago

Lavinia S. · Reviewed 12 months ago

Bhavi G. · Reviewed 12 months ago

Yowan N. · Reviewed 12 months ago

No way to check as done task 2.

Miguel M. · Reviewed 12 months ago

Task 3 bogged as it didn't find the trained model

Asitho D. · Reviewed 12 months ago

Edgar D. · Reviewed 12 months ago

Apoorwa A. · Reviewed 12 months ago

Lakshmanan T. · Reviewed 12 months ago

Mateus M. · Reviewed 12 months ago

Ruhi k. · Reviewed 12 months ago

Johannes K. · Reviewed 12 months ago

Rodrigo B. · Reviewed 12 months ago

Lab does not work properly..!!

Lakshmanan T. · Reviewed 12 months ago