Questions & Answers
Frequently Asked Questions
Common questions about Analytics Bi
Civic Insight is a purpose-built analytics and business intelligence platform designed exclusively for Canadian municipal government. Unlike commercial BI tools, it includes pre-built municipal analytics (financial health, FIR, MBN benchmarking, ward-level analysis), Ontario regulatory compliance (MFIPPA, AODA, Municipal Act), an integrated open data portal, and municipal-specific predictive models (revenue forecasting, budget variance, service demand). It ships as a self-hosted platform with full source code — no per-seat SaaS fees.
No. The platform includes a drag-and-drop dashboard builder, natural language query interface (ask questions in plain English or French), and pre-built municipal analytics. Staff create dashboards in minutes without SQL or coding. The NLP engine understands municipal terminology — wards, departments, GL accounts, case types — so queries like 'show me service request volumes by ward for the last year' return instant visualizations. Power users can also write SQL for advanced analysis.
Yes. The Civic Insight data warehouse exposes standard ODBC/JDBC connections, so Power BI, Tableau, or any SQL-compatible BI tool can query the warehouse directly. This allows a gradual transition or hybrid approach where some departments use Civic Insight's dashboards and others use their existing BI tools — both drawing from the same authoritative data source.
Civic Insight integrates deeply with all Civic platform modules — ERP (GL, budget, AP/AR), CRM (service requests, constituent interactions), Property Tax (assessment, billing, collection), Utility Billing (consumption, billing), and Asset Management (inventory, condition, work orders). It also supports legacy system import via CSV, Excel, ODBC/JDBC, and external data integration with MPAC, Statistics Canada, MBN, and IoT/SCADA sensor data.
The Open Data Publishing module provides a complete solution — dataset selection, automated anonymization (k-anonymity, PII removal, generalization), metadata tagging (Dublin Core/DCAT), and publication to a public-facing catalog with search, preview, and API access. Datasets refresh automatically on configurable schedules. The portal complies with Ontario's Open Data Directive and the Open Government Licence – Ontario. Community engagement metrics track downloads, API usage, and search patterns.
Still Have Questions?
Have a Question Not Listed Here?
Our municipal solutions team is available to answer technical, procurement, and implementation questions specific to your organization.