Personal Project · Insurance Operations Tooling

Insurance
BrokerIQ
Dashboard

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
  • Advanced analytics: growth rate, seasonality, top/bottom performers
🔽

Data Input & Mapping

  • Excel (.xlsx) drag-and-drop upload via SheetJS
  • Intelligent column mapping UI — no code editing needed
  • Demo mode with sample data for first-time users
  • Manual data entry form as fallback
📅

Period Filtering

  • Filter by full year, quarter (Q1–Q4), semester, or individual month
  • All KPIs, charts, tables recalculate instantly on filter change
  • Filter state persists across navigation tabs
🔑

License Key System

  • Built-in trial period management with key activation
  • Companion key generator for time-limited client keys
  • Base64 + salt + checksum encoding — tamper-evident
  • Supports client IDs with any format (e.g. PT-001-JKT)
Problem Solved
Before BrokerIQ
  • Raw data sits in Excel with no visual summary
  • Manual calculation required for brokerage ratios
  • No easy way to compare branch performance
  • Period comparison requires building pivot tables
  • Reports take hours to format manually
  • No access control for sensitive financial data
After BrokerIQ
  • KPIs visible at a glance with color-coded indicators
  • Ratios auto-calculated from uploaded data
  • Ranked branch table with performance bars
  • One-click quarter/month filtering across all views
  • Export-ready PDF and Excel report in one click
  • License key system with expiry and client ID binding
Tech Stack
HTML5
CSS3
Vanilla JavaScript
Chart.js
SheetJS (XLSX)
Single .html file
Zero server required
White-label ready
PDF export
Excel export
Skills Demonstrated
Data & Analytics
KPI definition Period trend analysis Growth rate calc Branch benchmarking Data aggregation
Dashboard Design
Chart.js viz Responsive UI Dark-mode aesthetic UX-focused filters Print-ready PDF
Operations Thinking
Insurance domain Access control design White-label delivery Iterative dev (v14) Zero-dependency