Gasoline prices: what moves the pump
· Matthew Dettman· 5 min read
A chart-first read of retail gasoline prices: the pump-to-crude margin, diesel versus regular, and real prices, from live FRED data.
Economic DataData VisualizationEnergyFRED
Loading
Writing
Long-form writing on business analytics, data engineering, and the tooling decisions underneath them.
A chart-first read of retail gasoline prices: the pump-to-crude margin, diesel versus regular, and real prices, from live FRED data.
A chart-first read of the US Employment Situation: payrolls by industry, slack, participation, education, wages, and jobless claims, from live FRED data.
A surveillance rule fires 2,823 alerts to catch 193 real ones. What raising the threshold saves, what it costs, and how to price every step.
The monthly close and AR report package I would build first: a cash-cycle waterfall, receivables aging, match exceptions, and tie-outs.
What the 10-year minus 2-year Treasury spread measures, why an inverted curve has preceded every recession since the 1970s, and how I put it on live data.
The load audit and reconciliation report I run on every new source feed: what dedupes, what gets rejected, and what must tie to zero.
A gross-margin reconciliation report that traces one work order through a raw record, a resolved version, a monthly aggregate, and a dashboard card.
A governed Power BI model: base measures, a margin bridge, filter context, time intelligence, and a measure dictionary a reviewer can check.
Putting a Power BI project under Git with .pbip, then adding review, CI checks, and an audit trail, so a report is versioned, reviewable, and auditable.
The monthly gross-margin bridge report I built on Databricks: bronze, silver, and gold Delta tables, and a MERGE proven safe to rerun.
Two Databricks reports off one build: a pre-visit completion-risk list and a customer segment profile, plus the leaky feature I refused.
Clustering a synthetic distributor's customer book with k-means, and the high-margin, fast-growing segment a revenue ranking structurally buries.
Every surveyed tornado in Ohio and West Virginia since 2014, the July 2026 outbreak near my home county, and all 74,771 US tornadoes back to 1950.