Insurance

P&C insurance data for policies, premiums, claims, and analytics.

Name: Property & Casualty Insurance Demo Database & BI Pack
Brand: DemoDataWorks
Price: 14.99 USD
Availability: InStock

A complete synthetic property and casualty insurance operations environment spanning quotes and policies, premium billing, claims, reserves, and the general ledger — delivered with multiple database formats, Power BI, SQL examples, validation, and documentation.

28 connected P&C insurance tables

Buy Now Back to Industries

Included Power BI — Executive Overview

Executive Overview Power BI dashboard screenshot

Synthetic data
10 core business industries
CSV, SQLite, DuckDB, Parquet, SQL Server & PostgreSQL
Power BI dashboard included
Validation & documentation

Coherent business flows, not disconnected rows.

Every table connects to the next, so you can trace a single transaction from end to end — and build dashboards that actually reconcile.

Quote to policy

Quote

Policy

Coverage

Premium billing

Premium invoice

Premium payment

General ledger

Claims

Claim

Case reserve

Claim payment

General ledger

What the dataset covers

Customers, agents, and insurance products
Quotes and new-business and renewal policies
Policy coverages and endorsements
Premium billing installments and accounts receivable
Earned and unearned premium
Claims, case reserves, and claim payments
Loss ratio and policy financial summaries
Chart of accounts and general ledger journals

A Power BI dashboard, ready to open.

Every pack includes a populated .pbix dashboard and a reusable .pbit template built directly on top of the dataset.

Portfolio & Claims Power BI dashboard screenshot — Portfolio & Claims
Renewal rate, open claims, written premium by channel, and claims by month and product.

Financial Detail & Reconciliation Power BI dashboard screenshot — Financial Detail & Reconciliation
Unearned and earned premium, premium receivable, and the trial balance.

Everything you need, in every format you use.

One purchase, every format — no conversion required.

CSV, SQLite, DuckDB & Parquet

Every table available in four portable data formats.

SQL Server, ready to restore

Create/load scripts, SQL Server-compatible CSVs, a ready-to-restore .bak file, and a PowerShell loader.

PostgreSQL scripts

Create and load scripts for PostgreSQL.

Power BI dashboard

A populated .pbix report plus a reusable .pbit template.

SQL query packs

Executive, KPI, analysis, and validation queries.

Full documentation

Data dictionary, table relationships, business process guide, KPI reference, database loading guide, Power BI guide, and exercises.

Validation & Quality Checks

Validation report, row counts, and packaged validation queries to help verify the dataset.

Standard Product License

One license covers the full package — see the license file included with your download.

Compare supported output formats

Built for how the data actually gets used.

Power BI portfolio projects

Build a dashboard on data with real depth instead of a toy dataset.

SQL practice

Write joins, aggregations, and window functions against real relationships.

Analytics training

Give students or trainees a shared dataset built for classroom use.

BI & software demos

Show a working demo backed by data that behaves like a real business.

Consulting & client prototypes

Prototype a client solution without exposing real business data.

KPI & model validation

Test that your KPI logic and models hold up against multi-table source data.

Data modeling & reporting practice

Build relationships, measures, reporting logic, and analytical models against connected business data.

Development & testing

Use a realistic dataset to build and test data pipelines and applications.

Data engineering practice

Build and test transformations, pipelines, joins, and data workflows against a realistic relational source.

Get the Property & Casualty Insurance pack.

One license, everything included.

Property & Casualty Insurance Demo Database & BI Pack

$14.99USD

one-time purchase · tax included

DemoDataWorks Standard Product License

CSV, SQLite, DuckDB & Parquet
SQL Server, ready to restore
PostgreSQL scripts
Power BI dashboard
SQL query packs
KPI reference & business metrics
Full documentation
Validation & Quality Checks
Standard Product License

Purchase & Download

Frequently asked questions

Need more scale, or a fresh Property & Casualty Insurance variation?

Generate your own dataset with DemoDataWorks when you need a different company, larger data volume, or a fresh deterministic variation for another project.

Choose an industry, select the scale you need, configure supported options, and generate a complete synthetic business environment.

Generate Your Own