Notes on data, decisions, and the business in between.
Field-tested thinking on analytics as a business discipline: dashboards that change meetings, data quality you can book, metrics with ancestry, forecasts that admit uncertainty, and analytics spend appraised like any other investment.
KPI Trees: Connecting Every Metric to the Business Model
A method for turning a wall of metrics into a driver model the whole team can steer by.
Read article →Star Schemas and DAX That Scale: Data Modeling for Power BI
Why every slow, contradictory Power BI report traces back to the model, and how to build one that lasts.
Read article →The Hidden Cost of Dirty Data: Treating Data Quality as a P&L Line Item
How to put a shilling value on bad data, and the reconciliation discipline that recovers it.
Read article →SQL Patterns Every Working Analyst Should Own
The seven SQL patterns that do most of the heavy lifting in real analytical work.
Read article →