BigQuery + Colaboratory setup in 5 mins
For data analysis and exploration, Jupyter/IPython notebooks has often been the tool of choice for its ease in sharing work and explaining the thought process. If your data resides mainly …
Managing data access controls on BigQuery
Setting up access controls across an organization, even for a small one as ours, isn’t easy. Here’s an approach similar to what we use at Wego to manage access controls …
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? …
