Scribd
Upload
107 views

Insurance DataWare House Design Vechiles

The document discusses designing an insurance data warehouse using a dimensional model. It describes sample business entities like accounts, policies, vehicles, and coverages. It then discusses how an information-centric reporting model using a dimensional data warehouse model provides benefits like empowering users, increased efficiencies and productivity, and profitability compared to traditional report-centric reporting. It concludes that data warehousing and business intelligence provide the foundation for information-centric reporting.

Uploaded by

Sunil Yoganna
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
107 views

Insurance DataWare House Design Vechiles

The document discusses designing an insurance data warehouse using a dimensional model. It describes sample business entities like accounts, policies, vehicles, and coverages. It then discusses how an information-centric reporting model using a dimensional data warehouse model provides benefits like empowering users, increased efficiencies and productivity, and profitability compared to traditional report-centric reporting. It concludes that data warehousing and business intelligence provide the foundation for information-centric reporting.

Uploaded by

Sunil Yoganna
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Insurance DataWare House Design

Sample Business Domain


The sample business domain is in the insurance industry and uses the following entities:

Entity Description
ACCOUNT Information about a customer and its
activities with the insurance company
POLICY An insurance contract representing a
specific agreement with the customer
VEHICLE A vehicle belonging to the customer and
covered by a policy
COVERAGE The kinds of losses that are covered for a
vehicle on this policy
PREMIUM A monthly payment from the customer
for coverage on vehicles in this policy
DIMENSIONAL MODEL
CONCLUSION
1. Information Centric reporting is an 180 degree shift from the
current Report Centric reporting environment that most
organizations use.
2. Information Centric reporting via the data warehouse’s
dimensional model puts the effort in the organization
and storage of the data for easy access instead of
creating endless reporting applications.
3. Information Centric reporting empowers users to be
proactive instead of being reactive.
4. Information Centric reporting provides for an increased
efficiencies, increased productivity which results in
increased profitability.
5. Data warehousing and Business Intelligence provide
the foundation for Information Centric reporting.
REFERENCES
Dimensional Modeling,
www.ou.edu/class/aschwarz/DataWarehouse
Welbrock, Peter R., Startegic Data Warehousing Principles
Using SAS Software, Cary NC: SAS Institute Inc., 1998.
384pp.
Kimball, Ralph, The Data Warehouse Toolkit: The Complete
Guide to Dimensional Modeling, New York, NY: John Wiley
and Sons, Inc., 2002. 436pp.
Kimball, Ralph, The Data Warehouse Lifecycle Toolkit:
Expert Methods for Designing, Developing, and Deploying
Data Warehouses, New York, NY: John Wiley and Sons,
Inc., 1998. 771pp.
CONTACT INFORMATION
Your comments and questions are valued and encouraged.
Contact the author at:
Dan Kirpes
Fireman’s Fund Insurance Company
777 San Marin Drive
Novato, CA 94998
(415) 899-3561:
Email: [email protected]
TIME
time_key (PK)
SQL_date
day_of_week
month
STORE
store_key (PK)
store_ID
store_name
address
district
floor_type
CLERK
clerk_key (PK)
clerk_id
clerk_name
clerk_grade
PRODUCT
product_key (PK)
SKU
description
brand
category
CUSTOMER
customer_key (PK)
customer_name
purchase_profile
credit_profile
address
PROMOTION
promotion_key (PK)
promotion_name
price_type
ad_type

You might also like