All projects
Dashboard
2026
Monitoring Dashboard
Ten monitoring views for SPM, IPKM, SKDR, Posyandu, and environmental health, with PIN-protected input and printable reports.
- RoleDesign & development
- Year2026
- ClientUPTD Puskesmas Separi III
- TypeDashboard
- StatusLive
01Context
SPM, IPKM, SKDR, Posyandu, and environmental health data lived in separate Excel sheets. Every month staff rebuilt charts and report narratives, while leaders needed a quick view without waiting for the recap.
02Approach
- 01
Normalised data into Google Sheets and defined rules for achievement, running targets, and IPKM indices.
- 02
Built ten monitoring views with Chart.js, heatmaps, per-village tables, and a month selector.
- 03
Added PIN-protected data entry, a five-minute cache, automatic narratives, and PDF printing.
03Outcome
- One dashboard replaced the monthly manual chart assembly.
- Monthly and quarterly monitoring no longer requires opening many files.
- Reports and data-quality notes can be printed directly from the dashboard.