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

Business Requirements for Data Warehouse - Research Paper Example

Comments (0) Cite this document
It cannot meet their current expectations as an organization because of their limiting goals the organization set out. Their vision was only to…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER94.7% of users find it useful
Business Requirements for Data Warehouse
Read TextPreview

Extract of sample "Business Requirements for Data Warehouse"

Business Requirements for Data Warehousing Overview of the current data warehouse and business intelligence at Canadian Tire The current BI and data warehouse at the Canadian Tire was started in 1994 and thereafter, it has been on continuous amendments. It cannot meet their current expectations as an organization because of their limiting goals the organization set out. Their vision was only to provide right information/ data at the right for the right decisions, paving way for the proactive and correct business decisions. Canadian Tire principles limited its expansion by being organization centered rather than customer centered.
Requested project team members and their roles
i. CIO and Executive Management: who will justify required cost and come up BI systems using data warehouse technology for the competitive advantages in the available marketplaces.
ii. Project Managers and Decision Support System Architects: they will create accurate organization’s project plans, define requirements that may deter scope creep, and construct an architecture that will meet the organization’s requirements in terms of extendibility, robustness and flexibility over a long period of time.
iii. Database designers: to identify any necessary business data to be store in the physical data model for the data warehouse to make available value to its end users.
iv. Lead designers and business analysts to design the organization’s attainable requirements for data warehouse.
Requirements for the data warehouse and business intelligence.
These will involve:
i. Development roles in company’s decision support and data warehousing system
ii. Pros and cons of the discovery technique and methods for using each of them on data warehouse or any other information decision support system project.
iii. The types of requirements and their advantages in the organization’s development process
iv. Effective against poor requirements at various categories
Lessons learnt about trends and best practices
Trends and best practices enlightens on the understanding of how to define requirements that results to positive ROI; identification of challenges that come with the implementation of a data warehouse; learning of the complete lifecycle criteria in the implementation of a BI system using the data warehouse technology; and to understand how to build a comprehensive data warehouse which is allows for expansions.
A model of the future architecture
Supporting infrastructure changes
The identified infrastructural changes will enable the organization to grow robustly because of effective management and decision making process. Good customer relations will also be ensured, hence giving advantage to the company in terms of market completion.
Summary in support of the design
The effectiveness of the future architecture will enable the organization to overcome the failures that were being experienced in the old design. For instance, the newly designed data warehouse will maintain a copy of data from any source transaction systems. This architectural advancement will provide the opportunity to:
i. Keep track records of all information even when source transactions’ systems do not.
ii. Improve value to operational business features/ applications, i.e. customer relationship management.
iii. Consistently present the organization’s information hence avoiding data duplication.
iv. Reorganize all information in a manner that they make sense to the business users
v. Enhance data quality by ensuring follow of codes and descriptions, flagging and further updating record through spell-check and correction techniques.
vi. Provide a uniform data model for all data of interest in spite of their sources.
vii. Reorganize the data to make sure that it delivers high quality query performance regardless of complexities of analytic queries, with no impact on the operating systems.
List, B., Schiefer, J., Tjoa, A M. (2000). Use Case Driven Requirements Analysis for Data Warehouse Systems, Data Warehousing. Friedrichshafen.
Gotel, O. and Finkelstein, A. (1994). An Analysis of the Requirements Traceability Problem, First International Conference on Requirements Engineering. Los Alamitos: IEEE. Read More
Cite this document
  • APA
  • MLA
(“Business Requirements for Data Warehouse Research Paper”, n.d.)
Business Requirements for Data Warehouse Research Paper. Retrieved from
(Business Requirements for Data Warehouse Research Paper)
Business Requirements for Data Warehouse Research Paper.
“Business Requirements for Data Warehouse Research Paper”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Business Requirements for Data Warehouse

Data warehouse

...? How information systems have revolutionized the way businesses have been operating lately stands at the focus of this paper. The author of the paper has actually summarized the benefits of information systems in the field of business automation and reengineering, customer relationship management, building IT enabled city infrastructures and use of data mining in business analytics. The content of the paper comes from four books reviewed by the author and primarily serves the purpose of delivering fundamental knowledge of the topics which are gaining immense importance today (Gray 2001). The target audience of this paper are mostly scholars and researchers who could get basic information and clear definitions of topics mentioned above...
2 Pages(500 words)Essay

Data Warehouse, Data Mart and Business Intelligence

...?Running head: Computer Sciences and Information Technology Data Warehouse, Data Mart and Business Intelligence Insert Insert Grade Insert Tutor’s Name 13 March 2012 Data Warehouse, Data Mart and Business Intelligence Introduction Many organizations are increasingly adopting data warehousing to enhance reporting and decision making. A data warehouse facilitates the integration of data from various sources, data sharing, and provides consistent, organized, relevant and timely information for decision-making. This discussion explores the differences between data warehouses and databases, data warehouse technologies, and the relationship between data warehousing and business Intelligence. Data Warehouses, Data Marts and Databases A data...
4 Pages(1000 words)Essay

Data Warehouse

... Data Warehouse In computing the term data warehouse (DW) refers to a centrally managed and integrated database containing both raw and formatted data received from various operational sources (in an organization), generally stored in an archival manner for easy access and used for reporting and analysis purposes as shown in fig. 1. Data warehousing is a process of centralized data management and retrieval (Greenfield, par.1). Data warehouses can have both current as well as historical data. The data received from various operational resources in an organization is analyzed using different data analysis tools like ETL, OLAP etc. to create various reports for senior management to take business decisions (Data Warehousing, par. 2...
5 Pages(1250 words)Essay

Data Warehouse Business Pla

... is to determine the initial requirements of the business. Activities involved in this stage include gathering or collecting high-level data requirements of the warehouse and evaluating expectations of the various users such as casual and power users. The last stage is the definition of the data warehouse project and its scope. The scope of the business will function as the business plan of the data warehouse that outlines the objectives and the vital success factors of the business (Khan, 2005). The Infrastructure and Information Systems Needs of the Company The infrastructure plan of the data warehouse describes the hardware, software and data networks, which are crucial in providing support to data warehouse. The infrastructure plan...
5 Pages(1250 words)Assignment

Data Warehouse assignment

The data was analyzed with respect to the time dimension - week. Sales were analyzed against the customers weekly. It was identified that the sales amount graph for the six weeks of 2005 for ALL the customers generated the following trend:
The above graph displays that there was a drop in sales amount in the third week of 2005. Since this is a graph of cumulative sales, we can assume it to be a fair representation (normalized) of the entire dataset. After the third week, the sales picked up again in the fourth week, however, this was not sustained: there was a consistent drop in the fifth and sixth week of 2005. This pattern is an interesting one from an analytical perspective. It shows the cumulative pattern of the sales of...
11 Pages(2750 words)Essay

Data warehouse presentation evaluation

Generally a data warehouse is a trace of an enterprise's past transactional and operational information that is stored in a specially designed database with appropriate facilities for data analysis and reporting.
There is one common idea in the basis of data warehousing design: first data should be integrated from distributed and differently structured databases and then it should be picked out for purposes of reporting, decision support, analysis or control. There are four design approaches to this process that differ by scale of data, action sequences and complexity.
Top-Down Approach assumes that data is transferred from diverse OLTP systems into a centralized place where it could be used for analysis. As Eckerson writes...
2 Pages(500 words)Essay

Data warehouse, data mart and business intelligence

... warehouse, which is also used by similar businesses. On the other hand, data marts are more aligned with specific company motives, system requirements and planning and analysis are performed in an effective manner and as a result implementation, design, installation and testing are less expensive as compared to data warehouses (Demarest, 1993; Firestone, 1997). Moreover, the majority of business organizations implement data marts for the following reasons: Its price is less It does not necessitate digging into business level financial plans There are fewer chances of interdepartmental clashes In addition, they can be developed rapidly and they are able to rapidly create models of success as well as corporate populations that will appear...
2 Pages(500 words)Essay

Data warehouse and data mining in business

The choice of the system depends on the firm’s priority the market is flexible and there is need to introduce a database system management that covers is adjustable.
The need to develop and acquire information technology has revolutionized business. Market analysis refers to the study and acquisition of the market trends and activities associated with the market. When analyzing the market, the firm uses various methods. The most effective is data mining and various tools are used to facilitate it. Patterns are developed using data mining where graphic visualization combine with statistical analysis and refinement to produce the desired market tend or activity. The combination of the three provides for a pattern extraction from...
5 Pages(1250 words)Essay

Data warehouse

...Data Warehouse College: Data Warehouse In the era of development of business technology data warehouse - data mining are crucial tools in the business environment. Data warehouse is a system used for reporting and data analysis of information within organizations. This is a critical tool that many managers use for synthesis of decisions that affect the organizational path. In the contemporary competitive business environment, this has become one of the most popular technologies as decisions become an important determiner of the organizational development. Some of the advantages of data warehousing involves integrating data from different sources and combining it on a common platform, and keeping the data history as a way of tracking...
4 Pages(1000 words)Essay

Warehouse Requirements

...Warehouse Requirements Introduction Variations in customer preferences and tastes have forced commercial airlines to adopt new mechanisms alongside their normal service delivery. Travelling is no longer a luxury but a necessity because to some people, the airplane is their second home. Therefore, there is high demand for food especially in situations where the travels are longer than five hours. Supply-facing warehouse requirements for food in a commercial aircraft are highly dependent on suppliers (Jones, 2004). Most aircraft operations rely on freshly delivered foodstuffs from farms before they are stored in their warehouse for easy distribution among all flights. Alternatively, they liaise up with a re-known grocery store...
1 Pages(250 words)Essay

Business in Japan and South Asia

The Allies later overthrew it. ‘In the heyday of the main bank system, a stable system existed in which banks and other financial institutions mobilized and allocated savings in a high-growth economy regulated by controls over a loan, deposit, and bond issue interest rates.’ (Masahiko Aoki & Hugh Patrick, ‘The Japanese Main Bank System’ p 21).
The structure of the keiretsu was analogous to the tree layout or branched format. It was this very structure that also seems to have lent a lot of stability in the early years of its inception. Each major keiretsu had one particular bank as its primary funding nucleus. This bank lent a specific keiretsu’s member companies money because they held positi...
10 Pages(2500 words)Case Study

Business Management Framework in Educational Organizations

The organizational structure should be present to guarantee clear divisions of authority, responsibility, communication, and control. The second component is the generation of the organization situations for successful implementation such as culture, communications, reward and incentives systems, training, and control (Fonseca 2002).

Two basic theoretical paradigms to business management framework could be identified. The first puts considerable emphasis on structural frameworks to change and involves an issue with organizational design as well as the linkage between organization and environment. This point of view puts less importance upon human activity and the way individuals try to understand or make sense of the wo...
6 Pages(1500 words)Case Study

Business Finance: Activity Based Costing

At that time, the western manufacturing companies were facing serious competition from their Japanese counterparts. The Japanese automotive and electrical products were capturing the market by their low costs. That prompted the Western companies to innovate new costing techniques that would point out their problems and lower the costs. This reason was the main catalyst in the acceptance of ABC. There was resistance by the management of companies who viewed ABC as detrimental to their interests. In addition, the cost of the impletion of ABC was huge which further disinterested the companies. But what the industry was going through in terms of innovation and competition was enough to pave the way for ABC’s smooth transformatio...
7 Pages(1750 words)Case Study

Decisions in Paradise Business Scenario

This paper discusses solutions for the Kava case study along with an implementation plan.
Kava has topography and geographic location that makes it susceptible to natural disasters such as tidal waves, tsunamis, typhoons, hurricanes, floods, fires, volcanic eruptions, and earthquakes (Decisions in Paradise: How to Be, or Not to Be, 2009). There are other issues in Kava. The population is at high risk for Avian Flu and the population faces an HIV / AIDS epidemic. The island is susceptible to petroleum skills and is an undesirable business risk due to the potential ecological state of the entire island. The region is a high risk for both domestic and foreign terrorist attacks. The costs of importing raw materials into the islan...
6 Pages(1500 words)Case Study

Relevance of Kantian Approach to Ethics to Business

These duties Kant named as the categorical imperative (Bowie, 1999). Kant considered that the “basis for the categorical imperative was the reason” (Kant and Deontology). Categorical imperative Kant considered in different ways, for example:
Therefore Kant claimed that individuals follow laws of their choices. Human beings are free and choose themselves how to act, be moral, rational, etc. In compliance with Kant, the individual is autonomous; he lives his life basing on his intentions and reasons and doesn’t care about intentions and reasons of others (Kant and Deontology). There can be traced an idea that an individual as an ‘innocent’ object focused on his own intentions and reasons is of high...
6 Pages(1500 words)Assignment

The Impact of Culture in Overseas Business Transactions

Diversity in culture is eminent and is closely evaluated in terms of their impact and effect on business operations especially when negotiating business deals with overseas organizations. Culture affects people – their needs, wants, aspirations, all of which the leader must tap. The value of taking into account cultural dimensions in day-to-day operations of either multinational corporations (MNCs) or global organizations must be viewed by management as training grounds for business practitioners. The evolution of business organizations has transcended barriers due to the rapid technological advancement that occurred within the last century. The classifications and categories of enterprises continue to increase due to factor...
7 Pages(1750 words)Coursework

Business Ethis across Cultures

Issues of intellectual property protection, Issues of plundering knowledge, Issues of losing brain cheaply, Issues of a new colony, etc are some of the major issues to be considered when we consider China as a knowledge economy. These issues are really complicated and have more depth than we anticipate. Common wellbeing is the major aim of the economic reforms in China today. In fact, all the countries have the same motto; living and working together for the common good, enabling cooperation and mutual prosperity to coexist with healthy and fair competition. Since China is a heavily populated country, balancing the interests of a huge population is a difficult task; but it is necessary to avoid any social, economical, political or...
6 Pages(1500 words)Assignment

Does Corporate Responsibility Provide an Incentive for Business to Become Environmentally Sustainable

It is about fairness in dealing with the stakeholders and transparency and accountability in the organization’s operations. It is primarily based on the principles of Sustainable Development “that meet the needs of the present without compromising the needs of future generations to meet their own needs” according to Bruntland (1987).   The long term social and environmental consequences of the activities, rather than profit motive that should guide an enterprise in its business activities, taking into account the future generations. It is a comprehensive approach in relation to the policies, programs, and practices integrated into the organization’s operations in managing the business to create a...
10 Pages(2500 words)Coursework

Business Law: MAD-IDEA Case

Before a claim can be filed, however, Justine must establish the following conditions: a comparator of the opposite sex; the comparator performs the same kind of work as Justine, and; the comparator is employed by the same company as Justine’s (Blanpain et al, p.56). Evidently, all these conditions are already met by Justine with Thomas easily filling in the role of the comparator, as he is not only of the opposite sex but also an input data worker like Justine employed by MAD-IDEA.

Justine could either claim under “like work,” “work rated as equivalent,” or “work of equal value.” A claim under the “like work” provision of the Equal Pay Act 1970 is laid down in s 1(2...
9 Pages(2250 words)Case Study
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 Research Paper on topic Business Requirements for Data Warehouse for FREE!

Contact Us