Operations data warehouse
Hypothetical. Not a client, not a result.
// The problem
A utility's operators see SCADA only in the control room, lab results live in spreadsheets, and the monthly report data and the council's dashboard are assembled by hand from both.
// What we would build
A data warehouse that reads SCADA historian data through a read-only connection, takes in lab results and billing consumption, and shows dashboards for operators, managers and council. It prepares report data for your responsible operator to review and submit. Nothing is ever written back to SCADA or any control system.
// What is in it
- Historian data read through a one-way, read-only connection your control systems team approves
- Lab results imported from your lab's files, with the sample, method and chain of custody kept
- Consumption by zone from billing, set against production, to see water loss
- Dashboards for operators, managers and council, each with what they need
- Report data prepared from the records for your responsible operator to review and submit
- Hosting, backups and monitoring run for you in a Canadian region
// Stack
- PostgreSQL
- dbt
- Historian API (read-only)
- Next.js
- Apache Superset
- AWS Canada
// estimate
- Build
- ≈ US$89,700 to US$137,000, delivered within 19 weeksCAD 127,800 to 195,500
- 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.9 to 4.9 weeks
- Core features
- 2.9 to 4.4 weeks
- Full build
- 1.9 to 2.9 weeks
- Testing and fixes
- 0.9 weeks
- Report data reconciled against a past period
- 0.9 to 1.4 weeks
- Launch
- 0.9 to 1.4 weeks
Outside our hands, and added to the calendar
- Billing system API access from your vendor
- 1 to 4 weeks
- Your control systems team's review of the read-only connection
- 4 to 8 weeks
How it is paid
- Deposit 20%
- CAD 25,560 to 39,100
- Discovery 6.8%
- CAD 8,690.40 to 13,294.00
- Design approved 6.8%
- CAD 8,690.40 to 13,294.00
- Core features 20.4%
- CAD 26,071.20 to 39,882.00
- Full build 13.6%
- CAD 17,380.80 to 26,588.00
- Testing and fixes 6.8%
- CAD 8,690.40 to 13,294.00
- Report data reconciled against a past period 8.7%
- CAD 11,118.60 to 17,008.50
- Launch 6.9%
- CAD 8,818.20 to 13,489.50
- Holdback, 30 days after launch (10%)
- CAD 12,780 to 19,550