节点文献
客户关系管理中数据仓库技术应用研究
CRM Application of Data Warehouse
【作者】 杨占业;
【导师】 李也白;
【作者基本信息】 北方工业大学 , 计算机软件与理论, 2011, 硕士
【摘要】 电子商务的飞速发展,使传统的商业模式受到了严峻的挑战,它要求企业以全新的思维来看待客户。在这种情况下,客户关系管理得到了广泛的应用和发展,它为企业提供了收集、分析和利用各种客户信息的应用系统,以及企业面对客户的科学手段和方法,使企业的销售理念从以产品为中心转换到以客户为中心。目前传统的CRM信息系统产生大量的客户特征信息和客户行为信息,但是这些信息仅仅局限于表面的数据记载,缺少深层次的分析,并且随着企业规模和基础数据的不断增加,对于客户的管理也越来越难,因此,运用数据仓库技术构建分析型CRM系统就显得尤为重要。数据仓库是一种数据集成分析技术,它能将企业各个级别数据库中的数据集成到一起,并最终以数据立方体的形式展现给最终用户,实现多维度分析,能够快速、直观的将决策信息提供给企业管理者,成为企业进行决策的有利工具,数据仓库作为CRM的底层核心,在未来企业的商务智能中发挥的作用会越来越大。本文研究了数据仓库技术在企业分析型CRM中的应用,根据电子商务企业的特殊应用背景,设计了面向客户、订单、销售三个粒度的主题数据仓库,利用SQL Server2000为数据仓库的物理存储,提供强大的存储功能和检索功能;应用开源OLAP引擎Mondrian作为OLAP服务器,提供强大的多维分析功能;利用OPENI作为前端的分析展现工具,提供多维前端展示。最终通过数据仓库技术实现分析型CRM,并重点对客户价值、客户分级以及客户流失进行多维分析,为企业管理层的决策提供信息支持,并在应用中,验证以上模型和方法的有效性。
【Abstract】 The rapid growth of E-commerce presents a severe challenge for the traditional enterprises, which requires enterprises to regard clients with new thinking. In this background, customer relationship management has been widely used and developed, which provides enterprises application system to collect、analyze and exploit customer information,and scientific methods to manage customers. It changes company’s marketing concept from product-centric to customer-centric. Traditional CRM information systems produce a large amount of customer characteristic information and customer behavior information, but the information is only limited to original data records and lack of deep analysis, with increasing firm size and volume of basic data, management of customers become more and more difficult. Therefore, the application of data warehouse technology to build an analytical CRM system is particularly important.Integrated data warehouse is a data analysis technique. It can integrate all levels of data in enterprise database together and eventually form a data cube to show to end users. It can realize multi-dimensional analysis, and provide decision-making information for enterprise managers fast and intuitively. It becomes a powerful tool for decision-making. As the basic core of CRM, data warehouse will become more important in the field of business intelligence in future.This paper studies the application of data warehouse technologies in enterprise CRM. According to the particular background of technologies application data warehouse with themes of customers, orders and others are built, using SQL Server 2000 to provide powerful storage and retrieval. This work takes open source OLAP engine Mondrian as the OLAP server o provide powerful multi-dimensional analysis, and employs OPENI as the front end of the analysis tools to provide multi-dimensional front-end display. Finally analytic CRM based on data warehouse technologies CRM. Multi-dimensional analysis customer value, customer classification and customer churn. It provides information to support decision-making for enterprise managers, and verify the validity of these models and methods in the application.
【Key words】 CRM; Data Warehouse; Customer Classification; Customer Churn;