International Journal of Information Engineering and Electronic Business (IJIEEB)
IJIEEB Vol. 10, No. 2, 8 Mar. 2018
Cover page and Table of Contents: PDF (size: 725KB)
Decision Support System to Determine Promotional Methods and Targets with K-Means Clustering
Full Text (PDF, 725KB), PP.9-16
Views: 0 Downloads: 0
Index Terms
Promotion, enrollment, data mining, k-means clustering, data warehouse, semantic
Abstract
Promotion becomes one of the important aspects of institutions of college. The number of competitors demanding the marketing must be fast and accurate in formulating strategies and decision making. Data warehouse and data mining become one of the means to build a decision support system that can provide knowledge and wisdom quickly to be taken into consideration in promotion strategy planning. Development of this system then does the process of testing with the number of data 6171 rows of student enrollment taken directly from a transactional database. The data is done ETL process and clustering with the k-means clustering algorithm, then the data in each cluster is done grouping and summarization to get weighting. After that just done ranking to produce wisdom, one of them determine the list of schools that will be the target roadshow. The analysis also produces several patterns of student enrollment, namely the registrant pattern from the wave of registration and favorite or non-favorite school categories. In addition, the results of system design in this study can be developed easily if requires added external data. Such as data of SMK/SMK school graduates in the area or data of students enrolling in other universities. This is one of the superiority of semantic-based data warehouses.
Cite This Paper
Yazid, Ema Utami, "Decision Support System to Determine Promotional Methods and Targets with K-Means Clustering", International Journal of Information Engineering and Electronic Business(IJIEEB), Vol.10, No.2, pp. 9-16, 2018. DOI:10.5815/ijieeb.2018.02.02
Reference
[1]Ambara M. P., Sudarma M., and Kumara I. N. S., “Semantic Data Warehouse Design System With Ontology And Rule Based Methods To Process Academic Data XYZ University in Bali”, Elektro Technology, Vol. 15, No 1, 2016.
[2]Han J., Kamber M., Pei J., Data mining concepts and techniques, USA: Third Edition, Morgan Kaufmann Publisher, 225 Wyman Street, Waltham, MA 02451; 2012.
[3]Kardina A., Diana N. E., “Visualitation of Ontology-Based Data Warehouse for Malaria Spread Incidences Using Protege”, Journal of Information System, Vol. 12, 2016.
[4]Khouri S., Abdellaoui S., and Nader F., “Avoiding Ontology Confusion in ETL Processes”, Springer, pp. 119-126, 2015.
[5]Ta’a A. and Abdullah M. S., “Goal-Ontology Approach for Modelling and Designing ETL Processes”, Elsevier, 942-948, 2011.
[6]Nugraheni E., Akbar S., and Saptawati G. A. P., “Framework of Semantic Data Warehouse for Heterogeneous and Incomplete Data”, IEEE, 2016.
[7]Pooja Thakar, Anil Mehta, Manisha, "A Unified Model of Clustering and Classification to Improve Students’ Employability Prediction", International Journal of Intelligent Systems and Applications(IJISA), Vol.9, No.9, pp.10-18, 2017. DOI: 10.5815/ijisa.2017.09.02.
[8]Naufal A., Kurniawati A., and Hasibuan M. A., “Decision Support System of SMB Telkom University Roadshow Location Prioritization With Weighted Sum Model Method”, IEEE, 2016.
[9]Kotu Vijay and Deshpande Bala. Predictive Analytics and Data Mining: Concepts and Practice with RapidMiner. Morgan Kaufmann Publisher, 225 Wyman Street, Waltham, MA 02451, USA, 2015.
[10]Niinimaki M. and Niemi T., “An ETL Process for OLAP Using RDF/OWL Ontologies”, Journal on Data Semantics XIII, LNCS 5530, pp. 97-119, 2009.
[11]Lim S. C. J. and Liu Y., “Ontology in Design Engineering: Status and Challenges”, International Conference on Engineering Design (ICED15), 2015.
[12]Bahareh Bahadorani, Ahmad Zaeri,"Comparison of Time Concept Modeling for Querying Temporal Information in OWL and RDF", International Journal of Information Technology and Computer Science(IJITCS), Vol.9, No.7, pp.26-34, 2017. DOI: 10.5815/ijitcs.2017.07.03.
[13]Ye Nong, Data mining: Theories, Algorithms and Examples,Taylor & Francis Group, LLC, 2012.
[14]Maimon O. and Rokach L., Data mining and Knowledge Discovery Handbook, USA: Second Edition, Springer Science+Business Media, LLC, 233, Spring Street, New York, NY 10013, USA, 2010.
[15]Kotu V. and Deshpande B., Predictive Analytics and Data Mining: Concepts and Practice with RapidMiner, USA: Morgan Kaufman is and imprint of Elsevier 225 Wyman Street, Waltham, MA 02451, USA, 2015.
[16]Anggarwal C. C., Data mining, Springer International Publishing Switzerland, 2015.
[17]Preeti Jain, Dr. Bala Buksh, "Accelerated K-means Clustering Algorithm", International Journal of Information Technology and Computer Science(IJITCS), pp.39-46, 2016. DOI: 10.5815/ijitcs.2016.10.05
[18]Ajay Kumar, Shishir Kumar, "Density Based Initialization Method for K-Means Clustering Algorithm", International Journal of Intelligent Systems and Applications(IJISA), Vol.9, No.10, pp.40-48, 2017. DOI: 10.5815/ijisa.2017.10.05
[19]Averweg, U. R. F., Decision-making support systems: Theory & practice, Durban, South Africa, 2012.
[20]Newell, A. and Simon, H.A., Human Problem Solving. Englewood Cliffs, NJ: Prentice-Hall, 1972.
[21]Jao, C. S., Decision Support Systems, Publisher Intech India, 2010.