✗ SS1 HALTED — rank 17 pbs step 5 FAILED

p.433 -- content and relationships, in the SOURCE — RuntimeError: `pbs`'s natural_key does not resolve to bare columns of `pbs_story_class`. …

✗ SS1 HALTED — rank 49 edgar_docs step 5 FAILED

p.433 -- content and relationships, in the SOURCE — MemoryError: …

✗ SS1 HALTED — rank 23 aapb step 5

Now (2026-10-22 21:19, OWED): 113527 table(s) had two EQUALLY good provider surfaces offered and `aapb` declares nothing that separates them. …

What tripped it (2026-10-16 04:28): p.433 -- content and relationships, in the SOURCE — AttributeError: 'dict' object has no attribute 'lower'

… and 6 more.

The walk stops here: the next rank is not released until this is answered.

BrainTrust Investment Lab

L1 — The Kimball STAR Ledger

← RETURN

L1 is the warehouse itself — the Kimball star. Thirty-four subsystems walked in the book’s own order, every source profiled, screened and certified against the page it came from, so that what reaches a decision has already been measured rather than assumed.

Wall Street quality. Detective grade. Delivered to the kitchen table.

Financial data arrives dirty — quietly restated, survivorship-biased, revised after the fact without a word. The industry’s answer is to sample it, average over the mess, and call it clean. Ours is to read every value end to end, and publish what we find.

Three things most vendors will not do. We keep the companies that died. A universe that quietly drops the bankruptcies and the buyouts makes every strategy look brilliant; ours holds the delisted beside the living, because a test that never meets failure has not been tested. We keep the number as it was known. Every filing carries the moment it became public, so a figure restated two years later cannot leak backwards into a decision nobody could have made at the time. And we publish our own defects. The flaws this system finds in its own work sit on this board beside the successes — a record that can only say yes is a brochure.

The work is the moat. Not a sample, not an average: every column in every source read wall-to-wall for nulls, extremes and cardinality, and counted. The figure below is what that adds up to — and it is not a marketing number, it is arithmetic on the record, re-measured the moment you refresh this page. No shop reaches it by hand, which is the whole reason the kitchen table has never been offered data like this before.

And we are graded against a standard we did not write. The Data Warehouse Toolkit, 3rd ed. — the book the banks and the exchanges build on. Thirty-four subsystems, walked in its own order, every box a certification against its page, signed and dated by BrainTrust Staff. Anyone can buy that book and mark our homework; that is the difference between a claim and a proof.

What the rest of the field actually sells

The other competitors fall into five tiers. We name none of them — a logo dates a page and invites an argument about a brand; the SHAPE of each tier is the durable fact, and it is the one that makes the case.

The free tier Ad-supported consensus data, delayed. The dead companies are simply not in it, so every test run on it flatters — and the first thing the paid upgrade sells you is the absence of the ads.
The screener A few hundred a year for a dashboard over somebody else’s feed. Broad and genuinely useful — but you rent the view, and the vendor underneath can reprice, restate or withdraw without telling you.
The trackers Our closest cousins: insider trades, 13F holdings, congressional filings. Each one a silo. The filings are displayed, not conformed and not joined — so “who was buying while this was being disclosed” is a question the product cannot be asked.
The terminal Institutionally clean, and the price is the moat — tens of thousands per seat, per year. The kitchen table was never the customer.
The open source A kindred spirit and a cautionary tale: it sunset its terminal under the people who were using it. Free is not the same as durable.

Nobody at any price sells the join. That is the finding, and it held across every tier surveyed. Insider transactions, ownership edges, failures-to-deliver, short interest, fundamentals and prices — on one conformed bus, anchored to the filer, resolved to the entity. The tiers above show you filings. This shows you the people and the money as one fabric, which is where a tell actually lives.

And the honest other side, because a pitch with no gaps in it is the thing we are arguing against. We are US-centric where the broad screeners are global. We carry no analyst estimates. The polished interface is a later level and is not built. Those are on the record here for the same reason the defect count is: you should not have to find them yourself.

The delivery is the point: all of it is for our Campers — we grow Investors through our Summer Camp for Kitchen Table Investors, and the kitchen table deserves institutional-grade truth. What you are watching is that build, live. Refresh, and every number on this page re-measures from the record.

We don’t guess and we don’t trust, We Measure!Nothing here is an estimate or on someone else’s word.

What an ETL process is — and why your kitchen table needs one

ETL stands for Extract, Transform, Load — the three jobs that stand between raw data and a question you can actually answer.

Extract pulls records from wherever the world publishes them: an SEC filing, a price history, a government release. Transform repairs what is wrong and makes the pieces agree — one company spelled four ways becomes one company, and a figure quietly restated years later is still recorded as it was first known. Load puts the result where it can be asked hard questions quickly.

Here is why that reaches your table. A wrong number never announces itself. A price that silently excludes the companies that went bankrupt makes every strategy look brilliant. An earnings figure revised two years after the fact makes a decision you could never have made look obvious. Nobody sends you a correction. You simply act on it, and the mistake shows up later as money.

An institution spends millions on an ETL process so its analysts never touch a number that has not been through one. A household normally gets the raw feed and is expected to cope. This is the same machinery, built for the kitchen table — run on a schedule, the same way every time, so the answer you get on Friday was built exactly like the answer you got on Monday. Every serious warehouse runs one. The difference is whether anyone will show you theirs.

Who was Dr. Ralph Kimball — and why he matters at your table

The man who wrote the field’s standard. Dr. Kimball took a PhD at Stanford, helped design the Xerox Star at PARC — the workstation that put windows, icons and a mouse in front of the world — and founded Red Brick Systems, a database built for exactly this kind of work.

His Data Warehouse Toolkit, written with Margy Ross, is the book most warehouses are measured against. It is where the 34 ETL subsystems on this page come from — in his order, in his four groups, cited to his page numbers.

Why that matters to you, and not just to us. Anyone can claim their data is clean. The claim is worth nothing unless there is a standard outside the claimant to check it against. Dr. Kimball wrote that standard, banks and exchanges are built on it, and it is published — you can buy the book and mark our homework.

So BrainTrust does not improvise a method and ask you to trust it. It follows his, page by cited page, and every box below is graded against the page it came from. The same standard the institutions are held to, pointed at your table instead of theirs.

How to read this board

Each card is one subsystem. Its colour is the walk — whether that stage has actually been run and certified. Its badges are the code — how many programs serve it, whether they sit in their official place, and whether the register knows them.

Those two can disagree, and the disagreements are the point: a stage marked done while still carrying gaps, or one holding programs it has never run. A dashed outline means work that is declared but not built.

We publish the gaps. A board that showed only finished work would be a brochure; this one is measured fresh on every visit and is allowed to say no.

The work, mounting

Read live from the record on every refresh — measured by BrainTrust Staff, never estimated.

554,852,067man-hours of calculator work

33,291,123,997 values measured wall-to-wall by the star’s instruments — every one of them read wall-to-wall, not sampled. One person completing these complex calculations on a calculator, one every minute, around the clock without stopping, would need 554,852,067 man-hours to do the same work by hand.

Facts held in the provider record
2.54B
Certifications signed
3.56K
+95 last night
Acts witnessed in the record
635K
+9.51K last night

L1 — The Kimball Star — the ledger

whatLast NightLast 7 DaysLast MonthLast YearTotal
Values measured2,0202,0201,374,943,79933,291,123,99733,291,123,997
Facts held in the provider record————2,544,461,235
Certifications signed952,0093,2243,5643,564
every one a named claim against the book's own page
Acts witnessed in the record9,51326,792388,896634,673634,673
nothing the machinery does goes unrecorded

Room reserved: L0 — The Chaplain (governance and self-correction) · and the levels beyond.

The start-up, walking

Certified work fills from the left; the run under way follows after the gap; the white behind the black edge is the road ahead. Measured from the walk record on every refresh.

Stations — the thirty-four subsystems0 of 34 certified · 21 running
Lanes — the sources of SS1, in the book’s run order12 of 48 certified · 36 running · 1 excluded (49 in the book order)

The board — every bulb a station

completedrunningawaiting its turn · owedfailedexcluded

Band 1 — Extraction (Remote Sources → Local System)

SS1 · Data Profiling↻12 of 48 · in progress
SS2 · Change Data Capture System↻1 of 48 · in progress
SS3 · Extract System↻0 of 48 · in progress

Band 2 — Transform (Cleaning & Conforming)

SS4 · Data Cleansing System (Quality Screens)↻0 of 48 · in progress
SS5 · Error Event Schema↻0 of 48 · in progress
SS6 · Audit Dimension Assembler↻0 of 48 · in progress
SS7 · Deduplication System3 owed · 0 of 48 done
SS8 · Conforming System↻0 of 1 · in progress

Band 3 — Loading (Delivering to the Kimball STAR)

SS9 · Slowly Changing Dimension Manager↻0 of 1 · in progress
SS10 · Surrogate Key Generator↻0 of 1 · in progress
SS11 · Hierarchy Manager↻0 of 1 · in progress
SS12 · Special Dimensions Manager↻0 of 1 · in progress
SS13 · Fact Table Builders↻0 of 1 · in progress
SS14 · Surrogate Key Pipeline↻0 of 1 · in progress
SS15 · Multivalued Dimension Bridge Table Builder↻0 of 1 · in progress
SS16 · Late Arriving Data Handler↻0 of 1 · in progress
SS17 · Dimension Manager System↻0 of 1 · in progress
SS18 · Fact Provider System↻0 of 1 · in progress
SS19 · Aggregate Builder↻0 of 1 · in progress
SS20 · OLAP Cube Builder↻0 of 1 · in progress
SS21 · Data Propagation Manager↻0 of 1 · in progress

Band 4 — Managing the ETL Environment

SS22 · Job Scheduler↻0 of 1 · in progress
SS23 · Backup Systemawaiting run
SS24 · Recovery and Restart Systemawaiting run
SS25 · Version Control Systemawaiting run
SS26 · Version Migration Systemawaiting run
SS27 · Workflow Monitorawaiting run
SS28 · Sorting Systemawaiting run
SS29 · Lineage and Dependency Analyzerawaiting run
SS30 · Problem Escalation Systemawaiting run
SS31 · Parallelizing/Pipelining Systemawaiting run
SS32 · Security Systemawaiting run
SS33 · Compliance Managerawaiting run
SS34 · Metadata Repository Managerawaiting run