Technical steering — loss ratio
Steer your technical profitability: combined ratio, frequency and average cost of claims by product.
Combined ratioLoss ratioClaim frequency
Open template →
Insurance · SAP Analytics Cloud
SAP Analytics Cloud templates for Insurance
4 ready-to-use SAC and SAC Planning templates for Insurance — each with the KPIs, dimensions and realistic data your function actually tracks. Import in minutes, or generate a tailored one. No sign-up.
KPIs we cover for Insurance
Premiums writtenLoss ratioCombined ratioAverage claim costClaim frequencyLapse rateTechnical marginTechnical reserves
Analysis dimensions
Line (Motor/Home/Life)RegionCustomer segmentDistribution channelAge bandUnderwriting year
4 Insurance templates
Each opens with a live preview and a one-click download (.xlsx, .csv, .package).
Solvency — Solvency II
Monitor your capital requirement (SCR/MCR) and the composition of your eligible own funds.
Solvency ratio (SCR)MCREligible own funds
Open template →
Underwriting & new business
Measure your underwriting effectiveness: acceptance rate, average premium and new-business flow.
Acceptance rateAverage premiumNew business
Open template →
Claims management
Manage claims handling: settlement time, reserving ratio and open-claims backlog.
Average claim costSettlement timeReserving ratio
Open template →
How to model Insurance in SAP Analytics Cloud
A solid Insurance model starts with the right grain. Build your dimensions first (Line (Motor/Home/Life), Region, Customer segment), then add the measures that matter (Premiums written, Loss ratio, Combined ratio). The trap is aggregation: amounts and volumes sum, but rates and percentages must use AVERAGE, and stocks or balances must use a LAST exception on the time dimension — otherwise your yearly totals come out wrong.
Set those aggregations once in the Modeler, import your data, and build a Story from the KPIs above. For the full method, see our guides on importing a CSV into SAC and choosing the right aggregation.
Regulated reporting
Insurance compliance, kept current
Working on Solvency II and IFRS 17? The free templates get you started; the verified & maintained kits keep the regulatory bounds correct at every revision.