Mini-Analysis: Summer 2014 San Francisco Crime Data

Introduction & Background I’m currently enrolled in the “Communicating Data Science Results” course on Coursera. Our first exercise involves examining a crime dataset and teasing out a finding (backed by 2-3 visualizations and accompanying descriptions that help […]

The Three Most Useful Window Functions in BigQuery

Running Total. Moving Average. Percent of Total. As an analyst, these are metrics that you commonly find yourself calculating – and yet they can be some of the most cumbersome to calculate. You typically have to export raw data […]

5 Lines of Code to Automatically Add New Rows to Your Google Sheets Reports

Ever find yourself doing the same repetitive tasks in your Google sheets, day in and day out? It’s likely that there are all kinds of ways you could automate your work, which in theory gives […]

Use Twilio and Google Sheets to Create a Baby Name Delivery Service

My wife and I are expecting our second boy in a few months, but we haven’t yet settled on a name for our little kiddo. Now, my wife has no trouble at all with regularly looking at […]

How to Use INDIRECT with CONCATENATE in Google Sheets

Using the INDIRECT function in combination with CONCATENATE can be a powerful tool that speeds up work in Google Sheets. But how do these functions work together, and what is a common use case? To […]

Grouping BigQuery Data by Quarter in a Google Data Studio Chart

Enterprise-level reports often need to be summarized by quarter/year. How can we make that work if we’re starting with a dataset in BigQuery and we want to create a chart in Google Data Studio? Let’s start […]