Data Warehouse for survey data

View previous topic View next topic Go down

Data Warehouse for survey data

Post  jpayton on Mon Jun 01, 2009 7:16 pm

Hi All,

Working with a company which uses Salesforce.com heavily. They have a large number of custom fields, and great volatility in them - frequently adding and deleting them when they cease being relevant (They collect survey data for their clients). There are core fields, and the dynamic (custom) ones are more-or-less the facts of the DW (a factless fact table). My intention is to create dimensions for both questions and responses, so that I can easily group same questions, and also get some efficiency when responses are either numeric of selected values only (as opposed to unstructured text). Does anyone have any thoughts on this??? This is quite different from whaat we normally work on.

Thanks

Jim

jpayton

Posts : 10
Join date : 2009-05-08
Location : Ontario, Canada

View user profile http://www.dynamicintelligence.ca

Back to top Go down

Re: Data Warehouse for survey data

Post  ubethke on Wed Jun 10, 2009 2:40 pm

Have a look at Kimball's dimensional modelling book page 197.

http://www.amazon.com/gp/product/0471200247?ie=UTF8&tag=busineintellq-20&linkCode=as2&camp=1789&creative=390957&creativeASIN=0471200247

ubethke

Posts : 28
Join date : 2009-02-03

View user profile http://www.business-intelligence-quotient.com

Back to top Go down

Re: Data Warehouse for survey data

Post  jpayton on Wed Jun 10, 2009 3:03 pm

Perfect. Thanks - I must have missed it when reading through. Now all I have to do is deal with the volatile/changeable nature of the questions and I'm all set!

Thanks

jpayton

Posts : 10
Join date : 2009-05-08
Location : Ontario, Canada

View user profile http://www.dynamicintelligence.ca

Back to top Go down

Re: Data Warehouse for survey data

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum