County Revenue Dashboard
A Power BI dashboard for tracking county government revenue streams, budget allocations, and expenditure trends with interactive drill-down reports.
Overview
An interactive data visualization dashboard built for a county government finance department. The dashboard consolidates revenue data from multiple sources and provides real-time insights into budget performance, revenue collection, and expenditure patterns.
Key Features
- Revenue Tracking: Monitor tax collections, grants, and other revenue streams in real-time
- Budget Comparison: Compare actual spending against budgeted amounts by department
- Trend Analysis: Year-over-year and month-over-month trend visualizations
- Drill-Down Reports: Click through from summary views to detailed transaction data
- Automated Alerts: Email notifications when spending exceeds thresholds
Technical Details
Data is sourced from PostgreSQL databases and CSV exports from legacy financial systems. A Python ETL pipeline runs nightly to clean, transform, and load data into a Power BI data model with optimized star schema design.
Data Architecture
- Extract: Python scripts pull from 3 database sources and 5 file-based sources
- Transform: Pandas pipelines handle deduplication, currency normalization, and category mapping
- Load: Transformed data pushed to a Power BI dataset via the REST API
Impact
The dashboard reduced monthly reporting time from 2 weeks to 2 days and helped identify a 15% cost reduction opportunity in procurement spending.