526,545-cell data room with 224,485 formulas and 36,185 cross-sheet references for Thread Bank portfolio.
After proving the Enterprise Data Analytics Engine architecture with the Rogue Credit Union portfolio, Nick replicated and adapted the system for Thread Bank's 207-loan, $22.6M portfolio — demonstrating that the architecture was systematic and scalable, not a one-off build.
The Thread Portfolio Data Room contains 526,545 cells with 224,485 automated formulas and 36,185 cross-sheet references, covering 12 months of historical data. The system was designed as both a production reporting system and a SQL migration blueprint, with every formula pattern documented for translation to BigQuery equivalents.
This deliverable validated the replicability of the enterprise architecture pattern and positioned PorchPass to onboard additional bank partners without proportional increases in engineering effort.
Interactive demo embedded above. Some features may require full-screen view.