Portfolio

Daily Revenue Reporting Dashboard

Consolidated multi-source data to streamline daily KPI reporting

Zapier Google Sheets Google Data Studio

Anonymized Partner Reports

Enabled confidential peer benchmarking for demand-side partners

Google Data Studio Google Sheets

Spectrum Holdings Reporting

Improved reporting on national spectrum license holdings

Excel SQL

Broadcast Incentive Auction

Executive-level spectrum auction cost analysis with GIS market insights

GIS Excel SQL

Wi-Fi Churn Analysis

10% churn reduction — $1M pilot that catalyzed $50M+ in follow-on investment

MS Access SQL Excel

Retail Case Study

13 recommendations across 7 business objectives from retail sales & ad data

Python pandas Excel

Wrangling Twitter Data

Python + Twitter API + ML image recognition for dog breed classification

Python pandas Twitter API

Explore Wine Data

R + ggplot2 correlation analysis of sulphates, acidity, and wine quality

R ggplot2

Explore Movie Data

Sci-Fi release timing & cast recommendations from IMDb data using Python

Python pandas Jupyter

Real-Time-ish Alert System

Hourly KPI alerts via Google Analytics + Zapier + Slack + PagerDuty

Google Analytics Google Sheets Zapier Slack

Customer Segmentation by ML

k-means clustering competitive heat map — geography emerged from pure data

R k-means

Machine Learning for Profitable Ad Sets

Logistic regression in Google Sheets cuts ad decision time from weeks to days

Google Sheets Logistic Regression SQL

Forecasting in R

70+ granular automated forecasts replacing a 6-person team using Facebook Prophet

R Teradata SQL Prophet

A Baseball Story

14-page Tableau story: home runs, player BMI, and pitching quality over a century

Tableau