When you removed those that are above 100 but didn't limit those below 0, the skew of the distribution made your predicted values to move tho the left, resulting in negative values and most of the predictions being below what expected. Nice video!
Hi Professor, great video as always! Do you think you could reexplain what you did at 4:00? It seems that you trained the model on data from before 2022 and now you are predicting the average time for 2022? In the video you say "train" again when using "ML.PREDICT" for the values in 2022 so I was slightly confused.
I think you've got it, but I might have misspoke on using "training" again. Basically, we are training the model on data before 2022, and then testing it on data in 2022. In a demo, it avoids the situation where the model already knows the answer; if we had trained it on 2022 data and then asked the model questions that it'd already been given the answers, then it wouldn't be a super useful demo. Typically we separate data into training and validation sets - it's kind of like that.
![Machine Learning via SQL on Google Bigquery [ hands on lab]](http://i.ytimg.com/vi/ka_NiOHowLo/mqdefault.jpg)
When you removed those that are above 100 but didn't limit those below 0, the skew of the distribution made your predicted values to move tho the left, resulting in negative values and most of the predictions being below what expected.
Nice video!
Hi Professor, great video as always! Do you think you could reexplain what you did at 4:00? It seems that you trained the model on data from before 2022 and now you are predicting the average time for 2022? In the video you say "train" again when using "ML.PREDICT" for the values in 2022 so I was slightly confused.
I think you've got it, but I might have misspoke on using "training" again. Basically, we are training the model on data before 2022, and then testing it on data in 2022. In a demo, it avoids the situation where the model already knows the answer; if we had trained it on 2022 data and then asked the model questions that it'd already been given the answers, then it wouldn't be a super useful demo. Typically we separate data into training and validation sets - it's kind of like that.
Hi Professor
Would you be able to cover data governance implementation on BigQuery, for one data set.
Thank you for the ML demo,