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. ✨
Пікірлер: 20
AKHIRNYAAAA kemana ajaa weeh🥲🥲
aku tunggu video-video selanjutnya kak Mira.
semangat kak ngontennya🎉
Untung gua subscribe jadi nggak ketinggalan materi keren ini
Lanjut dong kak buat tutorial meachine learning lagi
Makasih mbak tantik
aku subscribe kak, ditunggu video2 bermanfaat lainnya tentang Data science, data analis, ML, dll
Mantap kakk
nice infoo
Gua simpan dulu
Halo kak miraaa ayo buat bootcamp :D
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
2 күн бұрын
atau gimana cara kita presentasi ngasih insight dan rekomendasi ke stakeholders
Klo kita punya data yg cukup besar di server onpremise apakah ada tool nya utk upload ke bigquery?
@MirasBlackbox
2 күн бұрын
@@baekbaek-aja di GCP ada namanya Google Transfer Service. Bisa dibaca2 cloud.google.com/storage-transfer-service?hl=en
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
4 күн бұрын
@@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
4 күн бұрын
@@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
3 күн бұрын
@@mahdapop9253 hmm iya sih. Harus dinyalain APInya sama adminnya, trus dikasih akses buat liat profilenya. Datasetnya bikin lewat chatGPt 🤣
Ijin subscribe, mau mengupgrade diri