Download file to see previous pages...
using involves integrating data from different sources and combining it on a common platform, and keeping the data history as a way of tracking the information coverage within an organization. Understanding the features of the data warehouse and the issues surrounding this technology is crucial for its application in the public domain.
Data warehouse has a number of key features that aid in the storage, processing and analysis of information. One of the key features is the data integration feature within its core. This feature is particular crucial in combining information from both external and internal sources. External sources include the external market factors such as the competition while the internal features include sales from different branches of the organization. The integration features helps to combine information required in processing decisions that affect the whole organization. Secondly, the data warehouse has the SQL Server that allows in merging of information, changing data capture and management of information. The analysis feature in the data warehouse helps in processing of the information depending on the particular queries. The queries are inputs that allow computation of specific variables that the management requires. Another key feature includes the reporting services that include the reporting scalability and server scalability. This is the output feature that presents key information required for decision making (Bhansali, 2009). The combination of these features makes it possible to obtain data, combine it and synthesise it according to specific requirements of the user.
One unique function of data warehouse is to aggregate information and store it. The warehouse architecture comprises of operational databases that provide information for the data warehouse. The warehouse gathers information from all these operational databases and combines it. Another crucial function of the warehouse is the storage of information within a common
...Download file to see next pagesRead More
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.
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.
Data warehousing is a process of centralized data management and retrieval. Data warehouses can have both currents 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.
This business plan will highlight the overview and structure of the business forming the basis of issue identification and strategic assessment. The business plan points out the infrastructure and information systems of the company and role in management and operation of data warehouses.
It was analyzed that there was a correlation of 0.76 between the measures: sales amount and sales quantity. This significantly high correlation value means that the higher the sales quantity, the higher the sales figure. Though this is a logically true relationship, the fact that this is one of the findings from the data in the warehouse makes it an analysis of the data from the data mart.
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, the major benefit of a Top-Down Approach is that it provides an integrated, flexible architecture to support downstream analytic data structures.
Effective and efficient management of information depends on how good and efficient the data warehouse in an organization is made. Data warehousing is the base for introducing any business intelligence tool in the organization.
warehouse that combines data from a variety of sources such as corporate databases or information systems and serves a range of front-end reporting, querying and analytic tools (Dayal, Castellanos, Simitsis, & Wilkinson, 2009). In addition, the data warehouse is a database of
2 Pages(500 words)Essay
GOT A TRICKY QUESTION? RECEIVE AN ANSWER FROM STUDENTS LIKE YOU!
Let us find you another Essay on topic Data warehouse for FREE!