labs@atheron:~/industries/housing/data$ query --warehouse --dashboards

Housing data

Vacancy, arrears and repairs, on one board dashboard.

A housing board needs a few numbers it can trust: vacancies, arrears, repairs and the state of the reserve fund. They usually live in four systems and a spreadsheet. We bring them together every night into one small warehouse and one dashboard, with the source of every figure a click away.

Start a project See the example projects

// what matters here

What is different in this industry.

Every figure has a source

Each number links back to the system and the record it came from, so the board can ask where it came from.

By building and over time

Vacancy, arrears and open work orders by building and by month, so trends show before they become problems.

Reserve fund data as recorded

Components and remaining life as your reserve fund consultant recorded them. We present the data; your consultant signs the study.

Run for you

Hosted, monitored and backed up, with loads that warn your staff when a source system fails.

// example projects

Priced examples for this service.

Each one is hypothetical, labelled as such, and priced live from our rate card. Open any of them in the estimator and make it yours.

Example projectWeb app

Portfolio and reserve fund dashboard

Hypothetical. Not a client, not a result.

// The problem

A housing society with many buildings has vacancies in its property system, work orders in another, arrears in its accounting software and reserve fund component data in a consultant's spreadsheet, and the board sees none of it together.

// What we would build

A dashboard for the board and senior staff that pulls vacancy, arrears, work orders and reserve fund component data into one small warehouse every night, with the building, the trend and the source behind every figure. We run it on managed cloud hosting with monitoring and backups. The reserve fund figures are your consultant's; we present them, we do not certify them.

// What is in it

Vacancy, turnover and days to re-let by building
Arrears and collections from your accounting system
Open and overdue work orders by building and trade
Reserve fund components with their remaining life, as your consultant recorded them
A nightly load into one warehouse, with the source of every figure
Managed hosting with monitoring, backups and updates

// Stack

Next.js
PostgreSQL
dbt
Property and accounting system APIs
AWS Canada

// estimate

Build: ≈ US$66,600 to US$102,000, delivered within 16 weeksCAD 94,800 to 144,900
Hosting: ≈ US$492 a monthCAD 700 a month
Support: ≈ US$5,010 a monthCAD 7,135 a month

Prices in your currency are estimates from today's Bank of Canada rate. All invoicing is in CAD or USD.

Timeline by milestone

Discovery: 2.9 to 3.4 weeks
Design approved: 2.4 to 3.9 weeks
Core features: 2.4 to 3.9 weeks
Full build: 1.4 to 2.4 weeks
Testing and fixes: 0.9 to 1.4 weeks
Launch: 0.9 to 1.4 weeks

Outside our hands, and added to the calendar

API access from each software vendor: 1 to 4 weeks

How it is paid

Deposit 20%: CAD 18,960 to 28,980
Discovery 7.7%: CAD 7,299.60 to 11,157.30
Design approved 7.7%: CAD 7,299.60 to 11,157.30
Core features 23.3%: CAD 22,088.40 to 33,761.70
Full build 15.5%: CAD 14,694.00 to 22,459.50
Testing and fixes 7.7%: CAD 7,299.60 to 11,157.30
Launch 8.1%: CAD 7,678.80 to 11,736.90
Holdback, 30 days after launch (10%): CAD 9,480 to 14,490

Start from this example

// questions

Questions we get about this.

Can the housing dashboard read our property management system?

If it has a published API or a scheduled export, yes. We check yours before we quote.

Does the dashboard replace our reserve fund study?

No. The study is your consultant's. The dashboard shows its component data beside your repairs and spending.

Who can see the board dashboard?

Whoever you choose: usually the board and senior staff, with access set by role and every view logged.

Back to the industry: Housing co-ops and property management About the service: Data and analytics

// next

Not quite your project?

Tell us what you have in mind. We will come back to you with a range and the questions that would narrow it. Or book a call and talk it through.

Start a project Book a call