PinnedJames GreeninDataDrivenInvestorBiological Data Storage: The Storage Medium of the FutureWorld first: A Netflix series successfully stored in DNA·6 min read·Nov 11, 2020----
PinnedJames GreeninTowards Data ScienceJust Released: BigQuery User friendly SQL FunctionsWe 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 read·Oct 28, 2020--2--2
James GreeninTowards Data ScienceCommon Table Expressions: 5 Tips for Data Scientists to Write Better SQLFrom SQL Server to Google BigQuery: Learn why I love CTEs.·7 min read·Jan 20, 2021--2--2
James GreeninTowards Data Science5 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 read·Jan 17, 2021--1--1
James GreeninTowards Data Science5 Bigquery SQL performance tips for modern data scientistsSQL tuning tips and advice to help reduce BigQuery costs. Start 2021 off on the right foot!·9 min read·Dec 12, 2020--1--1
James GreeninTowards Data Science10 SQL standards to make your code more readable in 2021Make a NY resolution for 2021: Easy to read, and maintain SQL·9 min read·Dec 10, 2020--4--4
James GreeninTowards Data ScienceBigQuery UNNEST: How to work with nested data in BigQueryWe use a common example: un-nesting Firebase event data to facilitate data science analysis·9 min read·Dec 9, 2020----
James GreeninTowards Data ScienceKaggle: Man vs MachineWe train an AutoML image classification model for Kaggle’s latest competition. See how it ranks against human Data Scientists.·11 min read·Nov 28, 2020----
James GreeninTowards Data ScienceImporting Kaggle Training Data into Google Cloud StorageWe show you how in easy to follow steps.·5 min read·Nov 26, 2020--1--1
James GreeninTowards Data ScienceGoogle Cloud AI Platform: Human Data labeling-as-a-Service Part 2In the third article of the series, we explore Google’s (human) Data Labelling Service for Advanced Video Labelling·12 min read·Nov 25, 2020----