Dimensional Modeling Application In The Crm System

Recently, as the ability that beer industry utilizes the information technology to product and collect data is improved by a wide margin, lots of databases are used in the management, official working, and scientific research and project development. As a result, How to utilize infonnation resources, keep existing customer, open up the new market effectively and improve the key competitiveness of enterprises, is becoming the core problem of industrial information construction of beer.This paper is, mainly through the summary of the experience which implements the industrial analytical CRM system of beer of nantong dafuhao, to research and summarize the design and implementation of the analytical CRM system of beer industry, which is based on data warehouse.In dimensional modeling, design the large-scale change customer dimension by splitting it into some mini dimensions degree. It has solved the problem of recording historical information and optimizing inquiry about large-scale change customer dimension effectively; in analysis modeling, propose a improved method of splitting customer into five degrees, cut apart the customer scientifically and establish the foundation for realizing to the personalized service. In OLAP data store, design and realize the method combined MOLAP with ROLAP. It has given consideration to the advantage that the high-efficient data store and fast inquiry respond. Meanwhile, look forward to the application of data mining technology in beer industry and research the testing modeling of contentment by customer.