W2 Asign Determining Requirement in Data Warehousing Essay

W2 Asign Determining Requirement in Data Warehousing - Essay Example data warehouse, pick-up interesting data, format his or her own queries, drill through the data layers, and create custom reports and ad hoc queries† (Ponniah, 2010, p. 40). As such, these power users usually seek complex information, multidimensional (MD) analysis, and statistical analysis which could be facilitated through the online, intranet, internet, as the use of emails. As learned from Ponniah (2010), the â€Å"primary goal in the requirements definition phase is to compile information packages for all the subjects for the data warehouse† (p. 105). The kinds of requirements that one needs to gather at the requirements definition phase are categorized as follows: The gathering of information during this phase could be solicited through three (3) primary means or basic techniques: interviews, joint application development (JAD) sessions, and through questionnaires (Ponniah, 2010). Thus, the kind of details to be gathered would depend on the needs and demands of the users in the organizations. Through the use of the basic techniques for gathering information, as the query tools specialist, one must be able to comprehensively assess and determine the informational requirements of each user according to the category of requirements as stipulated above. Likewise, the types of questions that should be designed and communicated to the users should be structured in the most effective manner to facilitate solicitation of the appropriate response. Concurrently, it was also learned that aside from utilizing these three (3) basic techniques for data gathering and collection, one could gather useful information through the evaluation of existing documentation (Ponniah, 2010). As emphasized, â€Å"review of existing documentation can be done by the project team without too much involvement from the users of the business units. Scheduling of the review of existing documentation involves only the members of the project team† (Ponniah, 2010, pp. 115-116). Overall, as the