The Micro-Insurance Dashboard in Power BI answers the question every low-cost insurance program asks: which products, channels and partners earn their premium, and where do claims eat it? It reports written premium, policies, retention, claims and loss ratio across five interactive pages. The sample model holds 500 policy batches for FY2025 with $34.43M in written premium, 728,608 policies sold, $14.98M in claims paid, a 43.5% loss ratio and 89.5% retention.
Watch the Micro-Insurance Dashboard in Power BI walkthrough
Micro-insurance sells small policies, often a few dollars a week, through apps, retailers, employers and agent networks. Volumes are high and tickets are small, so margin hides in commission, acquisition cost and claim frequency. Policy data sits in partner reports and claims in another system. This micro insurance dashboard in Power BI puts it all in one model you refresh from a single workbook.
Key Features of the Micro-Insurance Dashboard in Power BI
- Loss ratio you can act on. Loss Ratio % (43.5% in the sample) is claims paid divided by written premium, shown by month, product line, state and region.
- Six product lines side by side. Pet Micro Health runs a 52.3% loss ratio in the sample while Travel Micro Cover runs 30.2%, and Gig Worker Accident brings 36.2% of all premium.
- Channel and partner economics. Commission % runs from about 10% through the Mobile App to about 24.5% through the Agent Network, with acquisition cost per policy ($4.60) and retention by channel.
- Claims monitoring. Claims filed, claim approval % (84.1%), average claim size ($716.78) and average settlement days (6.9), with the Mobile App settling in 4.7 days.
- Retention and lapse. Retention Rate % (89.5%), Lapse Rate % and retention by payment frequency and channel.
- Five filters on every page. Date Range, Region, Product Line and Distribution Channel, plus one page-specific slicer.
- Drill-through and tooltips. A hidden Details page lists the policy batches behind any chart, and two tooltip pages add context on hover.
- Open and editable. 43 DAX measures, every visual and every colour can be changed in Power BI Desktop.
Dashboard Pages Explained
Page 1: Overview
Four sparkline cards show Written Premium ($34.43M), Policies Sold (728,608), Claims Paid ($14.98M) and Loss Ratio (43.5%), each with a month-on-month change (December 2025 against November 2025). A Policy Retention card (89.5%) sits beside Avg Premium per Policy ($47.25), Claim Approval % (84.1%) and Avg. Customer Rating (4.2). Charts show Written Premium and Loss Ratio % by Month, Written Premium by Product Line, Policies Sold by Distribution Channel and Policies Sold by Customer Segment. Gig Worker Accident brings $12.46M, or 36.2% of all premium.
Page 2: Premium Trends
Cards for Total Written Premium, Avg Premium per Policy, Total Policies Sold (728,608), Total Active Policies (652,316) and Digital Share % (56.6%). Policies Sold and Retention Rate % by Month sits next to Avg Premium per Policy by Month, and a Monthly Scorecard lists policies, premium, claims paid, loss ratio and retention for every month. December is the busiest month with 74,939 policies, and the average premium per policy ranges from about $40 in February to almost $53 in July.
Page 3: Products & Segments
Cards for Avg Premium per Policy, Loss Ratio % (43.5%), Retention Rate % (89.5%), Lapse Rate % (10.5%) and Claim Frequency % (3.4%). The Product Line Scorecard compares all six products on policies, premium, loss ratio and a premium share bar. Pet Micro Health has the highest loss ratio at 52.3% and Travel Micro Cover the lowest at 30.2%. Other visuals are Policies Sold vs Active Policies by Customer Segment, Claims Paid and Loss Ratio % by Product Line, and Retention Rate % by Payment Frequency, where Pay-Per-Use customers keep their cover best (91.0%) and Weekly payers least (86.9%).
Page 4: Channels & Partners
Cards for Total Commission ($5,463,248), Commission % (15.9%), Acquisition Cost per Policy ($4.60), Digital Share % and Retention Rate %. Policies Sold by Partner ranks all 14 partners, led by ShieldNow App with 211,873 policies. A Written Premium by Region and Distribution Channel grid shows the South as the largest region at $11.37M, and Written Premium and Commission % by Channel shows what each channel really costs: the Mobile App pays the lowest commission, the Agent Network the highest at about 24.5%. Retention Rate % by Channel puts Employer Payroll on top at 91.6%.
Page 5: Claims & Markets
Cards for Total Claims Filed (24,841), Total Claims Paid ($14,982,196), Claim Approval % (84.1%), Avg Claim Size ($716.78) and Avg. Settlement Days (6.9). Loss Ratio % by State ranks 12 states, from Arizona at 46.6% down to Georgia at 40.4%. Claims Paid and Claim Approval % by Month, Avg. Settlement Days by Channel (Mobile App settles in 4.7 days against about 7.7 for the other channels) and Written Premium vs Claims Paid by Region complete the page.
The file also includes a Get More Dashboards page, the hidden Details drill-through page and two tooltip pages. The data model is one table of 500 policy batches and 22 columns plus a Date table.
Micro-Insurance Dashboard vs. Custom BI vs. Insurance Analytics Software
| Feature | This Power BI template | Custom Tableau / Qlik build | Insurance analytics software |
|---|---|---|---|
| Cost | One-time purchase | Licences plus build time | Usually a subscription |
| Ready-made micro-insurance pages | Yes, five pages | No | Depends on vendor |
| Loss ratio by product and state | Yes | If you build it | Often |
| Commission and acquisition cost by channel | Yes | If you build it | Varies |
| Edit measures and visuals | Full access | Full access | Limited |
| Live policy admin connection | No, you load an export | Possible with development | Usually yes |
| Data stays on your machine | Yes | Depends | Often no |
Who Should Use This Template
Micro-insurance and embedded insurance programs, insurtech start-ups, managing general agents, insurance partners and analysts who report on small-ticket policies sold through apps, retailers, employers and agent networks. It is not a fit if you need live policy feeds, claims handling, underwriting or pricing tools, or regulatory filings. This is a reporting template that reads a workbook you fill or export, and it gives no actuarial or financial advice.
Real-World Use Cases
- Product review: compare loss ratio and premium by product line to decide which covers to reprice or retire.
- Partner terms: show commission %, retention and policies sold by partner before renewing a contract.
- Channel mix: track Digital Share % (56.6% in the sample) and acquisition cost per policy as sales move to the app.
- Claims monitoring: follow approval %, average claim size and settlement days by channel and state.
- Monthly reporting: one view of premium, retention and loss ratio for a board or partner meeting.
Advantages
- Premium, claims, commission and retention by product, channel, partner and state in one model.
- One-time purchase with no per-seat fee.
- Every measure and visual is open, so you can add your own KPIs.
- Your data stays in your own file and your own Power BI tenant.
Opportunities for Improvement
- There is no live connection to a policy administration or claims system. You export and paste data, or ask a developer to repoint Power Query.
- The Power Query source path points at our build folder, so you must use Change Source once after download.
- Data is held at batch level, so questions about a single policy or claim need a more detailed table.
Best Practices
- Keep product, channel and partner names spelled the same every month so slicers stay clean.
- Load claims paid and commission exactly as booked, or the loss ratio and commission % will look better than they are.
- Refresh after every month close and review the Products & Segments page before any repricing decision.
Explore Relevant Templates
- Insurance Tech Startups Dashboard in Power BI
- Agri Insurance Dashboard in Power BI
- Microfinance Institutions Dashboard in Power BI
- Insurance Agency Management System Web App
Frequently Asked Questions
What does this micro-insurance dashboard measure?
Written premium, policies sold, active and lapsed policies, retention, claims filed and paid, loss ratio, claim approval %, average claim size, settlement days, commission, acquisition cost and digital share, split by month, region, state, product line, channel, partner, segment and payment frequency.
Does it connect to my policy administration system?
No. It reads Data.xlsx. You paste or export your data into the workbook and press Refresh.
Do I need a paid Power BI licence?
No. Power BI Desktop is free from Microsoft. You only need Pro or Premium to publish and share the report in the Power BI Service. See Microsoft’s Power BI Desktop overview.
How long does setup take?
About 10 minutes once your data matches the column headers: paste the rows, change the source path once and refresh.
Is the sample data real?
No. Partners, batches and figures are fictional and only demonstrate the visuals.
About the Author
Built by PK, Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience and founder of NextGenTemplates. Watch the tutorials on @PKAnExcelExpert and @NextGenTemplates.
Conclusion
Small policies make it easy to grow premium and hard to see what you keep after claims, commission and acquisition cost. The Micro-Insurance Dashboard in Power BI shows premium, loss ratio, retention and channel economics together, by product, partner and state, so repricing and partner decisions rest on margin and not on volume alone.
