Sample dashboard. Sample City is fictional and every figure is generated sample data, not any real agency. Built by BI Consulting Services to show how a city scorecard can work in Power BI.

Sample City, TX

Municipal Operations Scorecard

Systems we build and run

BI Consulting Services
Microsoft Partner
powerbiconsultingservices.com

Overview

Fiscal year runs Oct to Sep. Data through Sep 2026.

Department Period

Service requests per month and share closed within target

Open backlog by department

Service requests by category

Average review days by permit type (target 10)

Permits issued

General Fund, year to date spend against adopted budget

Ask the data (example of a staff-facing assistant)

Pick a question

Answers are drafted from the scorecard tables and show their source. Anything sent outside the department is approved by staff first.