Housing data & analysis · Colorado

Housing numbers that hold up under questioning.

What we do well.

Demand & absorption modeling

Buyer and renter segments, price points, absorption pace, with confidence intervals attached.

Market studies

Submarket definition, competitive supply, pricing and product fit for a specific site.

Feasibility & pro forma review

We rebuild the financials, stress the assumptions, and report what actually drives the outcome.

Model audit & validation

Reconcile an inherited spreadsheet against its own logic. Find where it disagrees with itself.

Data pipelines & automation

Census, State Demographer forecasts, FRED, permits: fetched, dated, staleness-flagged.

Custom analytics software

When the analysis needs to be run again next quarter, we build the tool instead of the deck.

A live demand model, rebuilt from the spreadsheet up

Rural Homes Colorado · 2026

Their demand model, the thing that decides where they build, was a hand-maintained Excel workbook. We rebuilt it as a live tool their analysts open in a browser, that automatically pulls data from the Census and other sources.

Rural Homes demand dashboard showing a map of building activity and buyer affordability charts
Bill Ray, founder of Barn Swallow Consulting, standing outdoors

Bill Ray

You will work with the person who does the work.

Bill spent four years building machine learning systems and data pipelines at companies like Kitware, Vaisala, and Seagate, before deciding the interesting problem was housing.

MS in Computer Science, UMass Amherst; MS in Real Estate and the Built Environment, University of Denver. While at DU, his teams won 2nd and 3rd nationally in the 2025 and 2024 NAHB Student Competitions. He has previously consulted at John Burns Research and Consulting.

Barn Swallow is small on purpose. There is no junior analyst you'll be handed to.

Get in touch

Tell us what number you're being asked to defend.

A barn swallow perched on a branch Photo by Bill Ray