Separate Before You Sort (Window Functions, Made Simple)
The one sentence that writes your PARTITION BY for you
$1.14M in Booked Value. The Wrong Segment to Bet On. (Two Columns Explain Why)
Two extra columns changed what Summit should do next
Your Best Campaign Audience Isn’t in Your Revenue Report (Yet)
Absence is a business signal. Here’s the SQL that surfaces it.
The Question a Single Table Cannot Answer (And the JOIN That Can)
How to plan a JOIN before you write one line of SQL
One Big Month Is About to Send Your Forecast the Wrong Way (8 Lines of SQL to Prevent It)
The 8-line query that shows the rhythm behind the total
Your Booking Export Has 1,600 Rows. Your Boss Wants One Answer. (Code Included)
Three SQL moves that turn any messy export into a real decision
The 5-Minute Query I Run Before I Touch a New Database (Full Query Included)
It turns a vague “pull some insights” ask into three real questions
A Practical Map for Using AI in Analytics
Five ways working analysts are using AI, from learning to monitoring
How to Explore a Brand New Database in 15 Minutes
The Mister Rogers Blueprint — revisited with fresh eyes
When SQL Isn’t Enough — The Modern Analyst Skill Stack
How to build on the foundation you already have