- Published on
Learn the basics of the popular open-source data modeling framework: what's it used for, what it replaces, and how it helps you build more performant and maintainable analytics pipelines.
Sql
- Published on
A 3-step method for calculating retention + churn for any business (SaaS or Ecommerce) over any period (weekly, monthly, etc) in SQL, using Google BigQuery.- Published on
How to stand up Shopify analytics workflows in SQL in a cloud data warehouse like BigQuery: cohort analysis, buyer segmentation (via RFM), retention & churn analysis, forecasting, and basket analysis.- 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.- 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
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.