Analyzing The Data Warehouse Storage Building A Business Intelligence ( Bi ) Architecture

3246 Words13 Pages
Abstract Recommendations are to utilize a data warehouse to retrieve the data to strategize analysis, root cause of issues, and Data warehouse is one of the most important components in a Business Intelligence (BI) architecture. Building the company’s data warehouse will be difficult from building an operational system. Users will collect data on the overall business of the organization. Requirements to gather will include data elements, recording of data in terms of time, data extract from source systems, and business rules. Before moving data into the data warehouse, users will indicate where the data concerning metrics and business dimensions will come from. The data warehouse Storage Architecture will assist users in minimizing the…show more content…
After the data warehouse starts working properly with the ability to provide queries, print reports, perform analysis, and use OLAP, the information delivery component should continue to grow and expand in order to influence the proper design of the information delivery components. Introduction ABC Industries is a diversified global organization that provides a variety of services, such as financial, technical, and manufacturing of products across the globe. Its facilities are located in Europe, Asia, and the United States with revenue of $35 billion. The company has suffered problems with its retrieving qualitative data from one source. Recommendations are to utilize a data warehouse to retrieve the data to strategize analysis, root cause of issues, and Data warehouse is one of the most important components in a Business Intelligence (BI) architecture. Inmon (2005) defines data warehouse as “a subject-oriented, integrated, time-variant, and non-volatile collection of data in support of management’s decision making process” (p. 29). According to Hoffer et al., 2007; Inmon, 2005 characterizes a data warehouse is a Subject-oriented: Data from various sources are organized into groups based on common subject areas that an organization would like to focus on, such as customers, sales, and products. Integrated: Data warehouse gathers data from various sources. All of these data must be
Open Document