- Published on
The Google Sheets Query function replaces so many other spreadsheet functions it’s not even funny. FILTERs, AVERAGEs, and SUMs all go out the window when it enters the picture.
All Posts
- Published on
Tutorials (cheat sheet included) walking through the basics of SQL for analytics (concepts like grouping, joining and unnesting), using the Google Analytics sample dataset in BigQuery- Published on
Learn to use the VLOOKUP formula in Google Sheets to fetch data matches in a few unorthodox ways: to lookup right-to-left, from another Sheet, or based on multiple criteria.- Published on
A bridge connecting Google Sheets to a BigQuery analytics warehouse. Automates creation of BigQuery tables + views, and uploading of data to tables on a schedule.