InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 15:55:32 GMT20http://www.sqlservercentral.com/Forums/Topic1412239-147-1.aspxKimball 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.Fri, 12 Apr 2013 03:46:34 GMTnick.mcdermaidhttp://www.sqlservercentral.com/Forums/Topic1412239-147-1.aspxThe idea behind this is to create a BI demo based on an insurance data warehouse not as an actual aid to a situation ;)CheersFri, 12 Apr 2013 00:29:06 GMTJonathan Malliahttp://www.sqlservercentral.com/Forums/Topic1412239-147-1.aspxModel 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.Thu, 11 Apr 2013 16:48:20 GMTmmartin1http://www.sqlservercentral.com/Forums/Topic1412239-147-1.aspxI am specifically looking for insurance dw sample database. Looked at AdventureWorks but business is completely different.Mon, 28 Jan 2013 02:28:51 GMTJonathan Malliahttp://www.sqlservercentral.com/Forums/Topic1412239-147-1.aspxAgain 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.Mon, 28 Jan 2013 02:04:46 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1412239-147-1.aspxAt 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...Mon, 28 Jan 2013 02:02:03 GMTJonathan Malliahttp://www.sqlservercentral.com/Forums/Topic1412239-147-1.aspxWell 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 - [url]http://www.kimballgroup.com/data-warehouse-and-business-intelligence-resources/data-warehouse-books/[/url], which is the way that I have always done warehouses.Mon, 28 Jan 2013 01:57:20 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1412239-147-1.aspxHi 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,JonMon, 28 Jan 2013 01:47:45 GMTJonathan Mallia