We have upgraded several of our core financial dashboards using Tableau Public. These new interactive reports process data faster, offer real-time filtering, and provide deeper insights into city spending and revenue trends.
Need a custom report? Our team offers dedicated services to build new, tailored dashboards. If there is specific information you need to track or if you would like to request a new Tableau report, please reach out so we can design the tools you need to succeed.
Interactive dashboard comparing allocated budgeted expenses against actual spending.
High-level overview of areas currently operating under or over their allocated budgets.
Detailed breakdown of budget variances filtered by specific departments and divisions.
Tracks overall expenditure across various city departments.
Granular view of spending categorized by individual divisions.
Analyzes spending patterns and financial trends over time.
Highlights the largest areas of expenditure across the organization.
Monitors expenditures drawn from specific funding sources and accounts.
Historical tracking of budget variances across multiple fiscal years.
Compares projected revenues against actual income generated.
Breaks down incoming revenue by its originating source.
Identifies departments over or under-spending relative to revised budgets.
A matrix view of specific cost types (Salaries, Supplies, etc.) across all departments.
Visualizes primary income streams like Property Taxes vs. Federal Grants.
Evaluates the health of specific funds by comparing total income to total spending.
Monitors year-over-year spending growth to identify long-term city trends.
Analyzes the balance between fixed staffing costs and discretionary service costs.
Monitors structural deficit risks by comparing payroll growth to tax revenue growth.
Determines 'pivot speed' by tagging Mandatory vs. Discretionary spending.
Ensures a healthy ratio of maintenance spending to prevent deferred backlogs.
Identifying organizational vulnerability by mapping grant revenues.
Projects year-end totals to ensure departments don't exhaust funds early.
Forecasts how many months of 'runway' each department has based on velocity.
Dual-axis tracking of cumulative Revenue vs. Expenses for cash flow health.
Tracks progress and investment for specific infrastructure initiatives.
Compares similar subdivisions (e.g. Libraries) to identify efficiency outliers.
High-level summary of executive payroll figures and compensation.
Detailed breakdown of overtime hours and associated costs.
Payroll expenditures categorized by specific city departments.
Headcount tracking and staffing levels across the organization.
Analysis of payroll distribution across different job positions.
Overall payroll data, insights, and structural distributions.