A full-stack fiscal intelligence dashboard built for Bappeda Litbang Kota Palembang to monitor and analyze the city's regional budget (APBD).
Developed using PHP, Vanilla JavaScript, MySQL, and Chart.js, and deployed on shared hosting without frameworks or build tools.
Key Features
Real-Time Budget Monitoring
- Real-time surveillance across thousands of APBD spending lines.
- Multi-year data import from SIPD Excel exports.
- Interactive visualizations for:
- Budget composition analysis
- Top SKPD spending
- Procurement and expenditure data
Fiscal Intelligence & Analytics
- Fiscal anomaly detection and highlighting module.
- AI-powered narrative analysis using:
- NVIDIA NIM
- DeepSeek
- Full-text search engine with advanced filters:
- SKPD
- Spending type
- Funding source
- Budget range
Priority Alignment & Tagging System
Later versions introduced an integrated tagging framework to strengthen policy alignment and budget analysis:
Priority Program Tagging
Links APBD programs and activities to:
- National priorities
- Provincial priorities
- City priorities
SIPD Thematic Tagging
Cross-references sub-activities against national thematic priorities, including:
- Stunting reduction
- Gender-responsive budgeting
- Climate change
- Other national development themes
KDH Priority Tagging
Maps budget lines directly to the Mayor's priority programs:
- Palembang CERDAS
- Palembang BELAGAK
- Palembang SEHAT
- Palembang GERCEP
- Palembang PEDULI
Reporting & Visualization
- Downloadable charts and tables
- Interactive dashboards
- Budget exploration and analysis tools
Deployment: Shared Hosting
