A Data Warehouse Design for Institutions Information System

Data Warehousing is a technique of bringing collectively all of a companys data from different computer systems, together with those connecting to customers, employees, vendors, product, inventory, and financial etc. The data warehouse connects different database together in order to offer a more inclusive data set for making decision. Presently, large enterprises work on database systems to manage their data and information. These databases are useful for conducting daily business transactions. However, the tight competition in the marketplace has led to the concept of data mining in which data are analyzed to derive effective business strategies and discover better ways in carrying out business. The paper considers how different ways of determining such warehouse have been developed and how confident organizations have used them to increase control over data and decision making. This reveals that organization that can develop a strong system, data warehousing is value the cost. A physical repository where relational data are specially organized to provide enterprise, cleansed data in a standardized format.