6138-6146
DATA WAREHOUSE- A KEY TO MANAGEMENT DECISIONS
Authors: Amneet Kaur
Number of views: 803
A data warehouse is a subject-oriented, integrated, time-variant, non-volatile collection of data in
support of management's decision making process. Data warehousing is the data management and
analysis technology. Data in the data warehouse is preprocessed and presented such that it facilitates
the cross functional monitoring and assessment of the overall direction of the organization. Thus, it is
the hub for an intelligent management decision support. Successful implementation of a data
warehouse requires a high-performance, scale able combination of hardware and software, which
can integrate easily with existing systems, so that users can use data warehouse to improve their
decision-making. A data warehouse is incomplete until it provides the exploitation tools that enable
end users to view analyze and report on data in ways that support their decision-making. Data marts,
data mining, data modeling and metadata are some other important concepts attached with data
warehousing, the knowledge of which helps to a great extent in data warehouse implementation.
Business intelligence data warehouse is the combination of two terms frequently used in the data
mining and analysis field. When used together, vendors are trying to emphasize that they offer more
services than just data warehousing alone. Because business intelligence can encapsulate a wide
variety of services and tools, combining the terms into business intelligence data warehouse reflects
that the vendor offers everything an organization needs, including the basics of data warehousing.
Many organizations prefer to purchase business intelligence tools and data warehousing as a
combined business intelligence data warehouse system in order to increase the efficiency of the
integrated system. The key advantages of using a Data warehouse business intelligence system is
that it makes it much simpler to analyze and report on the information extracted from the data
entered into the system. In the cleansing stage of the data warehousing process, all inconstancies in
the data are determined and taken care of before the data enters the ETL stage. The effectiveness of
the data warehouse application intensifies especially when the operational data resides in
distributed, non-homogenous systems and replace manual data gathering and reconciliation
procedures. Therefore, data warehousing can be useful to not only commercial sectors but also to
sectors like government, health care, insurance, manufacturing, finance, distribution, education The
goal of a data warehouse application in an organization is to increase the effectiveness of the
Decision-making and direction setting process. Data in the data warehouse is preprocessed and
presented such that it facilitates the cross functional monitoring and assessment of the overall
direction of the organization. Thus, it is the hub for an intelligent management decision support. A
data warehouse is incomplete until it provides the exploitation tools that enable end users to view
analyze and report on data in ways that support their decision-making. The aim of the paper is to
generate the knowledge of data warehousing concept and its advantages in the era of globalization.
To study the structure and application of data warehousing. Acquiring right information at the right
time from the huge ocean of data is becoming difficult day by day. Data warehouse helps to convert
the information overload in to meaningful strategic information