Sample Insurance Data warehouse

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Sample Insurance Data warehouse

Sample Insurance Data warehouse

Rate Topic

Display Mode

Topic Options

Author

Message

Jonathan Mallia

Posted Monday, January 28, 2013 1:47 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:27 AM
Points: 961, Visits: 969

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

anthony.green

Posted Monday, January 28, 2013 1:57 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

Jonathan Mallia

Posted Monday, January 28, 2013 2:02 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:27 AM
Points: 961, Visits: 969

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

anthony.green

Posted Monday, January 28, 2013 2:04 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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.

Post #1412255

Jonathan Mallia

Posted Monday, January 28, 2013 2:28 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:27 AM
Points: 961, Visits: 969

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

Post #1412268

mmartin1

Posted Thursday, April 11, 2013 4:48 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:43 PM
Points: 192, Visits: 640

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

Jonathan Mallia

Posted Friday, April 12, 2013 12:29 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:27 AM
Points: 961, Visits: 969

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

nick.mcdermaid

Posted Friday, April 12, 2013 3:46 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 7:09 PM
Points: 160, Visits: 425

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 »

Permissions