A STUDY OF UTILIZING DATA MINING ON PRODUCT PORTFOLIO PLANNING

Yıl 2014, Cilt: 5 Sayı: 2, 64 - 77, 30.01.2015

Ali İnce , Mehmet Alan

Öz

In this study, it was intended to provide a strategic contribution to the process of the identification and formation of businesses’ product portfolio by using data mining techniques. An application was made on the data of institutions which exchange funds, using Association Rules, as a data mining technique. It was aimed to investigate whether there is an association rules between different funding instruments while competing firms exchange funds and determined the presence of 52 rules with Tertius algorithm. Benefits of using these rules were presented as a proposal to firms in their products portfolio planning

Anahtar Kelimeler

Product Portfolio Planning, Portfolio Analysis, Data Mining

Ürün Portföy Planlamasında Veri Madenciliğinden Yararlanılması Üzerine Bir Çalışma

Öz

Bu çalışmada, işletmelerin ürün portföylerinin tanımlanması ve oluşturulması aşamasına, veri madenciliği teknikleri kullanılarak, stratejik bir katkı sağlamak istenmiştir. Bir veri madenciliği tekniği olan Birliktelik Kuralları tekniği kullanılarak, fon alışverişi yapan kurumlara ait veriler üzerinde bir uygulama yapılmıştır. Rakip işletmelerin fon alımı yapılırken farklı fon araçları arasında bir birliktelik kuralının olup olmadığı araştırılmaya çalışılmış ve Tertius algoritması ile 52 kuralın varlığı tespit edilmiştir. Ürün portföy planlamalarında, bu kurallardan yararlanabilecekleri, işletmelere bir öneri olarak sunulmuştur.

Anahtar Kelimeler

Ürün Portföy Planlaması, Portföy Analizi, Veri

Kaynakça

• Alan, M. A. (2014), “Association Rules Mining: An Analysis on Student Grades”,
• Technics Technologies Education Management, (2014): 172-178.
• Arora, Jyoti; Bhalla, Nidhi and Rao, Sanjeev (2013), “A Review On Association
• Rule Mining Algorithms”, International Journal of Innovative Research in Computer and Communication Engineering, 1(5): 1246-1251.
• Babu G. and Bhuvaneswari, T. (2012), “A Data Mining Technique To Find
• Optimal Customers For Beneficial Customer Relationship Management”, Journal of Computer Science 8(1): 89-98. Bose, I., Chun, L. A.,Yue, L. V. W., Ines, L. H. W. and Helen, W. O. L. (2009),
• “Business Data Warehouse: The Case of Wal-Mart”, Data Mining Applications for Empowering Knowledge Societies, Ed. Hakikur Rahman, Information Science Reference, pp.189-198
• Child P., Diederichs R., Sanders F. H. and Wisniowski S. (1991), “SMR forum:
• The management of complexity”, Sloan Manage Review, 33(1): 73-80. Choudhary, Alok Kumar, Jenny A. Harding, and Manoj Kumar Tiwari (2009),
• “Data mining in manufacturing: a review based on the kind of knowledge”, Journal of Intelligent Manufacturing, 20(5): 501-521. Cooper, Robert G., Scott J. Edgett, and Elko J. Kleinschmidt (1997), “Portfolio management in new product development”, Research Technology Management, 40(6): 16-28.
• Da Cunha, Catherine, Bruno Agard, and Andrew Kusiak (2006), “Data mining for improvement of product quality”, International Journal of Production Research, 44(18-19): 4027-4041.
• Erol, Eren (2005), Stratejik Yönetim ve İşletme Politikası, Beta Basım Yayım
• Dağıtım AŞ, 7. Baskı, İstanbul. Erpolat, Semra (2012), “Otomobil Yetkili Servislerinde Birliktelik Kurallarının belirlenmesinde Apriori ve FP-Growth Algoritmalarının Karşılaştırılması”,
• Anadolu Üniversitesi Sosyal Bilimler Dergisi, 12(2):137-146. Fayyad, Usama, Gregory Piatetsky-Shapiro, and Padhraic Smyth (1996), “From data mining to knowledge discovery in databases”, AI magazine 17(3): 37-54.
• Giudici, Paolo and Figini, Silvia (2009), Applied Data Mining For Business and Industry, Second Edition, Wiley Publicition, West Sussex.
• Han, Jiawei, and Micheline Kamber (2006), Data Mining, Southeast Asia Edition:
• Concepts and Techniques, Morgan kaufmann, http://www.kap.gov.tr/yatirim- fonlari/faal-yatirim-fonlari.aspx (Retreived 04.07.2014).
• Huffman, Cynthia, and Barbara E. Kahn (1998), “Variety for sale: mass customization or mass confusion?”, Journal of Retailing, 74(4): 491-513.
• İnan, O. (2003), “Veri Madenciliği”, Yüksek Lisans Tezi, Selçuk Üniversitesi, Fen Bilimleri Enstitüsü.
• Jain, Yogendra Kumar, Vinod Kumar Yadav, and Geetika S. Panday (2011), “An efficient association rule hiding algorithm for privacy preserving data mining”
• International Journal on Computer Science and Engineering, 3(7): 2792-2798.
• Jiao, Jianxin Roger, Yiyang Zhang, and Yi Wang (2007), “A heuristic genetic algorithm for product portfolio planning”, Computers & Operations Research, 34(6): 1777-1799.
• Kantardzic, Mehmed (2003), Data Mining: Concepts, Models, Methods, and Algorithms, John Wiley & Sons J. B. Speed Scientific School, University of
• Louisville IEEE Computer Society. Kumar, B. Santhosh and Rukmani, K. V. (2010), “Implementation of Web Usage
• Mining Using APRIORI and FP Growth Algorithms”, International Journal of Advanced Networking and Applications, 1(6): 400-404. Li, Hui, and Shapour Azarm (2002), “An approach for product line design selection under uncertainty and competition”, Journal of Mechanical Design, 124(3): 385-392.
• Maimon, Oded, and Lior Rokach (2008), Data mining with decision trees: theory and applications, World Scientific New Jersey.
• Nahar J, Imam T, Tickle KS , Chen Y. P. (2013), “Association Rule Mining To
• Detect Factors Which Contribute To Heart Disease in Males And Females”, Expert Systems with Applications, 40. Nisbet, Robert, John Elder IV, and Gary Miner (2009), Handbook of Statistical
• Analysis and Data Mining Applications, Elsevier Inc, Burlington. Tanbeer, S. K., Ahmed C. F. and Jeong Byeong-Soo (2009), “An Efficient
• Single-Pass Algorithm For Mining Association Rules From Wireless Sensor Networks”, IETE Technical Review, 26(4): 280-289. Umarani, V. and Punithavalli, M. (2011), “An Empirical Analysis Over The Four
• Different Methods of Progressive Sampling-Based Association Rule Mining” European Journal of Scientific Research 66(4): 620-630. Wu, Tong and Li, Xiangyang (2003), “Data Storage and Management”, Nong Ye
• (ed.), The Handbook of Data Mining, New Jersey: Lawrence Erlbaum Associates Inc., 393-407. Zhang, Yiyang (2006), Product Portfolio Planning With Customer-engineering
• Interaction, Nanyang Tecnological University, PhD Thesis. Ek 1: Tertius Algoritmasıyla Üretilen Kurallar /* 0,265277 0,006369 */ YABANCIBORCLANMAARACLARI = 1 ==> OSBA = 1 or VARLIGADAYALIMENKULKIYMETLER
• GAYRIMENKULSERTIFIKALARI = 1 or OSBA = 1 or REPO = 1= 1 = 1 or YABANCIHISSESENEDI /* 0,247466 0,000000
• GAYRIMENKULSERTIFIKALARI = 1 or OSBA = 1 or REPO = 1 /* 0,246070 0,006369 */ YABANCIBORCLANMAARACLARI = 1 ==> BPP = 1 or OSBA = 1
• /* 0,245872 0,000000 */ YABANCIBORCLANMAARACLARI = 1 ==> OSBA = 1 or REPO = 1 or VARLIGADAYALIMENKULKIYMETLER = 1
• /* 0,236124 0,012739 */ YABANCIBORCLANMAARACLARI = 1 ==> HZBDTHOSTOSB = 1 or VARLIGADAYALIMENKULKIYMETLER = 1 or YABANCIHISSESENEDI = 1 = 1 ==>
• /* 0,236124 0,012739 */ YABANCIBORCLANMAARACLARI = 1 ==> OSBA = 1 or YABANCIHISSESENEDI = 1 or ALTINVEKIYMETLIMADEN = 1 /* 0,236124 0,012739 */
• VARLIGADAYALIMENKULKIYMETLER = 1 ==> GAYRIMENKULSERTIFIKALARI = 1 or OSBA = 1 or ALTINVEKIYMETLIMADEN = 1 /* 0,232804 0,012739 */
• GAYRIMENKULSERTIFIKALARI = 1 or OSBA = 1 or YABANCIHISSESENEDI = 1 /* 0,231332 0,000000 */ YABANCIBORCLANMAARACLARI = 1 ==> BPP = 1 or OSBA = 1 or REPO = 1
• /* 0,231270 0,006369 */ VARLIGADAYALIMENKULKIYMETLER = 1 ==> BPP = 1 or DIBSOSBA = 1 or OSBA = 1
• VARLIGADAYALIMENKULKIYMETLER = 1 or YABANCIHISSESENEDI = 1 /* 0,228377 0,000000 */ BPP = 1 and YABANCIBORCLANMAARACLARI = 1 ==>
• VARLIGADAYALIMENKULKIYMETLER = 1 or YABANCIHISSESENEDI = 1 /* 0,226110 0,012739 */ YABANCIBORCLANMAARACLARI = 1 ==> KBAOSBA = 1 or OSBA = 1 or YABANCIHISSESENEDI = 1
• /* 0,225924 0,082803 */ BPP = 1 ==> VARLIGADAYALIMENKULKIYMETLER = 1 or YABANCIHISSESENEDI = 1 or YABANCIMENKULKIYMETLER = 1
• /* 0,225924 0,082803 */ BPP = 1 ==> GAYRIMENKULSERTIFIKALARI = 1 or YABANCIBORCLANMAARACLARI = 1 or YABANCIMENKULKIYMETLER = 1 BPP
• GAYRIMENKULSERTIFIKALARI = 1 or REPO = 1 /* 0,222734 0,012739 */ VARLIGADAYALIMENKULKIYMETLER = 1 ==> ALTIN = 1 or GAYRIMENKULSERTIFIKALARI = 1 or OSBA = 1
• /* 0,222734 0,012739 */ YABANCIBORCLANMAARACLARI = 1 ==> ALTIN = 1 or OSBA = 1 or YABANCIHISSESENEDI = 1
• /* 0,220138 0,050955 */ BPP = 1 ==> GAYRIMENKULSERTIFIKALARI = 1 or REPO = 1 or YABANCIMENKULKIYMETLER = 1
• GAYRIMENKULSERTIFIKALARI = 1 or REPO = 1 /* 0,219340 0,012739 */ YABANCIBORCLANMAARACLARI = 1 ==> BPP = 1 or HZBDTHOSTOSB
• = 1 or ALTINVEKIYMETLIMADEN = 1 /* 0,218779 0,076433 */ BPP = 1 ==> DIBSOSBA = 1 or VARLIGADAYALIMENKULKIYMETLER
• = 1 or YABANCIHISSESENEDI = 1 /* 0,217635 0,012739 */ VARLIGADAYALIMENKULKIYMETLER = 1 ==> ALTIN = 1 or DIBSOSBA = 1 or GAYRIMENKULSERTIFIKALARI = 1
• /* 0,214346 0,006369 */ YABANCIBORCLANMAARACLARI = 1 ==> REPO = 1 or VARLIGADAYALIMENKULKIYMETLER = 1
• /* 0,214209 0,012739 */ YABANCIBORCLANMAARACLARI = 1 ==> BPP = 1 or HZBDTHOSTOSB
• = 1 or VARLIGADAYALIMENKULKIYMETLER = 1 VARLIGADAYALIMENKULKIYMETLER = 1 or YABANCIHISSESENEDI = 1 */ /* 0,210892 0,006369 */ YABANCIBORCLANMAARACLARI = 1 ==> OSBA = 1 or REPO = 1
• /* 0,209029 0,012739 */ VARLIGADAYALIMENKULKIYMETLER = 1 ==> BPP = 1 or OSBA = 1
• /* 0,209029 0,012739 */ YABANCIBORCLANMAARACLARI = 1 ==> BPP = 1 or HZBDTHOSTOSB = 1 or KBAOSBA = 1
• /* 0,209029 0,012739 */ VARLIGADAYALIMENKULKIYMETLER = 1 ==> BPP = 1 or DIBSOSBA
• = 1 or ALTINVEKIYMETLIMADEN = 1 GAYRIMENKULSERTIFIKALARI = 1 or YABANCIBORCLANMAARACLARI = 1 BPP /* 0,206296 0,089172 */ BPP = 1 ==> YABANCIBORCLANMAARACLARI = 1 or YABANCIHISSESENEDI = 1 or YABANCIMENKULKIYMETLER = 1
• /* 0,205548 0,012739 */ YABANCIBORCLANMAARACLARI = 1 ==> ALTIN = 1 or BPP = 1 or HZBDTHOSTOSB = 1
• /* 0,205548 0,012739 */ VARLIGADAYALIMENKULKIYMETLER = 1 ==> BPP = 1 or DIBSOSBA
• = 1 or YABANCIBORCLANMAARACLARI = 1 /* 0,204165 0,019108 */ YABANCIBORCLANMAARACLARI = 1 ==> OSBA = 1 or YABANCIHISSESENEDI = 1
• /* 0,202707 0,082803 */ BPP = 1 ==> ALTIN = 1 or FONKATILIMBELGELERI = 1 or YABANCIBORCLANMAARACLARI = 1
• /* 0,202141 0,006369 */ YABANCIBORCLANMAARACLARI = 1 ==> BPP = 1 or REPO = 1
• /* 0,200929 0,000000 */ REPO = 1 and VARLIGADAYALIMENKULKIYMETLER = 1 ==> ALTIN = 1 or GAYRIMENKULSERTIFIKALARI = 1
• YABANCIBORCLANMAARACLARI = 1 ==> 0,229768 0,082803 */ BPP = 1 ==> FONKATILIMBELGELERI = 1 or /* 0,224063 */ = 1 ==> FONKATILIMBELGELERI = 1 or /* 0,006369 */
• YABANCIBORCLANMAARACLARI = 1 ==> /* 0,211066 0,019108
• YABANCIBORCLANMAARACLARI = 1 ==> /* 0,206296 0,089172 */ = 1 ==> FONKATILIMBELGELERI = 1 or /* 0,200929 0,000000 */ BPP = 1 and VARLIGADAYALIMENKULKIYMETLER = 1 ==> ALTIN = 1 or GAYRIMENKULSERTIFIKALARI = 1
• /* 0,200683 0,019108 */ VARLIGADAYALIMENKULKIYMETLER = 1 ==> OSBA = 1 or YABANCIBORCLANMAARACLARI = 1 or ALTINVEKIYMETLIMADEN = 1
• /* 0,198809 0,082803 */ BPP = 1 ==> ALTIN = 1 or YABANCIBORCLANMAARACLARI = 1 or YABANCIMENKULKIYMETLER = 1
• /* 0,198541 0,057325 */ BPP = 1 ==> FONKATILIMBELGELERI = 1 or REPO = 1 or YABANCIHISSESENEDI = 1
• VARLIGADAYALIMENKULKIYMETLER = 1 or YABANCIBORCLANMAARACLARI = 1 /* 0,198513 0,012739 */ VARLIGADAYALIMENKULKIYMETLER = 1 ==> BPP = 1 or DIBSOSBA = 1 or KBAOSBA = 1
• /* 0,197804 0,012739 */ REPO = 1 and YABANCIBORCLANMAARACLARI = 1 ==>
• VARLIGADAYALIMENKULKIYMETLER = 1 or YABANCIHISSESENEDI = 1 GAYRIMENKULSERTIFIKALARI = 1 or OSBA = 1 or YABANCIMENKULKIYMETLER = 1 /* 0,197180 0,019108 */ YABANCIBORCLANMAARACLARI = 1 ==> ALTIN = 1 or GAYRIMENKULSERTIFIKALARI = 1 or YABANCIHISSESENEDI = 1
• /* 0,197180 0,019108 */ VARLIGADAYALIMENKULKIYMETLER = 1 ==> DIBSOSBA = 1 or GAYRIMENKULSERTIFIKALARI = 1 or ALTINVEKIYMETLIMADEN = 1
• /* 0,196739 0,012739 */ VARLIGADAYALIMENKULKIYMETLER = 1 ==> ALTIN = 1 or BPP = 1 or DIBSOSBA = 1
• /* 0,196295 0,050955 */ BPP = 1 ==> ALTIN = 1 or FONKATILIMBELGELERI = 1 or REPO = 1
• GAYRIMENKULSERTIFIKALARI = 1 or OSBA = 1 or YABANCIBORCLANMAARACLARI = 1 /* 0,195420 0,019108 */ VARLIGADAYALIMENKULKIYMETLER = 1 ==> OSBA = 1 or YABANCIBORCLANMAARACLARI = 1 or YABANCIMENKULKIYMETLER = 1 = 1 or /* 0,197180 0,019108 */
• VARLIGADAYALIMENKULKIYMETLER = 1 ==> /* 0,195420 0,019108 */
• Stratejik yönetim alanında çalışmalar yapan Dr. Ali Rıza İnce, halen Cumhuriyet Üniversitesinde Yönetim Bilişim sistemleri bölümünde öğretim üyesi olarak görev yapmaktadır.