Insurance Industry BI Report Instance technology architecture and Data Warehouse analysis

Application Enterprise:XxGuo ShouTechnology Architecture

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/75/8F/wKiom1Y8JXnzfY7AAAIZLz9HUMM536.jpg "title=" 1.jpg " alt= "Wkiom1y8jxnzfy7aaaizlz9humm536.jpg"/>

Data Warehouse Topic classification

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/75/8C/wKioL1Y8JcmR3avzAAK-2acWCQY859.jpg "title=" 2.png " alt= "Wkiol1y8jcmr3avzaak-2acwcqy859.jpg"/>

Data Warehouse design: Cubes

1. document subject data cube

includes the date, document type, organization, operator, and many other dimensions, to provide document inventory class basis data.

Collect paid Subject data cube

based on the existing Statistical inquiry system (HBQRYDB), it realizes the building of collecting and paying basis data, and the statistic of the premium logic (or paid-in premium logic) which is realized later, covering the existing business development indicators, including date, institution, insurance, payment method, Payment methods, payment items, customer dimensions, card folding type, policy type, customer contact, sales staff, sales channels, management channels, network, data sources, responsibility centers and other dimensions, in order to provide a unified business management, rich diversification of premiums (underwriting, commissions, fees, etc.) business management view.

2. Policy subject data cube

for the company's existing policy design policy theme, Fusion 7 version, 8 version, short insurance, annuity and universal system Policy data, including date, organization, insurance, payment method, Customer dimension, card folding type, policy type, customer contact way dimension, sales personnel dimension, sales channel dimension and other dimensions , providing a convenient and flexible source of data for the management of the policy, including the number of policies, the amount insured, the insured, and so on.

3. new contract subject data cube

Focus on the acceptance of new single policy status, to help managers at all levels from time, insurance, channels, policy types and other aspects of the Organization's new single acceptance of the number, insured amount, insured number of information, specific dimensions can be seen in the policy subject.

The data cube of the underwriting topic.

Includes date, insurance, organization, operator, sales channel, customer, data source and many other dimensions to provide the basic data of the underwriting list class.

4. Preserving the subject data cube

includes date, insurance, organization, operator, security status, security items, sales channels, customers, data sources and many other dimensions to provide security inventory class base data.

5. claims subject data cube

includes date, insurance, institution, type of policy, Chuxian reason, Chuxian result, claim status, claim type, factoring type, operator, sales channel, customer, sales person, receiving payment item, data source and other dimensions, to provide the basic data of Claim List class.

6. customer-themed data cube

that is, as a topic also as a dimension information, mainly contains the customer (individual customer and group customer) basic information, customer contact information (because an insurance policy may use different contact), etc., in order to analyze the customer later, and other topics associated with data mining.

7. Human subjects data cube

sales personnel include a risk sales staff (marketing and collection of exhibitors), group insurance sales staff, Bank insurance sales personnel, electrical personnel and so on. These people include basic information, extended information, rank information, changes, etc.

operators include input personnel, review personnel, audit personnel.

Because the sales staff belong to different channels, so the structure may be different, so need to have a risk team structure (area-department-group-staff), a business structure (workplace-functional group-staff), group insurance structure information, Bank insurance team structure (network-specialist).

for people and architecture, you can analyze the sales people, structure the analysis, and the performance of people and architecture, even the income of individuals and teams.

Insurance Industry BI Report Instance technology architecture and Data Warehouse analysis