Template BUY NOW Beginner Preview available

Data Dictionary

by LucidPlexus
0.00 · 0 reviews
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…
8 Pages
0 Views
0 Downloads

Overview

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.

Type Template
Pages 8
Access Buy Now

Preview

Check the resource before buying — a limited-page preview.

Open PDF
Loading preview…

This is a limited-page preview. If it does not load, open the PDF directly.

Ratings & Reviews

One review per person. Submitting again updates your existing review.

0 total

Write a review

Share what helped, what stood out, or who this resource is best for.

No reviews yet

Be the first to review this resource.

Login to Buy Preview