Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Insurance Data Mart Expand / Collapse
Author
Message
Posted Tuesday, January 07, 2014 5:33 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 11:51 AM
Points: 46, Visits: 567
Good day All,

Am building BI solution for Insurance company.

I want know the data models/marts needed for the solution?

The marts entails reports on Policy,Claims,Finance and HR.

How are you able to manage the heterogeneous items in Life ...
Post #1528719
Posted Wednesday, January 08, 2014 12:13 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 12,206, Visits: 9,168
You'll need to read up on dimensional modelling.

The Data Warehouse Toolkit by Kimball has a specific chapter on insurance.

Star Schema The Complete Reference is also a very good book.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1528772
Posted Wednesday, January 08, 2014 7:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:56 AM
Points: 7,084, Visits: 14,680
If you're starting from scratch as your post implies, you might consider at least starting from any of a number of industry "standard" models, modifying them to fit your goals of course. We had to take that on a while back, and frankly using the industry models at least as a benchmark were very useful in cutting down our design time.

ACORD has done a lot in this field (ACORD information model), as well as IBM (IAA) , Informatica (Informatica insurance suite), GuideWire (Millbrook data mart), just to name a few. There are literally dozens of smaller ones as well: just pop that phrase into Google and voila.


----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #1528894
Posted Thursday, January 09, 2014 3:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 11:51 AM
Points: 46, Visits: 567
@Koen Verbeeck.. Thanks Boss.. I have the book already. Nice pointer from you.
Post #1529261
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse