Executive Reporting
Monthly business review reporting for the CEO, CFO and Chief Strategy Officer
Data Modeling
Governed BigQuery sources and tested dbt models that serve as the source of truth
Automation
Python and SQL pipelines that replace recurring manual work
Strategy & FP&A
Forecasting, plan vs. actual, and sales compensation analysis
Who Comes Back? Customer Retention in dbt
A tested dbt pipeline on BigQuery that measures cohort retention for an e-commerce store and asks whether acquisition channel or first purchase predicts repeat buyers.
6% of customers reorder within 90 days. Each row is a quarterly cohort; brighter means more came back.
Cal Football, 2000 to Now: Rise, Peak and Drift
A six-chapter data story on how Cal football rose, peaked and drifted: talent vs. results, NFL draft outcomes, attendance, the transfer portal and where Cal stands in the ACC.
What Your Name Says About When You Were Born
Predicting birth year from first name with 100+ years of US Social Security data, plus a guess-the-decade game and an animated name time machine.