Who this is for
Finance or analytics lead who is asked 'where does this number come from?' and cannot answer quickly.
A board or audit question about one figure takes days of digging through queries, sheets and dashboards.
The result
For one report with up to 15 figures, a map shows each figure's source tables, columns and transformation steps. A query for each figure recomputes it from its listed sources to the value the report's own query gives on your copy, within the tolerance you set. What could not be traced is listed.
What is included
- One report or dashboard with up to 15 figures
- The queries, views, formulas and models behind them, which you provide as text
- A map per figure: sources, steps and the final calculation
- A recomputation query per figure, run on a read-only copy
- A list of what could not be traced, and a check on 5 figures you pick after the draft
You receive
- The lineage map for each figure
- The recomputation queries and their output
- The list of untraced parts
- The 5-figure check, recorded
- Run steps
What is not included
- Rolling out a lineage or catalogue platform
- Changing any query, table or report
- Deciding which figure is right
- More than 15 figures without a larger quote
- Personal data
What we need from you first
- Which report, how many figures and what builds it (SQL, dbt, a spreadsheet)
- The two figures people ask about most
- No real records, personal data or credentials in the first enquiry
Never send passwords, keys, customer records or confidential code in the first enquiry. Secure handover is agreed after scoping.
How we check it is done
- Each figure recomputes from its listed sources to the value the report's own query gives on the copy you send, within the tolerance you set in writing.
- For each figure, the report's own query is run on the copy; the row count and subtotal at every step named in the map match the report's own intermediate results, and our recomputed figure equals the report's own figure.
- Every table and column named in the map exists in the copy; a script checks each reference.
- You pick 5 figures after the draft is done; all 5 trace and recompute correctly.
- What could not be traced is listed with the reason, and none is left out.
- No query, table or report of yours is changed: checksums of the supplied text are identical before and after.
You inspect the map, the recomputation table and the untraced list, and sign off in writing. Payment follows sign-off.
When we would stop or decline
- The report is built by hand-edited screenshots with no source
- Only production access is available
- Figures depend on systems you cannot describe
- You want the figures changed
Questions
Is this a lineage platform?
No. It traces one report and checks each figure by recomputing it.
What if a number cannot be traced?
It goes on the untraced list with the reason. We do not guess.
Do you change my queries?
No. We only read them.
Price and terms
£295 · untested offer price. £295 after the agreed checks pass and you sign off. No payment before sign-off.
This is a new service with no published client results. The price is a starting point we have not yet tested with buyers. Nothing is ordered or charged by the enquiry. The full specification is on the Synthetic Industry catalogue.