W2 Asign Determining Requirement in Data Warehousing - Essay Example

Comments (0) Cite this document
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 paperFile format: .doc, available for editing
GRAB THE BEST PAPER91% of users find it useful
W2 Asign Determining Requirement in Data Warehousing
Read TextPreview

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.
Ponniah, P. (2010). Data Warehousing Fundamentals for it Professionals. John Wiley & Sons, Inc. Read More
Cite this document
  • APA
  • MLA
(“W2 Asign Determining Requirement in Data Warehousing Essay”, n.d.)
W2 Asign Determining Requirement in Data Warehousing Essay. Retrieved from
(W2 Asign Determining Requirement in Data Warehousing Essay)
W2 Asign Determining Requirement in Data Warehousing Essay.
“W2 Asign Determining Requirement in Data Warehousing Essay”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF W2 Asign Determining Requirement in Data Warehousing

Data Warehousing and data mining

...capacity increased significantly at affordable prices.” The storage of historical data is an ultimate requirement of data warehouses (DWs) because it is utilized for knowledge discovery, formally known to be data mining (DM). DWs can retain all historical time stamped data, which helps to generate patterns of customer, product and employees’ behaviors. It is important to note that data warehouse is not a system that can be deployed in an environment rather it is a concept that shapes and evolves through integration of various tools and steps of data warehousing. More importantly, data...
10 Pages(2500 words)Research Paper

Data Warehousing and Mining

...). Though it is feasible to produce the required results through such SQL characteristics as inline views, self joins and user-defined utilities the consequential queries could be difficult to recognize and may produce incorrectly long times for implementation. IMPACT OF PARALLEL COMPUTING TECHNOLOGIES ON DATA WAREHOUSING AND DATA MINING The complicated nature of data mining practices and the size of corporate data require performance that could be simply derived from very influential parallel computing systems...
18 Pages(4500 words)Essay

Data Management: Data Warehousing and Data Mining

...?Information Systems have hitherto relied upon data quality and integrity for its management. Countless companies faced numerous problems in accomplishing this task but thankfully SAP has emerged as effective, efficient and user friendly tool that customizes software to meet the particular needs of the company. SAP solutions are getting recognition worldwide and it had highest analytical and performance management revenue in the year 2010 (Gartner, 2011) Among the various products SAP has launched one of the very affective tool for business analytic solutions is SAP BusinessObjects. Users can explore and compare relevant information through SAP BusinessObjects Explorer even if they lack in IT training as it provides a...
2 Pages(500 words)Research Paper

Enterprise Data Warehousing and Data Mining in for a surprise. Obtaining these next order benefits requires firms to figure out, usually by trial and error, how to change business practices to best use the data warehouse and then to change their business practices. And that can be harder than implementing a data warehouse. Extract, Greenfield, L (2005). There can be a problem with staff running reports every at regular times when they are in fact no longer required, but they still take up time and resources every time the report is run. A careful watch has to be kept on the situation of reports being run. Some company’s have the IS team run reports and check to make sure they are not out of date or unwanted....
3 Pages(750 words)Coursework

Data Warehousing & Data Mining

.... This is because the role of the data warehouse will determine the quality and capacity of the required database. Developers of the data warehouse also need to consider data modification and data integration requirements. c. How is data mining used in conjunction with a data warehouse? The aim of data warehousing is to facilitate decision-making. Data mining can be used in conjunction with data warehousing to facilitate certain decision-making initiatives. Data mining is the process of...
3 Pages(750 words)Assignment

Data Warehousing and Data Mining

...? Full Paper Data Mining 3NF is usually recommended for a corporate environment managing massive amount of replicated data. For instance there is no requirement of saving data several times. However, there is a requirement of doing more joins. Comparatively, 1NF will provide the functionality of storing replicated data regardless of number of joins. It is the choice of database administrator to evaluate what is the right form; it may be 3NF or 1 NF. Moreover, normalization comprises of five rules that are applied on a relational database. The main objective is to eliminate or minimize the redundancy and at the same time increasing...
6 Pages(1500 words)Essay

Data Warehousing

.... The tools that are used in gathering the summarized data from various sources into the data warehouse are online analytical processing systems and the query tools. The tools are used in supporting adhoc analysis, inquiring and reporting of the data to the end-users without asking for assistance from the programmers while undertaking the required tasks in the appropriate manner (Witten & Frank 2000). Data warehousing Values. Data warehousing is easy to maintain and fast in generating reports. It is widely preferred because it doesn't require too much technical knowledge to control it...
10 Pages(2500 words)Essay

Data Warehousing in Healthcare

... Data Warehousing in Healthcare Outline I. Overview and objectives of the technology II. Manufacturers of the technology III. Operational requirements a. Hardware b. Software c. Network d. Information IV. The requirements for maintenance and support V. Important stakeholders VI. Business processes VII. Value/Benefits VIII. Opportunities for improving the technology a. Business b. Technical Declaration I pledge on my honor that I have not given or received any unauthorized assistance on this assignment/examination. I further pledge that I have not copied any material from a book, article, the Internet, or any other source except where I have expressly cited the source. Signature ________________ Date... of information to allow...
5 Pages(1250 words)Article

Data Warehousing

...Data Warehousing Introduction Data warehouse can be d as a database system through which several data can be analyzed and evaluated at a time. The concept of data warehouse has been introduced to extract, filter, classify and cluster data.. The actual purpose of developing data warehouse is to perform data analysis quickly and efficiently. In modern era, unprecedented advancement can be observed in the field of science and technology. Thus, in the current era people can be identified to have little time engaging in data processing unlike in the past decades. Notably, these advancements...
7 Pages(1750 words)Research Paper

W7D Review Data Warehousing

...Review Data Warehousing al Affiliation Review Data Warehousing What is the most practical and easily applied lesson on Datawarehouse? From among the lessons learned on data warehousing, the most practical and easily applied is the module on defining business requirements. Practitioners could easily understand concepts on requirements gathering methods (Chapter 5), including the types of questions to be used as well as the other techniques that were discussed (Ponniah, 2010). These techniques and skills learned in the process could also be applied in other endeavors: research, applications for employment,...
1 Pages(250 words)Essay
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.

Let us find you another Essay on topic W2 Asign Determining Requirement in Data Warehousing for FREE!

Contact Us