Public Data Project

Multi-City Financial Performance Power BI Dashboard

The Multi-City Financial Performance Power BI tool is developed to analyze and visualize public finance data using the Annual Comprehensive Financial Report(ACFR).

It provides a structured, multi-layered view of fiscal performance, enabling users to explore:

  • High-level financial comparisons across fiscal years and cities

  • Detailed fund-level financial analysis

  • General Fund budgeted appropriations compared with actual expenditures.

This Power BI tool supports seamless navigation from summary-level insights to detailed financial breakdowns within a single integrated dashboard.

💬
City Finance Assistant
Sunnyvale · Cupertino · Mountain View
Sunnyvale revenue 2022
Cupertino expense trend
Best net position year
Sunnyvale vs. Mountain View — Financial Comparison (FY2015–FY2026)

Sunnyvale vs. Mountain View, CA — Financial Comparison

Data drawn from each city's audited Annual Comprehensive Financial Reports (ACFRs), CalPERS actuarial valuations, and adopted budgets, fiscal years 2012–26 (July–June). FY2026 (ending June 2026) has no audited report yet; those points are budget estimates, shown dashed. Hover any chart for exact values. Shaded bands mark the shared COVID-era shock (dip → rebound); dashed vertical flags mark one-time, city-specific events (a bond issuance, a one-year pension valuation spike).

Sunnyvale
Mountain View
┄┄ dashed = budget estimate (not yet audited)
Built from ACFR statistical sections, MD&A, RSI schedules, and Notes to the Financial Statements for both cities; CalPERS actuarial valuation reports; and each city's adopted budget documents. Some line items differ in accounting basis between cities (noted per section) because that is how each city's own statistical section reports them. Values labeled "estimate" are unaudited budget figures for FY2025–26, the fiscal year most recently ended, for which neither city has published an audited ACFR as of August 2026. Hover any chart point, or use "Show data tables" above, to see exact sourced values.