A data dictionary of 200+ business metrics used in a large water utility company, listing clear explanations, pseudo SQL and source data lineage.

Before this there were 5 different ways to calculate specific things like “minimum night flow”.

Plus we then built the data product which calculates all that stuff and serves it to the business in a self-serve query interface.

But by far the most impactful was bringing together different teams to align on how actually to calculate core business terms.