Supercharge your data analytics with BigQuery ML

by | Jan 25, 2020 | Voxxed Days Bucharest 2020

Márton Kodok is a romanian Google Developer Expert (GDE) senior software architect at REEA who led the implementation of complex and distributed systems serving millions of users for companies like LogoMix, WaterSmart, Ausschreibungsdienste and many more. Among the top romanian StackOverflow users with over 175k reputation points. Active contributor for open-source solutions like Beanstalkd message queue admin console, Riak PHP admin interface. Expert in Databases and Search systems like Google BigQuery, Elasticsearch, Redis, Sphinx. Active in mentoring and speaker at conferences.

One of the hottest topics in database land these days is BigQuery ML. A new way to use machine learning on top of tabular data straight on your tables without leaving the query editor. With BigQuery ML, you can build machine learning models without leaving the database environment and training it on massive datasets. 

In this demo session, we are going to demonstrate common marketing Machine Learning use cases how to build, train, eval and predict, your own scalable machine learning models using SQL language. The audience will get first hand experience how to write CREATE MODEL sql syntax to build machine learning models such as: – Multiclass logistic regression for classification  – K-means clustering  – Import TensorFlow models for prediction in BigQuery  Models are trained and accessed in BigQuery using SQL — a language data analysts know. This enables business decision making through predictive analytics across the organization without leaving the query editor.