Creating Machine Learning Model with Bigquery ML

Did you know that we can create machine learning models using just SQL in BigQuery? It might not solve all your problems, but who knows? Maybe it's worth the exploration~ 😙
Chapters / Timestamp
00:00 Intro
01:06 BigQuery ML
02:38 Use Case
05:36 Demo
06:43 Splitting data into training, validation, test set
07:09 Create Model from Training
11:41 Model Validation
12:47 Predicting New Data Point
14:45 Notes and Key Takeaways
15:58 Ending
BigQuery ML Documentation: cloud.google.com/bigquery/doc...
Some other good resources for Classification Evaluation Metrics (Precision and Recall): developers.google.com/machine... (check out the other material as well)
I also want to thank all my friends who have supported this channel 🥹. Finally, I earned my first-ever AdSense, and I would like to use it for the server and other costs incurred while creating tutorial videos in the future. ✨

[@IbrahimFajar]

aku tunggu video-video selanjutnya kak Mira.

[@jackbro2901]

Makasih mbak tantik

[@cxreed]

AKHIRNYAAAA kemana ajaa weeh🥲🥲

[@imfrontend280]

Untung gua subscribe jadi nggak ketinggalan materi keren ini

[@yopiWijaya-jz3ts]

Lanjut dong kak buat tutorial meachine learning lagi

[@ilhamh7846]

aku subscribe kak, ditunggu video2 bermanfaat lainnya tentang Data science, data analis, ML, dll

[@mamangcoders]

Mantap kakk

[@JeyyTughs]

nice infoo

[@cecepnurcahya7873]

Gua simpan dulu

[@williamsafero902]

Halo kak miraaa ayo buat bootcamp :D

[@syahrulazka4345]

kak bikin video sharing sharing dongg, kaya misalnya kakak di kantor kerjaannya ngapain ajaa atau sharing tentang data analyst di real world industri indonesia gitu gituu kaakkk, pengen tau gimana sih kalo kerja di industri sebagai data analyst atau bisnis intelegent

[@syahrulazka4345]

atau gimana cara kita presentasi ngasih insight dan rekomendasi ke stakeholders

[@baekbaek-aja]

Klo kita punya data yg cukup besar di server onpremise apakah ada tool nya utk upload ke bigquery?

[@MirasBlackbox]

@@baekbaek-aja di GCP ada namanya Google Transfer Service. Bisa dibaca2 cloud.google.com/storage-transfer-service?hl=en

[@mahdapop9253]

Sama aku juga lagi buat ML tpi masih pake collabs..btw hasil confyssion matrux ku cuma bisa predict statement negativ sih, valid gak ya? Atau pakai algoritma lain?

[@MirasBlackbox]

@@mahdapop9253 Mesti lihat juga data trainingnya sih. Class positif dan negativenya balance atau nggak? Bisa jd modelnya pinter predict yg negatif karena kekurangan data positif buat ditraining. Atau datasetnya imbalance jg bisa. Ada bnyk kemungkinan…

[@mahdapop9253]

@@MirasBlackbox bisa jadi..emang review nya dominant negatif sih. Btw tadi klu mau nyalain data profile nya kudu ada API dr developernya gitu ya? Btw datset nya dr mana kak klu boleh tau🙂

[@MirasBlackbox]

@@mahdapop9253 hmm iya sih. Harus dinyalain APInya sama adminnya, trus dikasih akses buat liat profilenya. Datasetnya bikin lewat chatGPt 🤣

[@GliderOne-uo2jy]

Ijin subscribe, mau mengupgrade diri