I want to prepare a questionnaire. The details about it are as follows: - 1. Identify a

First of all meet your sponsors and make a BRD(business requirement document) about their expectation from this datawarehouse(main aim comes from them).For example they need :customer billing process.Now goto business managment team :they can ask for metrics out of billing process for their use.Now magament people :monthly usage,billing metrics,sales organization,rate plan to perform sales rep and channel performance analysis and rate plan analysis. So your dimensiontab les can
be:Customer (customer id,name,city,state etc)Sales rep;sales rep number,name,idsales org:sales ord idBill dimension: Bill #,Bill date,Numberrate plan:rate plan codeAnd Fact table can be:Billing details(bill #,customer id,minutes used,call details etc)you can follow star and snow flake schema in this case.Depend upon the granualirty of your data.