Explore for Claims: Financial Insights content

In the base configuration, Explore for Claims includes the following financial insights models, answers, and liveboards, with curated data from your InsuranceSuite applications streamed in near real-time.

Note: If you don't use these models, the GW - EfC Loss Financials ITD Loss Transactions model is another, separate option for ITD claims financial insights. The models on this page are meant to replace it.

Lineage of Explore for Claims Financial Insights content

The following diagram shows the lineage. Click to enlarge the image.
Solution fact datasets in Data Studio are published to Explore and become tables, then models, answers, and liveboards.

Solution fact datasets in Data Studio are published to Explore and become tables, then models, answers, and liveboards.

Guidewire created Explore for Claims Financial Insights solution datasets that live in Data Studio. They include central fact datasets with several related dimension datasets.
1. The loss datasets are derived from the Claims and Policy Insurance Data Models (IDMs) by applying predefined queries onto the IDM dynamically generated datasets. You can find details about the solution datasets in the Data Studio Data Dictionary. (See the Data Studio guide.)
2. The profitability dataset is derived from the Claims and Policy IDMs in addition to the Explore for Claims and Explore for Policy solutions. The profitability fact derives metrics from efr_fact_loss_calendaryear and efr_fact_prem_calendaryear.
The solution datasets are then published to Explore and used to create models. There's one Explore model for each fact dataset.
The models are the data source for answers and liveboards.

Implementation for ClaimCenter-only customers

Explore for Claims Financial Insights uses data from the both the Claims and Policy Insurance Data Models. However, if you have ClaimCenter without PolicyCenter, you can still implement the solution. In a ClaimCenter-only implementation, the dimension datasets only use ClaimCenter data. The PolicyCenter-related dimension columns remain in the schema, but there’s no data:

If an attribute doesn’t exist in ClaimCenter, the value is NULL.
If a key attribute doesn’t exist in ClaimCenter, the null value is replaced with ?. This prevents issues that can occur with null keys, such as incorrect joins or misrepresented financial data.

Liveboards for claims financial insights


Liveboard Name	Key Contents	Data source (Explore model)
Calendar Year Loss Analysis	Analysis of claims financials by transaction booking date. Includes insights into total incurred losses, reserve changes, recovery patterns, expense payments, regional claim distributions, loss causes, policy lifecycle segmentation, and detailed claim-level views. Use it to monitor trends, assess risk exposure, and compare performance over time.	GW - Claim Loss Financial - Calendar Year
Accident Year Loss Analysis	Analysis of claims financials by loss date. Includes insights into total recoveries, expense payments, outstanding reserves, open claims and exposure counts, loss causes, regional open claim distribution, average claim severity, and detailed claim-level views.	GW - Claim Loss Financial - ITD
Profitability Analysis	Analysis of expense and loss ratios. Includes expense and loss ratios over time and by location, trends of incurred losses and premium amounts, and detailed metrics by policy. Use it to monitor trends, identify areas of improvement, and analyze profitability over time.	GW - Profitability

Answers for claims financial insights

The following answers report various claims financial totals. They aren’t pinned to a liveboard, but are separate pivot table reports that you can view and filter. To learn more about filtering, see Explore pivot tables.

Note: If an answer has a Reporting Period filter, select the last day of a month. If you select a different day, the table still shows data for the end of the month because the data is stored by the month end date.


Answer Name	Key Contents
Claim Overview	Includes totals by accounting period for: Claim Count Avg Reserve Change Avg Total Incurred Loss Paid Net Loss Paid Total Reserve Change YTD Net Reserve Change YTD Total Incurred YTD Net Incurred There are subtotals for each claim state, such as Open or Closed.
General Loss Summary	Includes totals by accounting period for: MTD Total Reserve Change MTD Net Loss Reserve Change MTD Indemnity Reserve Change MTD Total Expense Reserve Change YTD Total Loss Incurred YTD Total Net Incurred YTD Indemnity Incurred YTD Expense Incurred There are subtotals for each underwriting company, product, line of business, and coverage.
Incurred Loss Trending	Shows current year (CY) and prior year (PY) development of incurred losses. Includes totals by accounting period for: CY YTD Total Incurred PY YTD Total Incurred PY Changed YTD Total Incurred PY % Change YTD Total Incurred CY YTD Total Net Incurred PY YTD Total Net Incurred PY Change Total Net Incurred PY % Change Total Net Incurred There are subtotals for each underwriting company, product, line of business, and coverage.
Loss Paid Summary	Includes totals by accounting period for: YTD Indemnity Paid YTD Medical Paid YTD Expense Paid YTD Total Loss Paid YTD Total Loss Recovery YTD Net Indemnity Paid YTD Net Expense Paid YTD Net Loss Paid There are subtotals for each underwriting company, product, line of business, and coverage.
Claim Severity Analysis	Includes totals for: Average Loss Severity Claim Count with Loss Avg Expense Paid Severity Claim Count with Expense Avg Claim Severity There are subtotals for each underwriting company, line of business, and loss cause.
Loss Ratio Summary Trending	Includes totals for: Loss Incurred Total Incurred Earned Premium Total Expense Incurred Loss Ratio without Expenses Incurred Loss Ratio with Expenses There are subtotals for each underwriting company and product.

Models for claims financial insights

For more details, see the linked pages and the Data dictionaries for Explore models.


Model Name	Key Contents	Source solution dataset from Data Studio
GW - Claim Loss Financial - Calendar Year	Includes monthly snapshots of claims financials based on the transaction booking date. The snapshots are aggregates of various transaction line item amounts, such as loss incurred, expense payments, salvage recoveries, and medical reserve changes. Helps analysts create visualizations of amounts within accounting periods. They can view amounts by loss cause, location, policy life cycle, and other attributes.	efr_fact_loss_calendaryear
GW - Claim Loss Financial - ITD	Includes inception-to-date snapshots of claims financials. Aggregates span the period from the time that a loss occurred to right now. The snapshots aggregate various transaction line item amounts, such as loss incurred, expense payments, salvage recoveries, and medical reserves. Helps analysts create visualizations of amounts by accident year. They can view amounts by loss cause, location, claim severity, and other attributes.	efr_fact_loss_itd
GW - Profitability	Includes month-to-date and year-to-date loss ratios and expense ratios. Combines calendar year premium and calendar year loss metrics into one model. Helps analysts monitor profitability. They can view loss and expense ratios by state, policy, product, producer, and other attributes.	efr_fact_profitability