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 […]

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 […]