How to obtain and interpret explanations of predictions


Create an ARIMA model, then detect anomalies

SELECT 
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
OPTIONS(
model_type='linear_reg', input_label_cols=['duration']
)
AS
SELECT
start_station_name,
CAST(EXTRACT(DAYOFWEEK FROM…



A neat trick that uses Stored Procedure with a BigQuery script

CALL 
`ai-analytics-solutions`.publicdata.setup_flights_demo(
'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