Age receivables and compute DSO from open invoices as of any date
When the aging report is rebuilt by hand each month and never reconciles to the ledger.
- Transformation
- Finance
Industry
6 RecipesUtilities
Meter reads, billing periods and unbilled energy — a reconciliation between a physical quantity and an invoice that almost never ties on the first pass.
Build something that is not there yet 6
Standardize names and addresses and mint deterministic match keys
When the same customer appears three different ways across systems and mail bounces on half the addresses.
- Transformation
Build retention cohorts and a churn feature table
When "what's our churn rate" gets three different answers depending on who is asked.
- Transformation
Unify consent and communication preferences with auditable latest-wins logic
When a customer who opted out of email still gets a marketing send from a different system.
- Governance and cost
Build the calendar and fiscal-period dimension every mart shares
When week boundaries differ between two reports because each model computes its own calendar logic.
- Transformation
Reconcile meter reads to bills and quantify unbilled energy
When metered and billed consumption diverge and nobody can say how much of the gap is unbilled energy.
- Transformation
- Utilities