James Green – Medium

Pinned

James Green
in
DataDrivenInvestor

Biological Data Storage: The Storage Medium of the Future

World first: A Netflix series successfully stored in DNA

6 min readNov 11, 2020

--

DNA data storage

--

Pinned

James Green
in
Towards Data Science

Just Released: BigQuery User friendly SQL Functions

We were excited to see the power of BigQuery receive a further boost this week with the release of 12 new BigQuery SQL features. Google…

6 min readOct 28, 2020

--

2

Image licensed to author

--

2

James Green
in
Towards Data Science

Common Table Expressions: 5 Tips for Data Scientists to Write Better SQL

From SQL Server to Google BigQuery: Learn why I love CTEs.

7 min readJan 20, 2021

--

2

CTE SQL

--

2

James Green
in
Towards Data Science

5 great features in BigQuery’s new UI for 2021 (yes, it has tabs!)

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

7 min readJan 17, 2021

--

1

BigQuery new UI 2021

--

1

James Green
in
Towards Data Science

5 Bigquery SQL performance tips for modern data scientists

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

9 min readDec 12, 2020

--

1

BigQuery performance tips

--

1

James Green
in
Towards Data Science

10 SQL standards to make your code more readable in 2021

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

9 min readDec 10, 2020

--

4

SQL naming standards

--

4

James Green
in
Towards Data Science

BigQuery UNNEST: How to work with nested data in BigQuery

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

9 min readDec 9, 2020

--

BigQuery UNNEST

--

James Green
in
Towards Data Science

Kaggle: Man vs Machine

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

11 min readNov 28, 2020

--

Kaggle: Man vs Machine

--

James Green
in
Towards Data Science

Importing Kaggle Training Data into Google Cloud Storage

We show you how in easy to follow steps.

5 min readNov 26, 2020

--

1

Importing Kaggle data into Google Cloud Storage

--

1

James Green
in
Towards Data Science

Google Cloud AI Platform: Human Data labeling-as-a-Service Part 2

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

12 min readNov 25, 2020

--

Google Cloud AI Platform Data labeling Service

--

James Green

James Green

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

Following

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams