客户关系管理系统中数据仓库的设计与实现

Design and realization of data warehouse in customer relationship management system

论述了在客户关系管理系统中数据仓库的设计方案和具体实现方法。通过数据采集、数据清理、数据加载的技术将客户历史数据转换成数据仓库数据,并以多雏模式进行存储,运用MDX多维表达式方法进行分析。结果表明:建立以“客户”为主题的数据仓库,借助MDX分析技术,可以发现客户关系管理系统中隐藏的客户购买模式,为企业的决策提供了有价值的商业指导信息。

This paper describes the design and the realization of data warehouse in customer relationship management system, and gives MDX operations in multidimensional data analysis. The result shows it can make a model of custom purchaser to set up data warehouse centered on customers by MDX analysis technology. The practice provides valuable commercial information for enterprise decision.