Everything useful before you download or buy.
Say what every table and column holds, so nobody has to guess what a row is or what a value may be.
An Excel workbook with a Tables sheet and one sheet per table. For each table: the grain sentence ("one row is one …"), the key, the row count, the as-of date, how often it is refreshed, the source, the owner and what it does not hold. For each column: type, description, an example value, the values allowed, and its profile: null rows, distinct values, smallest and largest. The share of NULLs, a range check against the allowed minimum and maximum, and a key check fill themselves in.
It comes filled in for Clearstone's four tables from Follow the Money, profiled with DuckDB as of 1 January 2027. The example shows what a dictionary should catch: a reversal line below zero, due dates running to 2041, a due date that is unique only by accident, a status label that disagrees with the dates, and a department with no budget lines. A Relationships sheet records the one join between the tables, with the rows on each side that find no match.
A blank sheet is ready to copy for each of your own tables, and the Start here sheet gives the SQL that profiles a column.
XLSX for Excel or LibreOffice, 8 sheets. Formulas only, no macros.
Check the resource before buying — a limited-page preview.
This is a limited-page preview. If it does not load, open the PDF directly.
One review per person. Submitting again updates your existing review.
Be the first to review this resource.