A custom-built, single-file insurance broker performance dashboard that turns raw Excel data into clear, actionable visual reports — no server, no database, no setup required.
v14
Iterations
0
Dependencies
1 file
Delivery
HTML/JS
Tech Stack
Live KPI Snapshot
Built to address a real gap in insurance brokerage operations: teams collecting data in spreadsheets but lacking a structured way to visualize KPIs, track branch performance, or analyze trends — without requiring any technical setup.
v14
Total Premium
Rp 98.6M
↑ YoY growth indicator
Total Brokerage
Rp 18.1M
↑ Auto-calculated
Brokerage Ratio
18.3%
↑ From raw data
Active Policies
375
↑ Period-filtered
Features Built
📊
Data Visualisation
Monthly bar + line combo chart (premium vs brokerage)
Branch distribution donut chart by insurance partner
Branch ranking table with performance bars + retention KPI