Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dimensional Modeling for Insurance Industries
I have personally designed enterprise data warehouse dimensional models for 7 insurance carriers and currently working on number 8. On average our customers are maintaining approx. 15 different dimensions on how they analyze their business. My current design will incorporate close to 50...- tdimarco
- Post #7
- Forum: Data Warehousing/Big Data
-
P&C Insurance Earnings/Incurred Methods
Another approach, one we have used frequently, is to maintain a dimension for the "Period Type" (i.e. Policy Year vs. Accident Year vs. Calendar Year). This allows you to have a single time dimension with the ability to select any time perspective or see the time perspectives side by side. We...- tdimarco
- Post #4
- Forum: Data Warehousing/Big Data
