Impact data manager for generating dynamic intelligence cubes

• US 10,482,535 B1
• Filed: 06/11/2012
• Issued: 11/19/2019
• Est. Priority Date: 07/27/2011
• Status: Active Grant

• Current Assignee: AON Global Operations SE Singapore Branch
• Original Assignee: AON Benfield Global Incorporated (Aon Plc (Spain))
• Inventors: Olson, Douglas A.
• Primary Examiner(s): Rankins, William E
• Application Number:
  US13/493,100
• Time in Patent Office: 2,717 Days
• Field of Search: 705 4, 705 11, 705 35
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: G06Q 40/08 Insurance

Abstract

Techniques for dynamically and remotely generating a business intelligence cube from an impact-on-demand or mapping system include an intelligence cube module configured to receive a user indication of a client portfolio stored at a remote mapping system. The module may receive user selections of cube dimensions and boundaries of the client portfolio for inclusion in a draft business intelligence cube definition. The module may validate the selected dimensions and boundaries, determine the presence of any anomalies, and in some cases, automatically modifying the draft to resolve the anomalies. A validated, approved cube definition may be delivered to the mapping system for storage. The mapping system may, in real-time and based on a user request, populate the cube definition with a selected dataset and return the populated business intelligence cube for analysis and utilization in reports and other business intelligence tools.

Claims

1. A system for mapping data associated with one or more impact events to at least one client insurance portfolio, the system comprising:

processing circuitry;

a non-transitory database storage region; and

a non-transitory computer readable memory coupled to the processing circuitry, the memory storing machine-executable instructions, wherein the machine-executable instructions, when executed on the processing circuitry, cause the processing circuitry to

receive, from remote computing devices of one or more data sources via a network,

source data including characteristics of one or more insured properties in each of a plurality of client insurance portfolios, and

risk information indicating geographic patterns of one or more impact events affecting the one or more insured properties,

store, within the non-transitory database storage region, the source data,

determine, based on the source data stored in the non-transitory database storage region, a plurality of dimensions and one or more limits for customizing a business intelligence cube definition at a business intelligence cube user interface screen, wherein

the plurality of dimensions corresponds to a plurality of data fields in a portfolio of the plurality of client insurance portfolios, and

the one or more limits correspond to one or more boundary conditions for each of at least a portion of the plurality of data fields in the portfolio,

enable, dynamically in real-time based on analysis of source data corresponding to each data field of at least a portion of the plurality of data fields in the portfolio in view of an impact event of the one or more impact events, one or more functional properties of the business intelligence cube user interface screen, wherein

each functional property corresponds to one of a respective data field of the plurality of data fields, a respective menu option, and a respective calculation,

receive, via the business intelligence cube user interface screen responsive to interaction of a user with at least one of the one or more functional properties, selections of at least one of a portion of the plurality of dimensions and updated values of at least one limit of the one or more limits,

generate, in real-time responsive to receiving the selections at the business intelligence cube user interface screen, a business intelligence cube definition for the portfolio with respect to the impact event based in part on the selections, and

customize, in real-time responsive to receiving a user request, a business intelligence cube based on the business intelligence cube definition, wherein

customizing the business intelligence cube includes populating the business intelligence cube with a portion of the source data corresponding to a portion of the portfolio affected by the impact event, and respective risk information for the impact event.

2. The system of claim 1, wherein the machine-executable instructions, when executed on the processing circuitry, further cause the processing circuitry to:

adjust, dynamically in real-time responsive to receiving the selections, the plurality of dimensions and the one or more limits available for selection.

3. The system of claim 1, wherein the machine-executable instructions, when executed on the processing circuitry, further cause the processing circuitry to:

update, dynamically in real-time responsive to receiving the selections, a visual representation of the business intelligence cube definition displayed within the business intelligence cube user interface screen to reflect the selections.

4. The system of claim 3, wherein updating the visual representation of the business intelligence cube definition includes updating at least one of geocoded locations, geographical shading on a map, and risk model representations based on the received selections.

5. The system of claim 1, wherein enabling the one or more functional properties of the business intelligence cube user interface screen includes adjusting, based on the selections, one or more display choices available within at least one displayed menu on the business intelligence cube user interface screen.

6. The system of claim 1, wherein the machine-executable instructions, when executed on the processing circuitry, further cause the processing circuitry to:

validate, based on a set of validation rules stored in the non-transitory data storage region, the selections for the business intelligence cube definition.

7. The system of claim 6, wherein the set of validation rules is based on at least one of characteristics, data field boundaries, and data field contents of the portfolio.

8. The system of claim 6, wherein validating the selections comprises detecting an error in the business intelligence cube definition including at least one of an anomaly, an inconsistency, or an incompatibility in at least one of the one or more dimensions and the one or more limits.

9. The system of claim 8, wherein the machine-executable instructions, when executed on the processing circuitry, further cause the processing circuitry to:

correct, automatically in response to detecting the error in the business intelligence cube definition, the at least one of the anomaly, the inconsistency, or the incompatibility in the at least one of the plurality of dimensions and the one or more limits.

10. The system of claim 9, wherein correcting the at least one of the anomaly, the inconsistency, or the incompatibility includes adjusting source data associated with the detected error.

11. The system of claim 1, wherein the plurality of dimensions include at least one of data fields, columns, headers, syntax rules, and data tags within the portfolio.

12. The system of claim 1, wherein the one or more limits include at least one of boundary conditions for a data membership set, a geographical area, and an equivalence function.

13. The system of claim 1, wherein the source data includes at least one of maps data, risk management assessment data, and real property data for the one or more insured properties associated with the portfolio.

14. The system of claim 1, wherein the machine-executable instructions, when executed on the processing circuitry, further cause the processing circuitry to:

output, in real-time responsive to receiving the user request, one or more on-demand reports based on population of the business intelligence cube with the source data from the portion of the portfolio and the respective risk information for the impact event.

15. The system of claim 14, wherein the one or more on-demand reports include at least one of predicted or estimated loss reports, damage reports, and replacement cost reports.

16. The system of claim 1, wherein the machine-executable instructions, when executed on the processing circuitry, further cause the processing circuitry to:

output, in real-time responsive to receiving the user request, the business intelligence cube definition to the business intelligence cube user interface screen based on the portion of the portfolio and the respective risk information for the impact event.

17. A system comprising a plurality of subsystems for mapping data associated with an impact event to at least one client insurance portfolio, the system comprising:

a non-transitory storage region configured to store source data received from one or more data sources via a network;

a data management subsystem comprising first processing circuitry for executing instructions stored to a first non-transitory computer-readable medium, the data management subsystem configured to

receive, from remote computing devices of one or more data sources via a network, source data including characteristics of one or more insured properties in each of a plurality of client insurance portfolios and risk information indicating geographic patterns of one or more impact events affecting the one or more insured properties,

receive, from a remote computing device via the network through a user interface screen, selections of one or more dimensions of a plurality of dimensions, and updated values of at least one limit of one or more limits for a business intelligence cube definition for a portfolio of the plurality of client insurance portfolios, wherein

the plurality of dimensions correspond to a plurality of data field categories in a respective client insurance portfolio, and

the one or more limits correspond to boundary conditions for the data field categories in the portfolio, and

validate, in real-time responsive to receiving the selections at the user interface screen, the selections using a set of validation rules stored in the non-transitory storage region; and

a mapping subsystem comprising second processing circuitry for executing instructions stored to a second non-transitory computer-readable medium, the mapping subsystem configured to enable, dynamically in real-time based on analysis of data field types within the source data for at least one of the portfolio and an impact event of the one or more impact events, one or more functional properties of the user interface screen, wherein

each functional property corresponds to one of a respective data field of the plurality of data fields, a respective menu option, and a respective calculation, and

the selections are entered by the user via at least one of the one or more functional properties,

generate, in real-time responsive to receiving the selections, the business intelligence cube definition for the portfolio with respect to the impact event, and

customize, in real-time responsive to receiving a user request, a business intelligence cube based on the business intelligence cube definition, wherein

customizing the business intelligence cube includes populating the business intelligence cube with a portion of the source data corresponding to a portion of the portfolio affected by the impact event and respective risk information for the impact event.

18. The system of claim 17, wherein the mapping subsystem is further configured to:

adjust, dynamically in real-time responsive to receiving the selections, the plurality of dimensions and the one or more limits available for selection.

19. The system of claim 17, wherein the mapping subsystem is further configured to:

update, dynamically in real-time responsive to receiving the selections, a visual representation of the business intelligence cube definition displayed within the user interface screen to reflect the selections.

20. The system of claim 19, wherein updating the visual representation of the business intelligence cube definition includes updating at least one of geocoded locations, geographical shading on a map, and risk model representations, based on the selections.