scottcabral1979
Programmer
Hi,
I would like to build a fact table that tracks homeowner's insurance policy submissions. This table would measure policies that were quoted and/or issued.
The source data is stored by policy with a Quote Date and an Issue Date and a policy_status field. Every policy would have a quote date and if the policy was issued, it would have an issue date. Quoted policies that have not been issued have a policy_status field of 'quote'. Issued policies have a policy_status field of 'Issued'.
Dimensions would be State, Agent, Territory, Quote Date, Issue Date, etc...
I'm looking for some suggestions on the best way to store the data in a fact table. Should I just store a count of each quote and a count of each issued by date? I basically just need to get the numbers of quotes and the number of issues by any one of the dimensions.
thanks
Scott
I would like to build a fact table that tracks homeowner's insurance policy submissions. This table would measure policies that were quoted and/or issued.
The source data is stored by policy with a Quote Date and an Issue Date and a policy_status field. Every policy would have a quote date and if the policy was issued, it would have an issue date. Quoted policies that have not been issued have a policy_status field of 'quote'. Issued policies have a policy_status field of 'Issued'.
Dimensions would be State, Agent, Territory, Quote Date, Issue Date, etc...
I'm looking for some suggestions on the best way to store the data in a fact table. Should I just store a count of each quote and a count of each issued by date? I basically just need to get the numbers of quotes and the number of issues by any one of the dimensions.
thanks
Scott