Explore for Policy: Financial Insights content

Explore for Policy includes the following pre-configured financial insights models, Answers, and Liveboards, with curated data from your InsuranceSuite applications streamed in near real-time.

Lineage of Explore for Policy Financial Insights content

The following diagram shows the lineage. Click to enlarge the image.
Two solution fact datasets in Data Studio are published to Explore and become tables, then models, answers, and a liveboard.
  1. Guidewire created Explore for Policy Financial Insights solution datasets that live in Data Studio. They include fact datasets with several related dimension datasets. The datasets are derived from the Policy Insurance Data Model (IDM) 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 solution datasets are then published to Explore and used to create models. There's one Explore model for each fact dataset.
  3. The models are the data source for Answers and a Liveboard.

Liveboards for policy financial insights

Liveboard Name Key Contents Data source (Explore model)
Policy Premium Analysis Analysis of aggregate premium amounts by accounting period, policy effective date, coverage subtype and other attributes.

Answers for policy financial insights

The following Answers report premium summaries and trends over time. 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
General Premium Summary

Includes premium totals by accounting period for:

  • Inforce
  • Unearned
  • YTD written
  • YTD earned

There are subtotals for each underwriting company, product, and coverage.
Inforce and Unearned Premium Summary

Includes premium totals by accounting period for:

  • New inforce
  • Renewal inforce
  • Inforce
  • New unearned
  • Renewal unearned
  • Unearned

There are subtotals for each underwriting company, product, and coverage.
Inforce and Unearned Premium Trending

Shows current year (CY) and prior year (PY) development of inforce and unearned premium. Includes premium totals by accounting period for:

  • CY inforce
  • PY inforce
  • CY unearned
  • PY unearned

There are subtotals for each underwriting company, product, and coverage.
Annualized Inforce Premium Trending
Shows current year (CY) and prior year (PY) development of annualized inforce written and estimate premium. Includes premium totals by accounting period for:
  • CY inforce annualized written
  • PY inforce annualized written
  • CY inforce annualized estimate
  • PY inforce annualized estimate

There are subtotals for each underwriting company, product, and coverage.
Written and Earned Premium Summary

Includes premium totals by accounting period for:

  • YTD new policy written
  • YTD renewal policy written
  • YTD written
  • YTD new policy earned
  • YTD renewal policy earned
  • YTD earned

There are subtotals for each underwriting company, product, and coverage.
Written and Earned Premium Trending

Shows current year (CY) and prior year (PY) development of written and earned premium. Includes premium totals by accounting period for:

  • PY YTD written
  • PY YTD earned Premium
  • Current YTD written
  • Current YTD earned
  • PY Change YTD written
  • PY % Change YTD written
  • PY Change YTD earned
  • PY % Change YTD earned

There are subtotals for each underwriting company, product, and coverage.

Models for policy 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 - Policy Financial Premium - Calendar Year

Includes monthly snapshots of premium amounts based on the transaction booking date. The snapshots are aggregates of different types of premiums, such as written, inforce, and unearned.

Helps analysts view premium amounts within accounting periods. They can view amounts by line of business, coverage, producer, and other attributes.

 efr_fact_prem_calendaryear
GW - Policy Premium ITD

Includes inception-to-date monthly snapshots of various charges related to policies. Aggregates span the period from the time that a policy originates to the current month.

Helps analysts view premium amounts for a policy by the policy effective date. They can view amounts by line of business, coverage, producer, and other attributes.

 efr_fact_prem_itd

Related information