| Insurance Data Model |
Description | The analysis and comparison of market and company forecasted measures, in terms of policy volumes, premium income, market share and growth rate.Dimensions:- Time (grain: month)- Geographic area(grain: state)- Line of business |
Foreign Key | |
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
Primary Key | |
![]() |
Column Details |
Description | The insurance company's forecasted total premium income divided by the forecasted number of policies. |
Data Type | DECIMAL(14 , 2) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The insurance company's forecasted total premium income for the considered period of time, divided by its actual total premium income for the previous period. |
Data Type | DECIMAL(8 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The insurance company's forecasted total premium income divided by the market forecasted total premium income. |
Data Type | DECIMAL(8 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The forecasted number of policies that will be sold, endorsed or renewed by the insurance company. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The forecasted total premium income resulting from the policies that will be endorsed by the insurance company. |
Data Type | DECIMAL(14 , 2) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The forecasted total premium income resulting from the new policies that will be sold by the insurance company. |
Data Type | DECIMAL(14 , 2) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The forecasted total premium income resulting from the policies that will be renewed by the insurance company. |
Data Type | DECIMAL(14 , 2) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The forecasted total premium income resulting from the policies that will be sold, endorsed or renewed by the insurance company.Measure Calculation Formula:[ A + B + C ] |
Data Type | DECIMAL(14 , 2) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The market forecasted total premium income divided by the market forecasted number of policies. |
Data Type | DECIMAL(7 , 2) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The forecasted number of policies that will be sold, endorsed or renewed by the whole market. Typically, this measure is expressed at country level. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The forecasted total premium income resulting from the policies that will be sold, endorsed or renewed by the whole market. Typically, this measure is expressed at country level and represents the market size. |
Data Type | DECIMAL(14 , 2) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Identifies the Distribution channel dimension of this Fact Entity. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Identifies the Geographic area dimension of this Fact Entity. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Identifies the Time dimension of this Fact Entity. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Identifies the Channel role mini dimension of this Fact Entity. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Identifies the Geographic Area Mini Dimension of this Fact Entity. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The insurance company's forecasted total premium income for the considered period of time, divided by its actual total premium income for the previous period. |
Data Type | DECIMAL(8 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The insurance company's forecasted total premium income for the considered period of time, divided by its actual total premium income for the previous period. |
Data Type | DECIMAL(8 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Category |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The forecasted number of policies that will be sold, endorsed or renewed by the insurance company. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The forecasted number of policies that will be sold, endorsed or renewed by the insurance company. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The forecasted number of policies that will be sold, endorsed or renewed by the insurance company. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The insurance company's forecasted total premium income for the considered period of time, divided by its actual total premium income for the previous period. |
Data Type | DECIMAL(8 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Foreign Key Details |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | SALES_FORECAST_ANALYSIS |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | DISTRIBUTION_CHANNEL_ID [BIGINT] |
Parent Table | CHANNEL_ROLE |
Parent Role Name | is dimension of |
Parent Multiplicity | 1 |
Unique Constraint | CHANNEL_ROLE_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | SALES_FORECAST_ANALYSIS |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | GEOGRAPHIC_AREA_ID [BIGINT] |
Parent Table | GEOGRAPHIC_AREA |
Parent Role Name | is dimension of |
Parent Multiplicity | 1 |
Unique Constraint | GEOGRAPHIC_AREA_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | SALES_FORECAST_ANALYSIS |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | TIME_DIMENSION_ID [BIGINT] |
Parent Table | CALENDAR_DATE |
Parent Role Name | is dimension of |
Parent Multiplicity | 1 |
Unique Constraint | CALENDAR_DATE_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | SALES_FORECAST_ANALYSIS |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | DISTRIBUTION_CHANNEL_MINI_DIMENSION_ID [BIGINT] |
Parent Table | CHANNEL_ROLE_MINI_DIMENSION |
Parent Role Name | is dimension of |
Parent Multiplicity | 0..1 |
Unique Constraint | CHANNEL_ROLE_MINI_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | SALES_FORECAST_ANALYSIS |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | GEOGRAPHIC_AREA_MINI_DIMENSION_ID [BIGINT] |
Parent Table | GEOGRAPHIC_AREA_MINI_DIMENSION |
Parent Role Name | is dimension of |
Parent Multiplicity | 0..1 |
Unique Constraint | GEOGRAPHIC_AREA_MINI_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | SALES_FORECAST_ANALYSIS |
Child Role Name | Verb1 |
Child Multiplicity | * |
Key Column | LINE_OF_BUSINESS_ID [BIGINT] |
Parent Table | PRODUCT_GROUP |
Parent Multiplicity | 1 |
Unique Constraint | PRODUCT_GROUP_PK |
Primary Key Details |
Description | The unique identifier of the Sales forecast analysis |
Member | DISTRIBUTION_CHANNEL_ID [BIGINT] |
Member | GEOGRAPHIC_AREA_ID [BIGINT] |
Member | TIME_DIMENSION_ID [BIGINT] |
Member | LINE_OF_BUSINESS_ID [BIGINT] |
| Insurance Data Model |