Making parameter estimates with BigQuery
Often in analytics, we’d want to find that one number that is representative of a sample to be able to briefly describe it. There are a couple of ways this …
Random Sampling with BigQuery
BigQuery is great for storing huge amounts of data over which to run analytics. But sometimes, what we need is just a sample of a dataset to for a dry …
10 ideas for using Window Functions to analyse data with SQL
Ever had to compare a row of data against a benchmark or grouped aggregate? How about knowing preceding and subsequent rows of data of a record in within one query? …