HomeProjectsSibedas PBG — Regional Government Data Platform
2023 – presentAutomation & Analytics Lead (PUTR)Live in production
Sibedas PBG — Regional Government Data Platform
Replaced static weekly reports for Bandung's permits department — leadership now queries KPIs in plain language. Permit fees calculate automatically from rules the policy team can update themselves, no developer needed.
Highlights
- First plain-language analytics for leadership in a Bandung government agency
- Pulls data automatically from the national permits portal — no manual download
- Fee rules can be updated by the policy team without touching code
Problem
Bandung's permits department had no single view over regional data scattered across the national permits portal, spreadsheets, and manual department reports — covering building permits, small-business records, tourism, and spatial plans. Leadership read static weekly reports that were already stale by the time they arrived.
Approach
- Automatically pulls fresh data from the national permits portal in the background, with retries when the source is down
- Two-way sync with Google Sheets so non-technical staff keep working in the tool they already know
- Permit-fee calculation runs from a rule engine the policy team can update themselves — no developer needed when rules change
- Dashboard suite: regional resumes, tourism growth, spatial-plan gap analysis, satellite monitoring, opportunity analytics
- Chatbot Pimpinan — leadership asks 'how many permits last week?' in plain language and gets an answer, replacing the wait-for-the-analyst loop
- Granular access control so each role only sees what they should — set per menu, per action
Stack
Laravel 11PHP 8.2MariaDBViteReactApexChartsOpenAI APIGoogle Sheets APIDockerNginx
Outcome
- Live at sibedaspbg.cloud, in daily use by department staff
- Leadership self-serves answers from the data instead of waiting for weekly reports
- Automatic fee calculation replaces a manual process that used to produce errors
Tags