Services

Service 02

Municipal Data Stack

Unified operational data for municipalities, utilities, and school boards. Live dashboards. Audit-ready reporting.

Start this engagement Estimate your project
Typical range:
45,000–90,000 CAD
Typical duration
10–16 Weeks

Target outcomes

  • 3+ data sources unified
  • 2 days target reporting cycle (from 3 weeks)
  • 10 wk kickoff to live dashboards

This is right for you if

  • Your operations team produces monthly reports by manually pulling from 3+ systems
  • Annual audits expose data inconsistencies between your financial and operational records
  • You have no real-time operational dashboard

Why TSI

  • Public-sector reporting built in: data governance, bilingual output, and audit trails
  • Milestone-based delivery: signed acceptance at each phase before next phase starts
  • Hosted in Quebec (OVHcloud, Beauharnois) or on your own servers; by contract, no personal data is processed outside Canada without your written consent

Reference scenario

A typical Quebec regional school board with operations data spread across 4 separate systems: student management, finance, HR, and facilities, with annual reporting requiring weeks of manual reconciliation.

The engagement builds n8n pipelines connecting all four sources to a central PostgreSQL store with Apache Superset dashboards. Representative outcome: reporting cycle cut from weeks to a couple of days, with live dashboards for all decision-makers.

Illustrative reference scenario, not a completed TSI engagement.

What to expect

  • Week 1–2: We inventory all your data sources and map every field that needs to flow between them.
  • Week 3–4: Data model and pipeline architecture signed off by you.
  • Weeks 5–10: Pipelines built, tested, and staged. Dashboard layer built in parallel.
  • Week 11–14: Parallel run, new system and existing process run simultaneously.
  • Week 15: Full cutover with your team trained on the dashboards.

Delivery phases

  1. Source Inventory
  2. Data Model Design
  3. Pipeline Build
  4. Dashboard Build
  5. Parallel Run
  6. Cutover & Training

Deliverables and technology

What you receive

  • Integration pipeline (all sources → central store)
  • Apache Superset dashboards
  • Role-based user access
  • Data dictionary
  • Change documentation
  • 30-day post-launch support

Typical technology

  • n8n
  • FastAPI
  • PostgreSQL
  • Apache Superset
  • Docker
  • Nginx

What drives the price

Lower end

  • Three data sources
  • Monthly reporting only
  • No live dashboards
  • Existing server
  • Standard chart types

Upper end

  • Five or more sources
  • Real-time dashboards
  • Multi-department access control
  • New server provisioning
  • Custom alert logic and compliance reporting

Biggest variable: Number of data sources × reporting complexity × dashboard user count

Read next

  • For municipalities Office software hosted in Quebec for municipalities and public bodies: citizen data in Quebec, free software, guaranteed exit.

Ready to talk about it?

Describe your situation, a person reads every message and answers with a proposed scope for the first phase.

Start this engagement All services