Hy,I want to prepare a questionnaire. The details about it are as follows: -1. Identify a large company/organization that is a prime candidate for DWH project. (For example Telecommunication, an insurance company, banks, may be the prime candidate for this)2. Give at least four reasons for the selecting the organization.3. Prepare a questionnaire consisting of at least 15 non-trivial questions to collect requirements/information about the organization. This information is required to build data warehouse. Can you please tell me what should be those 15 questions to ask from a company, say a telecom company?Thanks,Kashif

Interview Candidate
Feb 25th, 2006
1
3086

Showing Answers 1 - 1 of 1 Answers

Sanyam Mittal
Profile Answers by Sanyam Mittal

Feb 26th, 2006

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 dimension tables 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.