How to obtain and interpret explanations of predictions

Create an ARIMA model, then detect anomalies

EXTRACT(date from start_date) AS start_date,
COUNT(*) AS num_trips
FROM `bigquery-public-data.london_bicycles.cycle_hire`
GROUP BY start_date

BigQuery ML can use Vertex AI to tune common model parameters

What is BigQuery ML?

BigQuery ML allows you to quickly train ML models on data in BigQuery. For example, suppose you want to train a linear ML model to predict the duration of a bicycle rental, you can do that using:

CREATE OR REPLACE MODEL ch09eu.bicycle_model_linear
model_type='linear_reg', input_label_cols=['duration']

A neat trick that uses Stored Procedure with a BigQuery script

'MY-PROJECT-NAME', 'demods')

Why do we need it, how good is the code-free ML training, really, and what does all this mean for data science jobs?

What is there to unify?

The idea…

Converting rows to columns

Using the new geospatial capabilities in Data Studio

Querying in BigQuery

Go to the…

Just turn it on; no code changes needed

Using Cloud Dataflow and Google Cloud Public Datasets

Lak Lakshmanan

Data Analytics & AI @ Google Cloud

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store