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

3246 Words Mar 30th, 2015 13 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 risk of an improperly configured and architected storage system and improve the data warehouse implementation. Information Delivery Framework and Data Warehousing Information delivery has methods for making information available to users. The information delivery component will make it easy for users to access information from the enterprise-wide data warehouse, dependent data mart, and from a set of conformed data marts. Information delivery framework will consist of online analytical processing (OLAP) for data flow and data mining, providing query services from user desktop from an application server, and utilize data stores for standard reporting and dashboards. The historical data can go back 10 to 20 years representing important…

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

Open Document