Give every claims question a clear business definition.
Connect the meaning behind premium collections, claims payments and recoveries to the analysis your teams use. Duodata gives business and data teams a shared foundation for insurance reporting and AI workflows.
- For:
- Insurance finance and operations · Claims analytics · Business analysts · BI and data teams
- Industry:
- Insurance
The questions
- “How did claims payments change relative to premium collections?”
- “Which payments and recoveries belong in this reporting period?”
- “How do we carry an agreed definition into the data platform and the next AI question?”
One insurance question, with the calculation made explicit
Question
“Premium collections grew. Why did our net claims payment ratio rise?”
Net claims payment ratio · All lines
Premium collections grew 10.0%. Net claims payments grew 34.4%.
The net claims payment ratio rose from 45% to 55%. The Motor line accounts for the $310,000 increase in net claims payments.
Next question: how much of the Motor change in net claims payments comes from payment volume, payment size or timing?
Fictional dataset (USD)
| Quarter | Line | Collections | Payments | Recoveries | Ratio |
|---|---|---|---|---|---|
| Q2 | Motor | $1,200,000 | $660,000 | $60,000 | 50.0% |
| Q2 | Property | $800,000 | $340,000 | $40,000 | 37.5% |
| Q3 | Motor | $1,400,000 | $980,000 | $70,000 | 65.0% |
| Q3 | Property | $800,000 | $340,000 | $40,000 | 37.5% |
| Q2 | All lines | $2,000,000 | $1,000,000 | $100,000 | 45.0% |
| Q3 | All lines | $2,200,000 | $1,320,000 | $110,000 | 55.0% |
Fictional teaching dataset. A defined operating cash measure, not an accounting, regulatory or performance statement about any insurer.
From definition to shared understanding
- 01
Make the business definition explicit
Agree which payments, recoveries and reporting dates belong in the measure. Keep its meaning and responsible owner visible to the people who use the result.
- 02
Connect it to the data
Map the definition to the fields and calculations on your platform. Business and data teams can inspect the relationship between the question and the implemented measure.
- 03
Carry the meaning into AI analysis
Give AI workflows a shared reference for the metric, its scope and its relationships. Use the first answer to identify the next useful question and keep new definitions reviewable.
Connect the question to the implementation.
Follow the metric from business definition into schema mappings, platform semantics and the AI workflow. Explore the Snowflake and Databricks implementations at the depth your team needs.
Bring your use case
Bring a claims, premium or reporting question your team wants to answer with AI.
- 01One business question
- 02One owner of the definition
- 03The data it depends on
- 04The result you expect
- Bring your use case