Äþ²¨°¢ÌØÀ˹ÈýÈð»úµçÓÐÏÞ¹«Ë¾CRMʵ¼ù_ÐÅÏ¢¹ÜÀíÂÛÎÄ
·¢²¼Ê±¼ä£º
2015-03-15
À´Ô´£º
ÈË´ó¾¼ÃÂÛ̳
ÐÅÏ¢¹ÜÀíÂÛÎÄ·¶ÎÄ
Ŀ¼
µÚÒ»ÕÂ ÒýÑÔ1
µÚÒ»½Ú Ñо¿±³¾°1
µÚ¶þ½Ú Ñо¿µÄÒâÒå1
µÚÈý½Ú ¹úÄÚÍâÑо¿ÏÖ×´2
µÚËÄ½Ú Ö÷ÒªÑо¿ÄÚÈÝ5
µÚ¶þÕ ¿Í»§¹Øϵ¹ÜÀíÀíÂÛ6
µÚÒ»½Ú CRMµÄÐγÉ6
µÚ¶þ½Ú CRM¹ÜÀíÀíÄî6
µÚÈýÕ Äþ²¨°¢ÌØÀ˹ÈýÈð»úµçÓÐÏÞ¹«Ë¾CRMÏÖ×´·ÖÎö10
µÚËÄÕ CRMϵͳÉè¼ÆÓë¹¹½¨£º¿Í»§ÏµÍ³µÄ½¨Á¢13
µÚÒ»½Ú Êý¾ÝÍÚ¾ò¼°ÆäÔÚCRMÖеÄÓ¦ÓÃ13
Ò» Êý¾ÝÍÚ¾ò¼¼Êõ13
¶þ Êý¾ÝÍÚ¾òÔÚ CRM ÖеÄÓ¦ÓÃ15
Èý Êý¾ÝÍÚ¾òÔÚ CRM ÖÐʵʩ¹ý³Ì17
µÚ¶þ½Ú CRMµÄÐèÇó·ÖÎö18
µÚÈý½Ú CRMϵͳÌåϵ½á¹¹19
Ò» Êý¾ÝÍÚ¾òƽ̨µÄ²ã´ÎÄ£ÐÍ19
¶þ ϵͳÕûÌå½á¹¹19
µÚËÄ½Ú CRMµÄÊý¾Ý¿âÉè¼Æ20
µÚÎå½Ú Êý¾Ý±íÉè¼Æ22
µÚÁù½Ú CRMµÄÏêϸÉè¼Æ22
Ò» Ä£¿é¹¦ÄÜÃèÊö22
¶þ ϵͳ¹¦Äܽṹͼ23
µÚÎåÕ ˼¿¼Ó뽨Òé24
µÚÒ»½Ú ˼¿¼24
µÚ¶þ½Ú ½¨Òé24
Ò» ÔÚʵʩCRMϵͳ·½ÃæµÄ½¨Òé24
¶þ ÔÚCRMÖÐÓ¦ÓÃÊý¾ÝÍÚ¾ò·½·¨·½ÃæµÄ½¨Òé25
µÚÁùÕ ½áÂÛÓëÕ¹Íû27
µÚÒ»½Ú ÂÛÎÄ×ܽá27
µÚ¶þ½Ú δÀ´Õ¹Íû27
²Î¿¼ÎÄÏ×28
ÖÂл
Õª Òª
±¾ÎÄËùÌá³öµÄ»ùÓÚÊý¾ÝÍÚ¾òµÄCRMµÄÑо¿Æ½Ì¨£¬ÊǸù¾ÝÄþ²¨°¢ÌØÀ˹ÈýÈð»úµçÓÐÏÞ¹«Ë¾¿Í»§¹ÜÀí·½ÃæµÄ·¢Õ¹ÐèÇó£¬ÎüÈ¡¹úÄÚÍâ³É¹¦Ó¦ÓõľÑ飬´Ó¶øʹ¹«Ë¾µÄÀûÒæ´ïµ½×î´ó»¯£¬ÊµÏÖÁË¿Í»§¼ÛÖµºÍ¹«Ë¾ÀûÒæË«Ó®µÄÄ¿µÄ¡£
¿Í»§¹Øϵ¹ÜÀí(Customer Relationship Management, CRM)ÊÇ°ïÖúÆóÒµÁ˽â¿Í»§ºÍ°ÑÎÕÊг¡µÄÖØÒª¹¤¾ß£¬¶øÊý¾ÝÍÚ¾òÔò¿ÉÒÔ´Ó´óÁ¿¿Í»§Êý¾ÝÖÐÍÚ¾ò³öÒþº¬µÄ¡¢¶ÔÆóÒµ¾ö²ßÓаïÖúµÄ֪ʶºÍ¹æÔò£¬¹Ê½«Êý¾ÝÍÚ¾òÓ¦Óõ½CRMϵͳÖн«»áΪÆóÒµ³ÊÏÖ¸ü¶àÓмÛÖµµÄÊý¾Ý¡£ÎªÁ˽â¾öÕâ¸öÎÊÌ⣬ÄÃÄþ²¨°¢ÌØÀ˹¹«Ë¾×÷Ϊʵ¼ÊµÄÑо¿±³¾°¡£±¾ÎĽ«Êý¾ÝÍÚ¾ò¼¼ÊõÈÚÈëµ½¿Í»§¹Øϵ¹ÜÀíϵͳµÄ¿ª·¢ÖÐÈ¥£¬¿ª·¢ÁËCRM¿Í»§¹Øϵ¹ÜÀíϵͳ£¬Ö÷Òª½øÐÐÁËÒÔϹ¤×÷:
1)Ñо¿ÁË¿Í»§¹Øϵ¹ÜÀíϵͳµÄ½á¹¹¡¢×é³ÉÒÔ¼°Êý¾ÝÍÚ¾òºÍÊý¾Ý¿â¼¼ÊõÔÚÆäÖеÄÓ¦Óã»
2) ID3Ëã·¨·Ö±ðʵÏÖÁË¿Í»§¼ÛÖµ·ÖÎö¹¦ÄܺͿͻ§Öҳ϶ȷÖÎö¹¦ÄÜ£¬ÒÔÖ§³ÖÆóÒµ¾ö²ß£»
3)¸ø³ö²¢½éÉÜÁËCRMϵͳµÄ¹¦ÄÜ¡¢¼Ü¹¹ÒÔ¼°ÏàÓ¦µÄÊý¾Ý¿â½á¹¹£¬²¢½áºÏMicrosoft Access 2003¹¤¾ßʵÏÖÁËÊý¾ÝµÄ³éÈ¡ºÍת»»¡£
CRMϵͳÒÔÊý¾Ý¿âºÍÊý¾ÝÍÚ¾ò¼¼ÊõΪ֧³Å£¬¾ß±¸²Ù×÷ÐÍCRMϵͳµÄ»ù±¾¹¦ÄÜ£¬Í¬Ê±ÊµÏÖÁË¿Í»§¼ÛÖµ·ÖÎö£¬¿Í»§Öҳ϶ȷÖÎöµÈһЩ·ÖÎöÐÍCRMϵͳµÄ¹¦ÄÜ£¬ÊÇÒ»ÖÖ½éÓÚ²Ù×÷ÐͺͷÖÎöÐÍCRMϵͳ֮¼äµÄϵͳ¡£
¹Ø¼ü´Ê£º¿Í»§¹Øϵ¹ÜÀí¡¢Êý¾ÝÍÚ¾ò¡¢Êý¾Ý¿â¡¢¿Í»§Öҳ϶È
ABSTRACT
This paper presents a solution to design an CRM platform with its CRM (Customer Relationship Management) component based on Data Mining. It absorbs domestic and foreign successful experience. Thus it is benefit of both of my company and customers. Meanwhile ,it realizes customer value and company profits¡¯ goal.
Customer Relationship Management (CRM) system is an important tool for enterprises to understand customers and seize the market, and data minim can reveal the unknown knowledge and hidden rules from the large amount of customer data, thus applying data mining method into CRM system will bring more valuable data to enterprises. To solve this problem, taking a medium- sized enterprise in the company of Ning Bo a te la si as the actual background, a Customer Relationship Management system called CRM is developed combining data mining method. Meanwhile, the following work is done:
1)The structure, component of CRM system, the application of data mining and data warehouse technology in CRM system are researched.
2) The customer churn analysis method and customer loyalty are realized respectively based on ID3 decision making tree algorithm.
3) The function, structure, database and data warehouse structures of CRM system are analyzed, and the data extraction and transformation function is achieved using Microsoft Access 2003.
Based on database and data mining technology, CRM is a kind of system-system CRM system between the operational CRM and analytical CRM system, which not only contains the basic functions of operational CRM but also supports customer value analysis, customer churn analysis and loyalty analysis.
KEYWORDS£ºCustomer Relationship Management¡¢Data Mining¡¢Database¡¢Customer loyalty