Reporting & Analytics
The unified business intelligence, dashboard, and report generation layer for the Civic platform — every module that needs dashboards, KPI tracking, ad-hoc reports, or open data publishing plugs into Reporting & Analytics.
Dashboard Load
Data Freshness
Export Limit
Availability
Purpose-Built for Canadian Municipalities
How It Works
The identity journey, step by step
From first registration to golden record resolution — how a resident's identity evolves across the platform.
Treasurer Morning Review
The municipal Treasurer logs in and sees their role-based finance dashboard automatically.
How it works
On login, the Treasurer's default dashboard loads with KPI cards for cash position, budget variance, and revenue collected YTD. They click the budget variance widget to drill into department-level details, spot an overspend in Parks, and click through to the underlying transactions. They export the detail to Excel and email it to the Parks Director.
Step 1 of 5
Purpose & Scope
What this module owns
Clear ownership boundaries prevent duplication and ensure every capability has exactly one authoritative home.
Owns
13Delegated to
4Source data storage
Real-time streaming analytics
Geospatial visualization
AI/ML predictive models
These capabilities are handled by dedicated modules and consumed via stable API contracts — keeping boundaries clean and ownership unambiguous.
Core Capabilities
What it does
4 capability groups comprising 7 discrete capabilities — each with API surface, business rules, and data ownership.
Visual drag-and-drop dashboard builder with a rich widget palette and grid layout for staff at all levels.
Drag-and-Drop
Visual dashboard builder with widget palette and grid layout.
Widget Types
KPI card (with sparkline), bar chart, line chart, pie/donut, area chart, scatter plot, table, pivot table, gauge, heatmap, treemap, map choropleth, text/markdown, image, iframe embed.
Data Sources
Connect widgets to any module's analytics views; multiple data sources per dashboard.
Filters
Dashboard-level filters (date range, department, ward, status, type) that cascade to all widgets.
Drill-Down
Click any chart element to drill into the underlying records.
Auto-Refresh
Configurable refresh interval (default 5 min; real-time option for operations dashboards).
Personal, team, and published dashboards with role-based defaults, responsive layout, and theme support.
Personal Dashboards
Staff can create personal dashboards; admin can create shared/published dashboards.
Role-Based Dashboards
Auto-assign default dashboards based on role (e.g., Treasurer sees Finance dashboard on login).
Responsive
Dashboards adapt to desktop, tablet, and mobile layouts.
Dark/Light Mode
Dashboard rendering supports both themes.
Real-World Scenarios
Who uses this, and how
3 persona-driven scenarios showing how Reporting & Analytics works in practice — from resident registration to privacy compliance.
CFO / Treasurer
Budget vs. Actual Variance Analysis
The CFO needs to present quarterly budget variance to Council with drill-down detail by department.
Steps
- 1CFO opens the pre-built Budget vs. Actual dashboard
- 2Filters to Q3 of the current fiscal year
- 3Reviews KPI cards showing total variance, revenue shortfall, and expenditure overspend
- 4Clicks the department bar chart to drill into Parks & Recreation overspend
- 5Exports the detail report to PDF with conditional formatting (red for >10% variance)
- 6Shares the dashboard link with Council members for the committee meeting
Outcome
Council receives a data-driven budget briefing with drill-down capability. The CFO saved hours of manual report assembly.
View scenario
Performance Analyst
MPMP Performance Benchmarking
The performance analyst needs to compare municipal KPIs against provincial benchmarks for the annual MPMP submission.
Steps
- 1Analyst opens the MPMP regulatory report template
- 2System auto-fills KPI values from the analytics store for the reporting period
- 3Analyst reviews each metric against the MPMP benchmark thresholds
- 4Flags three indicators that are below peer municipality average
- 5Generates the submission-ready report and a supplementary analysis for the CAO
- 6Schedules the benchmarking dashboard to refresh weekly for trend monitoring
Outcome
MPMP submission completed in hours instead of weeks. Ongoing benchmarking dashboard tracks improvement against peer municipalities.
View scenario
Operations Manager
Real-Time Operations Dashboard
The Public Works Director needs a live operations dashboard to monitor snow plow routes, pothole reports, and water main breaks.
Steps
- 1Director creates a personal dashboard with the drag-and-drop builder
- 2Adds a map choropleth widget showing active snow plow GPS locations
- 3Adds a KPI card for open pothole service requests with sparkline trend
- 4Adds a table widget showing active water main breaks with priority and crew assignment
- 5Sets auto-refresh to 1 minute for real-time situational awareness
- 6Publishes the dashboard for the entire Public Works team
Outcome
Real-time situational awareness for the entire operations team. No more morning status calls — the dashboard replaces them.
View scenario
Internal Architecture
How it's built
3 architectural layers comprising 18 components — from API gateway to data quality engine.
3 layers · 18 total components
Reporting & Analytics
Every module owns a single bounded context, exposes stable APIs, and can be composed into any Civic product — that's the architecture that scales.
Krutik Parikh
Creator of Civic
Data Model
Entity Architecture
5 entities with 4 relationships — the authoritative schema for this bounded context.
Entities
Select an entity to explore its fields and relationships
API Surface
Integration Endpoints
13 RESTful endpoints across 4 resource groups — plus 4 domain events for async integration.
/api/v1/dashboards
List dashboards accessible to current user
/api/v1/dashboards
Create new dashboard
/api/v1/dashboards/{id}
Get dashboard with widget data
/api/v1/dashboards/{id}
Update dashboard layout/widgets
Ecosystem
Products that depend on this module
18 Civic products consume Reporting & Analytics — making it one of the most critical platform services in the ecosystem.
ERP / Finance
Financial statements, trial balance, FIR schedules, budget vs. actual
View product →
Property Tax
Tax roll reports, assessment summary, tax arrears aging, levy calculation
View product →
Budget Management
Budget document, department summaries, variance reports, multi-year forecast
View product →
Accounts Payable
AP aging, cheque register, vendor spending analysis
View product →
Accounts Receivable
AR aging, collection rates, outstanding balances
View product →
HR & Payroll
Headcount reports, salary analysis, benefit costs, turnover rates
View product →
CRM / 311
Service request volumes, response times, resolution rates, citizen satisfaction
View product →
Work Orders
Work order backlog, completion rates, cost per work order, preventive vs. reactive
View product →
Licences & Permits
Application volumes, processing times, fee revenue, inspection results
View product →
Asset Management
Asset condition scores, replacement value, maintenance spending, capital plan
View product →
Recreation
Enrollment numbers, facility utilization, revenue per program, drop-in rates
View product →
Utility Billing
Consumption trends, revenue, delinquency rates, rate comparison
View product →
Transit
Ridership, on-time performance, revenue per route, cost per passenger
View product →
Waste & Recycling
Diversion rates, tonnage, collection efficiency, contamination rates
View product →
Climate & ESG
GHG emissions, energy consumption, tree canopy coverage, ESG metrics
View product →
Elections
Voter turnout, poll results, advance vote statistics
View product →
Analytics & BI
This IS the analytics module — self-referential for meta-analytics
View product →
Open Data Portal
All modules can publish datasets through this module
View product →
Technical Specifications
Performance, Compliance & Configuration
Availability
Dashboard Load
Report Execution
Data Freshness
Concurrent Users
Export Size
Data Retention
FAQ
Frequently Asked Questions
Ready to Integrate
Build on Reporting & Analytics
Request an architecture brief, integration guide, or live demo environment for your team.