30 years of oil price data across 8 major geopolitical shocks, built during the active 2026 US-Israel conflict with Iran. The 2026 event produced the fastest price spike in the dataset, peaking in just 4 days. Includes event study analysis, forward scenario modeling, country vulnerability scoring, inflation-adjusted US gas price analysis, and lag correlation analysis confirming Brent price changes take one week to reach the pump. Three interactive Tableau dashboards.

Where is this marketplace losing money, time, and customers? SQL analysis of 100K real Brazilian e-commerce orders across 9 relational tables. Found the exact delivery threshold where customer satisfaction falls off a cliff, built a composite seller scorecard using window functions and CTEs, and identified product categories where poor reviews have nothing to do with delivery.

Ad hoc analysis for a record label: which genres should they sign next quarter? Started with 114K+ Spotify tracks, cleaned to 97,980, tested 5 hypotheses. Found electronic and dance outperform hip-hop in popularity scores; track duration barely correlates (−0.052).

Recurring scorecard and insights report for indie shop owners making inventory and marketing calls. Found the core buyer (35–44, 40.6%), seasonal patterns, top purchase driver (art quality), and #1 frustration (shipping costs).

Analyzed species conservation status and bat populations across U.S. national parks. Made recommendations for prioritizing species based on protection status and observation frequency.

A lightweight meal planning system that generates four weeks of meals while preventing repetitive dinners. Built entirely in Google Sheets with Apps Script automation.