A public-facing interactive Power BI app developed to provide a transparent and comprehensive
view of the
city's annual budget. The report has multiple perspectives, from a high-level Consolidated
Budget to
breakdowns of the city's main General Fund. Users can explore aspects of the city's finances,
including
revenues, expenditures, department-fund relationships, and a listing of budgeted
positions.
A public-facing dashboard developed to provide the residents of Laredo
with transparent, interactive data on 311 service requests. The project's
goal was to allow users to easily explore requests by assigned department,
request type, and council district.
The Challenge: Project-based businesses often struggle to track expenses across multiple
projects, managers, and cost categories. Relying on static spreadsheets leads to out-of-date
information, making it nearly impossible to identify budget overruns before they impact the
bottom line.
The Solution:
I developed a comprehensive, one-page Power BI dashboard to provide a single source of truth for
project financials. The report features advanced interactivity, including dynamic parameters
that allow users to instantly change chart dimensions (e.g., "Analyze By" Project or Expense
Category) and toggle the metrics displayed in the detailed matrix with a single click.
The Impact:
This dashboard replaces hours of manual reporting with an on-demand, holistic view of budget vs.
actual spending. It empowers executives and project managers to instantly spot trends, identify
areas of overspending, and make proactive, data-driven decisions that protect profitability.
Key Features:
- ✓ Dynamic KPIs (Total Expenses, Budget, Variance)
- ✓ Interactive Slicers for Time & Project Hierarchy
- ✓ Parameter-driven visuals for flexible analysis
- ✓ Trend analysis and detailed drill-down matrix