World first: A Netflix series successfully stored in DNA

DNA data storage
Image licensed to author

The Neural Link


From BigQuery truncate table to dynamic SQL support; we cover 12 user-friendly BigQuery functions released by Google Cloud.

Image licensed to author
Image licensed to author

1. Add table columns via DDL

alter table mydataset.mytable
add column a string,
add column if not exists b geography,
add column c array<numeric>,
add column…


From SQL Server to Google BigQuery: Learn why I love common table expressions.

CTE SQL
Image licensed to author


I explore BigQuery’s new UI, just released in preview

BigQuery new UI 2021
Image licensed to author

#1 new layout, new panels


SQL tuning tips and advice to help reduce BigQuery execution time and costs. Start 2021 off on the right foot!

BigQuery performance tips
Image licensed to author


Make a NY resolution for 2021: Easy to read, and maintainable SQL

SQL naming standards
Image licensed to author

#1 Choose a CASE and Stick to_it

select first employee_first_name,
surname employee_last_name…


We use a common example: un-nesting Firebase event data to facilitate data science analysis

BigQuery UNNEST
Image licensed to author

What is semi-structured data?


We train an AutoML image classification model for Kaggle’s latest competition. See how it ranks against human Data Scientists.

Image licensed to author


We show you how in easy to follow steps

Importing Kaggle data into Google Cloud Storage
Image licensed to author


In the third article of the series, we explore Google’s (human) Data Labelling Service for Advanced Video Labelling

Google Cloud AI Platform Data labeling Service
(Photo by Griffin Wooldridge on Unsplash)

Google Cloud AI Platform

What do we mean by labelling?

James Green

Head of Data, Analytics & AI @ Ancoris. Part of a highly committed team of data scientists, mathematicians & engineers delivering Google Cloud client solutions

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