Create ML Models with BigQuery ML: Challenge Lab Reviews

impossible to finish task 2 and chat support dosn't help

Roberto T. · Reviewed בערך שנה אחת ago

Peter K. · Reviewed בערך שנה אחת ago

Felipe M. · Reviewed בערך שנה אחת ago

Yisan L. · Reviewed בערך שנה אחת ago

Anshika R. · Reviewed בערך שנה אחת ago

Ronny d. · Reviewed בערך שנה אחת ago

Arbaz K. · Reviewed בערך שנה אחת ago

Fahad G. · Reviewed בערך שנה אחת ago

Tarun T. · Reviewed בערך שנה אחת ago

Tarun T. · Reviewed בערך שנה אחת ago

task are non consistent between them

Roberto T. · Reviewed בערך שנה אחת ago

Sascha M. · Reviewed בערך שנה אחת ago

Alfredo B. · Reviewed בערך שנה אחת ago

Joachim W. · Reviewed בערך שנה אחת ago

task are non consistent between them

Roberto T. · Reviewed בערך שנה אחת ago

Gerardo G. · Reviewed בערך שנה אחת ago

Sujal M. · Reviewed בערך שנה אחת ago

kashyap a. · Reviewed בערך שנה אחת ago

Miguel E. · Reviewed בערך שנה אחת ago

Guilherme M. · Reviewed בערך שנה אחת ago

Luiz Antonio C. · Reviewed בערך שנה אחת ago

Mônica F. · Reviewed בערך שנה אחת 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 בערך שנה אחת ago

Arvind P. · Reviewed בערך שנה אחת ago

Rosana A. · Reviewed בערך שנה אחת ago