現今產業的競爭日益激烈以及消費需求的異質性逐漸高漲,而企 業在這樣的環境之下,過去的大量行銷策略已無法滿足企業的需求,
如果企業無法掌握有效的行銷策略來取得優勢,是無法在這競爭環境 中生存,因此,企業必須根基於顧客的個人需求來從事行銷活動才能 正確地找到主要消費群,以便節省行銷推廣的成本以及增加商品銷售 量。目前最常使用到的方法就是利用顧客資料庫中所儲存的消費資 訊,利用過去的交易資料、顧客的背景資料加以分析以得到許多有意 義的資訊,並且利用所分析出來的資訊,使企業能夠進行得更有效率 的行銷策略和應用。
本研究運用關聯規則技術,嘗試從顧客的消費意願問卷資料中,
分析出消費者購買電子產品時的考量因素關聯性,實驗部分:分別以
購買手機以及購買數位相機為例,運用Microsoft SQL Server 2000、
MS Access 2003 實作 Apriori 演算法以及運用 SQL Server 2005 Business Intelligence 等資料探勘工具挖掘出有趣的關聯規則,例如:
如果希望手機的加值服務是遊戲的話,則消費者興趣為聽音樂的支持 度為 57%;而信心度為 84%。本研究所找出的關聯規則,將可提供 給行銷部作為行銷策略制定之參考。未來研究將加入更多有意義的量 測準則,期能找出更有價值或是更有意義的關聯規則。
附錄
附錄一:手機問卷調查網頁畫面
附錄二:數位相機問卷調查網頁畫面
參考文獻
[5] Agrawal R., Imielinski T. and Swami A., “Mining Association Rules Between Sets of Items in Large Databases,” Proc. of the ACM SIGMOD Conference on Management of Data, pp 207-216, 1993.
[6] Agrawal R. and Srikant R., “Fast algorithms for mining association rules in large database,” Proceedings of the 20th International Conference on Very Large Data Bases, pp. 487-499, 1994.
[7] Berry M. J. A. and Linoff G., “Data mining techniques : for marketing, sales, and customer support, ” New York: Wiley,1997 [8] Berry M. J. A. and Linoff G., “Mastering Data Mining: The Art and
Science of Customer Relationship Management”, John Wiley & Sons, Inc, 2000.
[9] Brin S., Motwai R., Ullman J.D. and Tsur S., “Dynamic Itemset Counting and Implication Rules for Market Basket Data”, ACM SIGMOD Conference on Management of Data, pp. 265-276, 1997.
[10] Brachman R.J., Khabaza T., Kloesgen W., Piatetsky-Shapiro G. and imoudis E., “Mining Business Databases,” Communications of the ACM, New York, Vol. 39, No. 11, Nov. pp. 42-48, 1996.
[11] Bugel, Marnix S. and Bertina A. H. Bus, ”The Strategic Utilization of Database Marketing”, The Journal of Database Marketing, Vol.6, No.2, pp. 156-163, 1998.
[12] Chen M. S., Han J. and Yu P. S. , “Data Mining:An Overview from a Database Perspective,” IEEE Transactions on Knowledge and Data Engineering, vol.8 , no. 6, pp. 866-883, 1996.
[13] Coenen F., Leng P. and Ahmed S., “Data structure for association rule mining T-trees and P-trees,” IEEE Transactions on Knowledge and Data Engineering, vol. 16, no. 6, pp. 774-778, 2004.
[14] Fayyad U., Piatetsky-Shapiro G. and Smyth P., “From Data Mining to Knowledge Discovery in Databases,” AI Magazine, Vol. 17, No. 3, pp. 37-54, 1996.
[15] Frawley W.J., Paitetsky-Shapiro G. and Matheus C.J.,“Knowledge Discovery in Databases: An Overview,”Knowledge Discovery in Databases, California, AAAI/MIT Press, pp. 1-30, 1992.
[16] Grupe F.H. and Owrang M.M., “Database Mining Discovering New Knowledge and Cooperative Advantage,” Information Systems Management, Vol. 12, No. 4, pp. 26-31, 1995.
[17] Han J. and Kamber M., “Data Mining:Concepts and Techniques,”
Morgan Kaufmann Publisher Inc, San Francisco, pp. 229-230, 2000.
[18] Han J., Pei J. and Yin Y., “Mining Frequent Patterns without Candidate Generation,“ Proceedings of the ACM SIGMOD
International Conference on Management of Data, Dallas, USA, pp.
241-250, 2000.
[19] Han J. and Yongjian F., “Mining Multiple-Level Association Rules in Large Database”, IEEE Trans. On Knowledge and Data Engineering, Vol.11,No.5, pp.798-805, 1999.
[20] Hughes A.M., “The Complete Database Marketer Second Generation Strategies and Techniques for Tapping the Power of Your Customer Database”, Revised ed., McGraw-Hill Publishing Company Inc, 1996.
[21] Kotler, P., “Marketing Management : Analysis, Planning, Implementation, and Control, ” 10th ed., New Jersey : David Borkowsky, 2000.
[22] Kleissner C., “Data Mining for the Enterprise,” IEEE Proc. 31st Annual Hawaii International Conference on System Sciences, Vol. 7, pp. 295-304, 1998.
[23] Laudon K.C. and Laudon J.P., Management Information Systems:cOrganization and Technology in the Networked Enterprise ,6th ed, 2000.Berry M. J. A. and G. Linoff, “Data mining techniques : for marketing, sales, and customer support, ” New York:
Wiley, 1997.
[24] MIT, The Technology Review Ten, MIT Technology, Boston, 2001.
[25] Park J.S., Chen M.S. and Yu P.S., “An effective hash based algorithm for mining association rules,” Proceedings of the ACM SIGMOD International Conference on Management of Data, San Jose, USA, pp. 175-186, 1995.
[26] Savasere A., Omiecinski E. and Navathe S., “An Efficient Algorithm for Mining Association Rules,” Proceedings of the 21st Conference of Very Large Databases (VLDB), pp. 432-444, 1995.
[27] Shani D. and Chalasani S., “Exploiting niches using relationship marketing”, The Journal of Consumer Marketing, Vol. 9, No.3, pp.33-42, 1992.
[28] Shaw R. and Stone M., “Database Marketing”, Gower Publishing, 1990.
[29] Tsay Y.J. and Chiang J.Y., “CBAR: an efficient method for mining association rules,” Knowledge-Based Systems, vol. 18, pp. 99-105, 2005.