Along with the rapid development of internet,CRM has become one of the most important facts leading the enterprises to be competent.At the same time,the analytical CRM based on Date Warehouse is the kernel of CRM syst...Along with the rapid development of internet,CRM has become one of the most important facts leading the enterprises to be competent.At the same time,the analytical CRM based on Date Warehouse is the kernel of CRM system.This paper mainly explains the idea of CRM and the DW model of analytical CRM system.展开更多
In this paper, we designed a customer-centered data warehouse system with five subjects： listing, bidding, transaction, accounts, and customer contact based on the business process of online auction companies. For ea...In this paper, we designed a customer-centered data warehouse system with five subjects： listing, bidding, transaction, accounts, and customer contact based on the business process of online auction companies. For each subject, we analyzed its fact indexes and dimensions. Then take transaction subject as example, analyzed the data warehouse model in detail, and got the multi-dimensional analysis structure of transaction subject. At last, using data mining to do customer segmentation, we divided customers into four types： impulse customer, prudent customer, potential customer, and ordinary customer. By the result of multi-dimensional customer data analysis, online auction companies can do more target marketing and increase customer loyalty.展开更多
文摘Along with the rapid development of internet,CRM has become one of the most important facts leading the enterprises to be competent.At the same time,the analytical CRM based on Date Warehouse is the kernel of CRM system.This paper mainly explains the idea of CRM and the DW model of analytical CRM system.
基金Supported by the National Natural Science Foundation of China (70471037)211 Project Foundation of Shanghai University (8011040506)
文摘In this paper, we designed a customer-centered data warehouse system with five subjects： listing, bidding, transaction, accounts, and customer contact based on the business process of online auction companies. For each subject, we analyzed its fact indexes and dimensions. Then take transaction subject as example, analyzed the data warehouse model in detail, and got the multi-dimensional analysis structure of transaction subject. At last, using data mining to do customer segmentation, we divided customers into four types： impulse customer, prudent customer, potential customer, and ordinary customer. By the result of multi-dimensional customer data analysis, online auction companies can do more target marketing and increase customer loyalty.
