Model: GW - Profitability

GW - Profitability includes month-to-date and year-to-date loss ratios and expense ratios. It combines calendar year premium and calendar year loss metrics into one model. Analysts can use the model to create visualizations that monitor profitability. They can view loss and expense ratios by state, product, producer, and other attributes.

Source tables



The GW - Profitability model is built from a fact table and multiple dimension tables, as shown in the diagram.
Fact:
  • efr_fact_profitability
Dimensions:
  • efr_dim_uwcompany
  • efr_dim_organization
  • efr_dim_producer
  • efr_dim_policyinfo
  • efr_dim_month

From each table, Guidewire selected specific columns to include in the model. They’re typical columns used in reporting and analysis. For details about each column in the model, see the Data dictionaries for Explore models.

Formulas

Many of the model’s columns are the result of formulas created on the model in Explore. The formula columns aren’t part of the source tables in Explore or Data Studio. Each formula performs a calculation or conversion, usually using source table columns, and the result is an additional column in the model.

For a list of all formula columns and their expressions, see the Data dictionaries for Explore models.

These formulas convert dates into business-friendly strings:

  • Accounting Month: The first day of the accounting month
  • Accounting Period: The accounting month

Other formulas calculate:

  • Aggregate amounts for various indemnity, loss, and expense amounts
  • Expense and loss ratios
They include both Month-to-date (MTD) and Year-to-date (YTD) calculations.

MTD and YTD aggregates

The model includes Month-to-date (MTD) and Year-to-date (YTD) aggregates for various claims financial amounts, premium earnings amounts, and loss and expense ratios. These columns make it easier to create reports for those time periods. For example:
  • MTD and YTD Indemnity Incurred
  • MTD and YTD Earned Premium
  • MTD and YTD Expense Ratio

Related information