Financial Analysis · Data Quality · Business Reporting

SF Recreation & Parks
Financial Analysis

How did spending and revenue change at San Francisco's Recreation and Park Department between FY2024 and FY2025? I analyzed public financial records, validated the data, and developed reports to communicate the findings. I then extended the project with interactive Power BI dashboards and a Power Automate workflow that sends report-review notifications.

Tools & Skills Python pandas Matplotlib Excel Power BI Power Automate Data Validation Financial Analysis Business Reporting

What changed between FY2024 and FY2025?

Reported spending increased faster than reported revenue during the two-year period. The analysis identifies where those changes occurred and highlights areas that may benefit from additional management review.

$289.96M FY2025 Reported Spending
+14.55% Spending Change
$199.92M FY2025 Reported Revenue
+3.23% Revenue Change
Comparison of reported spending and revenue in fiscal years 2024 and 2025
Reported spending and revenue increased at different rates. These figures represent reported financial activity, not a calculation of budget variance.
Important interpretation
Spending and revenue are reported financial categories, not necessarily directly comparable measures of financial balance. Their difference does not establish a deficit, and increased spending does not establish overspending.

Turning financial records into useful information

Public financial datasets contain detailed transactions and classifications, but they are not always easy to interpret without additional preparation. Managers need reliable summaries that show what changed, which categories contributed to those changes, and where further questions should be asked.

Questions I investigated

How much did reported spending and revenue change? Which programs and revenue sources contributed most to those changes? How can the results be presented accurately without overstating what the data proves?

Project objective

Build a reproducible analytical workflow and produce understandable financial summaries, visualizations, and management-facing reports using official public data.

Preparing the financial records

I used San Francisco Open Data budget and spending-and-revenue datasets, focusing on the Recreation and Park Department and fiscal years 2024 and 2025.

Stage 01 Collect & filter Select the relevant department, fiscal years, financial measures, and reporting categories.
Stage 02 Validate records Check missing financial amounts, exact duplicates, fiscal-year coverage, and summary reconciliation.
Stage 03 Prepare summaries Group financial activity by year, program, and revenue source for analysis and reporting.

The final checks found no missing financial amounts or exact duplicate records in the selected data. Aggregated summaries reconciled with their underlying selected records for both fiscal years.

Validation boundary
Reconciliation confirms that the calculated summaries agree with the selected records. It does not independently verify every original accounting classification or establish that the source data is complete.

Comparing financial activity consistently

I aggregated reported financial amounts by fiscal year and calculated both dollar changes and percentage changes. I then examined the individual program and revenue categories contributing to the overall movement.

Dollar change

FY2025 reported amount minus FY2024 reported amount. This shows the absolute size and direction of the change.

Percentage change

Dollar change divided by the FY2024 amount, multiplied by 100. This shows the relative change from the earlier year.

Budgeted figures were reviewed separately because budget and reported financial datasets use different structures and classifications. I did not treat a direct subtraction between them as a verified budget-versus-actual variance.

Where did reported spending increase?

Reported spending rose from $253.13 million in FY2024 to $289.96 million in FY2025, an increase of approximately $36.83 million, or 14.55%.

Year-over-year changes in reported spending by program
Spending changes by program between FY2024 and FY2025. Positive changes indicate higher reported amounts, not necessarily unfavorable performance.

Capital-related activities and operating programs accounted for much of the increase. Capital spending increased by approximately $17.60 million, Capital-CPC Funded by $9.97 million, and Operating by $9.51 million.

These movements suggest that capital project timing, funding arrangements, and operational activity are useful areas for follow-up investigation.

Which revenue sources changed?

Reported revenue increased from $193.67 million in FY2024 to $199.92 million in FY2025, an increase of approximately $6.25 million, or 3.23%. Changes varied substantially across revenue sources.

Year-over-year changes in reported revenue by source
Revenue-source changes between FY2024 and FY2025. The direction of a change alone does not establish whether the result was favorable or unfavorable.

Other Financing Sources increased by approximately $20.02 million, while Transfer Adjustment-Source increased by $6.45 million. These increases were partly offset by decreases in Other Revenues ($10.77 million) and Intergovernmental: State ($9.47 million).

The results demonstrate why examining individual revenue sources is more informative than relying on the total revenue change alone.

Making the results useful to decision-makers

I translated the analysis into three visualizations, two Excel reporting workbooks, and a one-page management summary. The goal was to make the findings accessible without requiring readers to understand Python or financial-data processing.

Deliverable 01 Visualizations A financial overview and two category-level charts showing the main changes.
Deliverable 02 Excel workbooks Financial overview, yearly changes, program spending, and revenue-source summary tables.
Deliverable 03 Management memo A concise report communicating findings, interpretation limits, and follow-up areas.

What should managers investigate next?

Priority 01 Review capital spending Examine project schedules, major expenditures, and funding arrangements to understand the capital-related increases.
Priority 02 Monitor revenue composition Investigate changes in financing-related categories and declining revenue sources.
Priority 03 Improve reporting consistency Use clearly defined financial categories, repeatable validation checks, and regular year-over-year reporting.

These are suggested areas for additional analysis, not findings of operational failure or financial mismanagement.

What the data can and cannot establish

This project describes reported financial activity over two fiscal years. It does not establish whether individual expenditures were appropriate, whether budget targets were met, or whether department services became more or less effective.

A key lesson was the importance of separating accurate calculations from unsupported conclusions. A useful financial report should make the results understandable while remaining clear about the limitations of the underlying data.

Independent portfolio project
This analysis uses public San Francisco financial data. It is an independent educational and portfolio project, not an official Recreation and Park Department report or an assessment endorsed by the City and County of San Francisco.

From financial analysis to interactive reporting

I extended the original financial analysis into a two-page Power BI dashboard to make spending and revenue trends easier to explore. The report brings together key financial measures, year-over-year comparisons, and category-level breakdowns in a format designed for management review.

Financial Overview

Seven KPI cards summarize reported financial activity and changes between FY2024 and FY2025, supported by visual comparisons of spending and revenue.

Spending & Revenue Breakdown

Interactive charts allow users to examine spending by program and revenue by source, helping identify categories that may warrant further investigation.

Power BI Financial Overview dashboard showing spending and revenue KPIs
Power BI Financial Overview — FY2024 and FY2025 reported spending and revenue, with KPI cards and comparisons.
Power BI dashboard showing spending by program and revenue by source
Power BI Spending & Revenue Breakdown — category-level reporting for financial review. Click the image to view it at full size.

Key Findings

Spending Operating and capital activity Operating remained the largest spending program, increasing from $209.81M in FY2024 to $219.31M in FY2025. Capital-related spending also increased.
Revenue Changes across revenue sources Property taxes remained a major reported revenue source. Changes in other revenue categories show why reviewing the breakdown matters.
Management Takeaway Focus on the biggest changes Review the spending programs and revenue sources with the largest year-over-year changes to understand the drivers and identify areas for further analysis.

Result: A reusable reporting dashboard that makes the original financial analysis easier to navigate and communicate without requiring users to work directly with Python notebooks or Excel tables.

Automating report-review notifications

I created and tested a Power Automate workflow to demonstrate how routine reporting notifications can be automated. When a new file is added to a designated OneDrive for Business folder, the workflow sends an Outlook email notification containing the file name.

Step 01 New file detected OneDrive for Business detects a newly created file in the monitored folder.
Step 02 Email notification Power Automate sends an Outlook email containing the new file's name.
Step 03 Successful test I tested the workflow and confirmed that the notification email was received.

Result: A working notification workflow demonstrating how teams can reduce manual communication when new reporting files become available.

This is an independent portfolio demonstration, not a City of San Francisco deployment. The workflow sends notifications; it does not validate financial data, approve reports, or refresh Power BI dashboards.

Explore the completed reports

The following reports are available for download. Source code and development notebooks are maintained in a private repository.

PDF Management Summary One-page overview of findings and implications.

Download PDF ↓

Excel Financial Analysis Workbook Structured financial summary tables.

Download Excel ↓

Excel Financial Summaries Yearly and category-level financial summaries.

Download Excel ↓