SQL & Local Analytics
Practical SQL for analysts — the patterns you actually reuse, from joins and window functions to running analytics locally with DuckDB.
Notes & writing
Browse by topic
The blog grouped into a handful of clusters, each with its own set of posts and, where relevant, a free tool.
Power BI & DAX
Modeling, DAX and performance for Power BI — star schemas, CALCULATE, time intelligence, and what actually makes reports fast.
AI for Analysts
Where AI genuinely helps an analyst's workflow, where it fails, and how to validate what it produces before it reaches a stakeholder.
RevOps & Forecasting
Revenue operations and sales forecasting — data quality audits, benchmark reality checks, and forecast accuracy without sandbagging.
Marketing Measurement & Experimentation
Attribution, incrementality and A/B testing done right — how to tell whether a marketing result is real or noise.
Analyst Craft & Authority
The non-technical half of the job — storytelling, portfolios, metric definitions and prioritization that make analysis land.
SaaS Metrics & Pricing
The numbers behind a SaaS business — MRR and churn, CAC payback, break-even pricing, and how an early-stage company gets valued.