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

Sample Insurance Data warehouse Expand / Collapse
Author
Message
Posted Monday, January 28, 2013 1:47 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:27 AM
Points: 982, Visits: 1,095
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
Post #1412239
Posted Monday, January 28, 2013 1:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:55 AM
Points: 5,216, Visits: 5,064
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.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1412245
Posted Monday, January 28, 2013 2:02 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:27 AM
Points: 982, Visits: 1,095
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...

Post #1412252
Posted Monday, January 28, 2013 2:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:55 AM
Points: 5,216, Visits: 5,064
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.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1412255
Posted Monday, January 28, 2013 2:28 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:27 AM
Points: 982, Visits: 1,095
I am specifically looking for insurance dw sample database. Looked at AdventureWorks but business is completely different.
Post #1412268
Posted Thursday, April 11, 2013 4:48 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 6:42 PM
Points: 345, Visits: 853
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.
Post #1441519
Posted Friday, April 12, 2013 12:29 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:27 AM
Points: 982, Visits: 1,095
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
Post #1441582
Posted Friday, April 12, 2013 3:46 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:20 AM
Points: 178, Visits: 570
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.
Post #1441621
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse