Post reply

Sample Insurance Data warehouse

  • January 28, 2013 at 1:47 am

    #394034

    Hi guys,

    I am looking for a sample data warehouse for insurance company in order to have a solid starting point.

    Can anyone pinpoint a direction for such resource?

    Thanks,

    Jon

  • January 28, 2013 at 1:57 am

    #1581459

    Well it would all depend on your data, and how you want to slice and dice it.

    I would recommend choosing a warehousing route, like Kimball or Inmon as various people have various ways of defining a warehouse.

    Some good reading on Kimball methodology - http://www.kimballgroup.com/data-warehouse-and-business-intelligence-resources/data-warehouse-books/, which is the way that I have always done warehouses.

  • January 28, 2013 at 2:02 am

    #1581466

    At the moment I am more looking into a 'generic' model to continue building on that basis, possibly with sample data which is ready to do some analysis models...

  • January 28, 2013 at 2:04 am

    #1581469

    Again it would depend on your data and how you want to analyse that data as to what route you need to take in your warehouse. Only you would be able to decide on that.

    There is the AdventureWorks data warehouse which you can download from Codeplex to get an idea of how that is built, but I would really recommend reading up on warehousing methodologies and then applying it to your data.

  • January 28, 2013 at 2:28 am

    #1581481

    I am specifically looking for insurance dw sample database. Looked at AdventureWorks but business is completely different.

  • April 11, 2013 at 4:48 pm

    #1605809

    Model your business processes, that will light what are your facts and subsequently your dimensions. If you are familiar with your business this shouldn't trouble you too much.

    ----------------------------------------------------

  • April 12, 2013 at 12:29 am

    #1605861

    The idea behind this is to create a BI demo based on an insurance data warehouse not as an actual aid to a situation 😉

    Cheers

  • April 12, 2013 at 3:46 am

    #1605894

    Kimball books have a sample Insurance data warehouse. You might need to roll the scripts yourself though. I don't think there is much point relying on a sample data warehouse to show a client / POC though. They're only interested in the front end.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply