Michael e. Porter advanced in 1998, the characteristics and context of the information society have generated the need to opt for fast, better and efficient methods that can extract and transform a company's data and in turn distribute it to throughout its value chain. Business intelligence can respond to the need raised by porter . It could be deduced, at first, that business intelligence is an evolution of decision support systems. To learn more about business intelligence, you can consult the article business intelligence, advantages of use .
Data warehouse definition the concept of data warehouse means data warehouse. It was born in the 80s due to the need to develop a data storage system. With the requirements of fluid and orderly data management. In this way we e commerce photo editing service achieve significant savings in time and budget compared to traditional data systems. A data warehouse collects and manages data from various sources to provide meaningful business insights. The data will be stored in this warehouse for the period of time necessary to meet the query needs of the organization. It is a centralized data collection. It is separate from operational systems and supports business decision making. In a data warehouse the data is stored from a historical perspective.
The data in the warehouse is obtained from multiple sources. It is verified, cleaned and then integrated with the data warehouse system. The data warehouse requires rapid management of a large storage capacity. This tool can answer any complex data-related queries. The data collected is used to guide decision making. Data warehouse puts at our disposal tools for analysis, reports and data extraction. It constitutes a difference between data mart and data warehouse. For more information on its design, you can refer to the guide to building a data warehouse article . If you want to see a case of implementing a data