Projects

Everything I’ve built so far

Live data products, an airline delay analysis, a healthcare analysis, and small SQL case studies. Each one links to a write-up of the question, how I built it, and what it showed.

The Invest Lab logo: a laboratory flask marked with a dollar sign, on a mint green field.

The Invest Lab

Proprietary screens scan the liquid US market on various metrics and surface the names worth a second look.

A live research platform that pulls public data such as price, volume, SEC Form 4 insider filings, and news sentiment daily then scores each ticker through five separate models and publishes the results in an eye-catching format.

Finance Python Pandas Claude Code Data Visualization
The word SQL over a clinician in scrubs taking notes on a tablet.

Healthcare Projects

Looking for gaps in patient care using SQL and synthetic health records.

The first project checks which patients with diabetes had their A1c test in 2021 and which ones were missed. The results are in a Tableau dashboard you can filter by age and gender.

Healthcare SQL Tableau Hand Coded Data Storytelling
Football Forecast logo: a football arcing above a rising bar chart.

Football Forecast

Using player, coaching, and team data in creative ways to break away from the consensus predictions.

An NFL research site built on nflverse play-by-play data to help users make informed fantasy and game pick decisions. Rankings adjust for the unorthodox factors that move outcomes, then get set beside the market's own number.

Sports Analysis Python ETL Claude Code Data Storytelling
A passenger jet on approach with its landing gear down, against a blue sky.

Airline Delays

Following U.S. flights plane by plane to see how one late plane makes a late day.

One month of government flight records, traced through each plane’s day with SQL window functions. Late planes with under an hour on the ground put about $74M at stake in July, and Atlanta is the first place to add turn time.

Aviation SQL Window Functions Power BI Data Storytelling
The word SQL over a hand-written query from the video game sales case study.

SQL Mini Case Studies

Stakeholder questions answered end to end in SQL with Power BI presentation.

A growing set of small case studies that answer real-world business questions, visualized with Power BI dashboards.

Business Analysis SQL Power BI Hand Coded Data Storytelling