StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

W2 Asign Determining Requirement in Data Warehousing - Essay Example

Cite this document
Summary
As the query tools specialist in a project team for a manufacturing company, the types of information delivery methods needed would depend on the types of users in the organization. According to Ponniah (2010), the following types of users are normally encountered in an…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER96.6% of users find it useful
W2 Asign Determining Requirement in Data Warehousing
Read Text Preview

Extract of sample "W2 Asign Determining Requirement in Data Warehousing"

Determining Requirement: Data Warehousing al Affiliation Determining Requirement: Data Warehousing How will you determine what types of information delivery methods are needed? As the query tools specialist in a project team for a manufacturing company, the types of information delivery methods needed would depend on the types of users in the organization. According to Ponniah (2010), the following types of users are normally encountered in an organization: novice, casual, business analysts, and power users.

Therefore, the types of possible information delivery methods are as follows: online, intranet, internet, and email (Ponniah, 2010). For power users, for instance, these users “want to be able to navigate throughout the 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.

What kind of details are to be gathered in the requirements definition phase? 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: “Data elements: fact classes, dimensions;Recording of data in terms of time;Data extracts from source systems;Business rules: attributes, ranges, domains, operational records” (Ponniah, 2010, p. 109).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 query tools specialist, one should be able to focus on the needs of the users to determine the extensiveness and comprehensiveness of the information required during the requirements definition phase.

As such, using basic techniques for gathering information, one would be able to facilitate collection of the needed data within the stipulated time frame.ReferencePonniah, P. (2010). Data Warehousing Fundamentals for it Professionals. John Wiley & Sons, Inc.

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“W2 Asign Determining Requirement in Data Warehousing Essay”, n.d.)
W2 Asign Determining Requirement in Data Warehousing Essay. Retrieved from https://studentshare.org/business/1663116-w2-asign-determining-requirement-in-data-warehousing
(W2 Asign Determining Requirement in Data Warehousing Essay)
W2 Asign Determining Requirement in Data Warehousing Essay. https://studentshare.org/business/1663116-w2-asign-determining-requirement-in-data-warehousing.
“W2 Asign Determining Requirement in Data Warehousing Essay”, n.d. https://studentshare.org/business/1663116-w2-asign-determining-requirement-in-data-warehousing.
  • Cited: 0 times

CHECK THESE SAMPLES OF W2 Asign Determining Requirement in Data Warehousing

Various Approaches to KM Strategy

Laura Ashley Is A Global British Iconic Brand.... With Reference To Knowledge Management Strategies and Effective Use of Technology Evaluate the Role of Knowledge Management in Laura Ashley Achieving Competitive Advantage Table of Contents Introduction 3 Knowledge Audit Link to Strategy 4 Codification 4 Personalisation 5 Various Approaches to KM Strategy 6 Competitive Intelligence 6 Customer Relationship Management (CRM) 9 Technology 10 Conclusion 12 References 13 Bibliography 16 Introduction Knowledge Management (KM) primarily refers to an idea where the most essential resources of an organisation provide suitable knowledge to its employees in terms of operational activities....
9 Pages (2250 words) Assignment

The Differences between Marketing as a Philosophy

The author of the assignment discusses the differences between marketing as a philosophy and marketing as a set of business activities and evaluates the marketing opportunities and threats posed by the growing importance of socially conscious consumer.... nbsp;… Research studies are not a simple task which can be done while sitting at home....
22 Pages (5500 words) Assignment

Data Warehousing

This paper ''data warehousing'' tells that In the world today, many organizations are implementing advanced technologies that are aimed at improving the performance of the organizations.... hellip; data warehousing refers to an area within a computer where data is stored in an organized and centralized way.... data warehousing Values.... data warehousing is easy to maintain and fast in generating reports.... Challenges of warehousing data warehousing is important to any business organization, but it faces challenges that every organization should be made aware of....
11 Pages (2750 words) Essay

What_is_the_marketing_research_and_is_it_useful

Market research transforms raw data into meaningful intelligence.... Market research targets the specific information required to address the above issues, design unique methods for collecting data and information, manage as well as implement the collected and filtered data and prepare results and strategize the implications into beneficial action plans (Andreasen, 2002)....
10 Pages (2500 words) Essay

W7D Review Data Warehousing

Practitioners could easily understand concepts on requirements gathering methods (Chapter 5), including the types of questions to be used as… These techniques and skills learned in the process could also be applied in other endeavors: research, applications for employment, and other information-gathering activities. The lesson that seems hardest to Review data warehousing al Affiliation Review data warehousing What is the most practical and easily applied lesson on Datawarehouse?...
1 Pages (250 words) Essay

Risk from the Perspective of a Project Manager

Effective risk mitigation, in a procurement-related project, would involve determining how to build inventory... Business managers responsible for planning, organising and managing a project must identify potential risk factors that could impede the achievement of a project's identified objectives....
12 Pages (3000 words) Essay

Data Warehousing and Business Intelligence

This paper focuses on concepts of "data warehousing and Business Intelligence" that are central for proper data management, particularly if an extremely large amount of data is concerned.... nbsp; For all organizations, data warehousing and Business Intelligence have become key research areas.... data warehousing, in terms of Decision Support systems, could be defined as collections of decision support technologies, trying to enable strategy makers of an organization to take speedy decisions....
10 Pages (2500 words) Essay

The Discipline of Quality Planning

Fuzzy logic is a mathematical technique for dealing with imprecise data and problems that have many solutions rather than one.... We are required to make decisions in a world full of partial information and imperfect data.... The cause and effect (C&E) matrix is a tool that helps teams select, prioritize, and analyze the data they collect over the course of a project to identify problems with that process....
8 Pages (2000 words) Term Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us