During the process of enterprise information construction, in order to improve the efficiency of daily work as well as to improve the market adaptability of this enterprise, most enterprises will establish different business systems to meet the demand according to the market, customers and the enterprise itself. However, this system is often due to market demand, design concepts, construction time, platform selection and other factors of inconsistency and lead to the system is independent of each other, information dispersion and other characteristics, thus forming an information island, in order to solve the above problems, the enterprise needs a proven technology for information integration, through the integration of different system information for the enterprise to provide a unified decision-making and analysis platform, to help enterprises to solve the actual business Problems (eg: how to improve customer satisfaction and loyalty, reduce costs, increase profits, rational allocation of resources, effective overall performance management, etc.). People tend to use data warehouse technology to realize.

There are 3 benefits to using a data warehouse:

(1) A data warehouse can provide accurate and timely reports to the business department. Although the business system can also provide reporting capabilities, but because the business processing system is developed to achieve a business function, business processing system reports can only provide local information, can not provide information about the enterprise as a whole, so that managers have "only see the trees, not see the forest" feeling. In addition, the reports in the business system is relatively fixed, for the business staff to temporarily put forward some analysis requirements, must be a large number of software personnel to realize the hard work of development, business personnel often feel that the report function can not meet the requirements of management. The flexible reporting tools provided in the data warehouse can easily add new reports to adapt to changes in business.

(2) The data warehouse can give managers more powerful analytical capabilities. Online Analytical Processing (OLAP) is a means of analysis often used in data warehouses.OLAP technology makes it easy for users to analyze information from multiple perspectives so that business people can learn more about it. For example, for business revenue metrics, we can learn through which channels each product was sold and to which types of customers, and we can see not only the total sales revenue for a region, but also the sales in each city and store in that region, right down to looking at a specific sales contract.Another benefit of OLAP analysis is that it uses business terms rather than technical terms to describe things, so business people have a clear understanding of what the data objects mean and can perform business analysis on their own without having to rely on technicians.

(3) Data warehouse is the basis for data mining and knowledge discovery. The use of data mining technology, we can find patterns and laws in the data, for example, we can learn what kind of consumer behavior is not allowed user groups, how sensitive to price. Utilizing this knowledge can help companies predict future trends, develop more accurate market strategies, and achieve cross-selling/up-selling goals. Since data warehouses have achieved the integration of enterprise data and provide consistent information that reflects the overall picture of the enterprise, data mining on the basis of data warehouses can make the results of predictive analysis more accurate and complete.

With the cloud computing, big data continues to deepen, accompanied by a huge amount of data, so how to better extract useful information from this data? Then the data warehouse plays his great potential.