Predict Bike Trip Duration with a Regression Model in BQML Reviews

Eddie Y. · Reviewed أكثر من 4 سنوات ago

Shivani G. · Reviewed أكثر من 4 سنوات ago

Sivaprasad N. · Reviewed أكثر من 4 سنوات ago

Bushra S. · Reviewed أكثر من 4 سنوات ago

Alex S. · Reviewed أكثر من 4 سنوات ago

Kenneth H. · Reviewed أكثر من 4 سنوات ago

Arthur Y. · Reviewed أكثر من 4 سنوات ago

Lena G. · Reviewed أكثر من 4 سنوات ago

Darren S. · Reviewed أكثر من 4 سنوات ago

Thirupurasundari K. · Reviewed أكثر من 4 سنوات ago

problems with "Predict Bike Trip Duration with a Regression Model in BQML" lab: Impact of day of week and hour of day. -------------------------------------- Step 1 is good for dayofweek. Step 2 - should include the step by step instructions that were given to us for the start station stop. This might only be the student's 2nd time using this function, and the sorting is different enough that it should be explained to the new user instead of hidden. - The x-axis labels I get are very different. Yours just have a number. Mine say Week 1, Week 2, Week 3, etc. How can I get my results to look like those in the screenshot in this lab? Please add the steps to get my labels the same as yours, or please change your screenshot to match what the student would have using the most direct path. - In your screenshot, you have the weekdays displayed in descending order. That doesn't make much sense. Please show the student how to sort this in ascending order. Step 1 does not work for hourof day without some modification. Please give the needed SQL code. This isn't a quiz for knowing what the different extractable elements are from a timestamp in BigQuery. It's supposed to be a demo. ``` SELECT EXTRACT(hour FROM start_date) AS hourofday, AVG(duration) AS duration FROM `bigquery-public-data`.london_bicycles.cycle_hire GROUP BY hourofday ``` Step 2 - please include the step by step instructions - The x-labels I get are a little different. You have 0-24; I have 12AM - 11PM. Please give the code to make the lables your way, or please update the screenshot to work with the most direct way. - The hourofday being sorted descending doesn't make intuitive sense. Please use ascending sort instead. Impact of number of bicycles -------------------------------------- 1. Code works fine. 2. Please walk the student step by step through how to get from the query to this graph. Also, in this graph, you show the x and y-axis labels. In the one graph that you walked the students through, you skipped the axis labels. Please make sure to show the student where to change the axis label in your walkthrough. Create a training dataset -------------------------------------- 0. Code works fine 1. "Create a dataset in BigQuery called bike_model to store your model. Set the Data location to the EU region since the data we are training on is in the EU. Click Create dataset." HOW? Where do I find this button? How do I get from running the query to creating a dataset here? I had to go here to find the answer (https://cloud.google.com/bigquery/docs/datasets#console) Combine days of week -------------------------------------- For the model evaluation, please again show the query step to get the model results, or walkthrough how to find the model evaluation specs through the UI.

AUSTIN F. · Reviewed أكثر من 4 سنوات ago

Oladimeji O. · Reviewed أكثر من 4 سنوات ago

Bishal K. · Reviewed أكثر من 4 سنوات ago

Kelly S. · Reviewed أكثر من 4 سنوات ago

Steven W. · Reviewed أكثر من 4 سنوات ago

Rebecca V. · Reviewed أكثر من 4 سنوات ago

Evelyn F. · Reviewed أكثر من 4 سنوات ago

Ivan P. · Reviewed أكثر من 4 سنوات ago

Smitha K. · Reviewed أكثر من 4 سنوات ago

Suraj K. · Reviewed أكثر من 4 سنوات ago

Mayank G. · Reviewed أكثر من 4 سنوات ago

Pablo G. · Reviewed أكثر من 4 سنوات ago

Very informative. Clear

Joaquin M. · Reviewed أكثر من 4 سنوات ago

Edgar Josue G. · Reviewed أكثر من 4 سنوات ago

PrasannaKumar G. · Reviewed أكثر من 4 سنوات ago