Development of Business Intelligence System and Prediction with Data Mining of Lam Sam Kaeo Town Municipality, Thailand

Main Article Content

Watchawee Wongart
Somchai Lekcharoen

Abstract

The purpose of this research was to develop a business intelligence system and make predictions with data mining of Lam Sam Kaeo Town Municipality. The process of development used Microsoft Visual Studio (SSDT) with SQL Server Integration Services (SSIS) to create a data warehouse, then using SQL Server Analysis Services (SSAS) to create cube and using SQL Server Reporting Services (SSRS) to create reports then publish to web browsers for local administration officers to make decisions. The sample data used in this project covered local government taxpayers living in Lam Sam Kaeo Town Municipality in 2020: altogether about 200 taxpayers. The analysis was based on the new land and building tax act 2019. RapidMiner Studio was used to create the analysis model to determine the factors that cause tax delays in Lam Sam Kaeo Town Municipality. A comparison of three classification algorithms showed similar accuracy: J48 Decision Tree has accuracy = 96%, Naïve Bayes has accuracy = 92%, Neural Network has accuracy = 96.50%, ANOVA test found no significant difference at 0.05 level is not different so the researcher chooses the Decision Tree method for this research. The results are that the most influential factors causing overdue tax payments are ‘forget to pay’, ‘lack of advertising’, and ‘lack of e-payment method.

Downloads

Download data is not yet available.

Article Details

How to Cite
Wongart, W., & Lekcharoen, . S. (2022). Development of Business Intelligence System and Prediction with Data Mining of Lam Sam Kaeo Town Municipality, Thailand. INTERNATIONAL SCIENTIFIC JOURNAL OF ENGINEERING AND TECHNOLOGY (ISJET), 6(1), 28–40. Retrieved from https://ph02.tci-thaijo.org/index.php/isjet/article/view/244343
Section
Research Article

References

Department of Local Administration, Ministry of Interior. (2021, June 10). Land and Buildings Tax Act 2019. [Online]. Available: http://www.dla.go.th/work/mixlaw2.pdf

Department of Local Administration, Ministry of Interior. (2021, Jan. 10). Royal Decree on reduces land and building taxes by 90%. (2nd ed.) [Online]. Available: http://www.dla. go.th/upload/document/

type2/2021/2/24981_1_1613034073130.pdf

Department of Finance, Lam Sam Kaeo. (2021, May 10). Data of Land and Building Taxpayers. [Online]. Available lamsamkaeo.go.th/public/list/datal/index/Manu/1149

Craig Stedman, Ed Burns. (2020, Sep.).Business Intelligence(BI). [Online]. Available: https:searchbusiness.analyticstechtarget.com/definition/business-intelligence-BI

O. Medovoi. (2019, Apr. 20). Complete Guide to Business Intelligence and Analytics: Strategy, Steps, Processes, and Tools. [Online]. Available: https://www.altexsoft.com/blog/business/complete-guide-to-business-intelligence-andanalytics-strategy-steps-processes-and-tools/

P. Tiangsombun, (2018, Sep.). Business Intelligence Systems To Support Executive Forecasting And Decisions Making Case Study: Healthcare. Veridian E-Journal, Science and Technology Silpakorn University. [Online]. 5(4), pp. 16-30. Available: https://ph01.tci-thaijo.org/index.php/VESTSU/

article/view/148906

S. Leelataweewud. (2020, May.) The Studying of Cloud Business Intelligence System Architecture for Asean Economic Community. Suthiparitthat Journal DPU. [Online]. 30(93), pp. 177-192. Available: https://so05.tci-thaijo.org/index.php/DPUSuthiparithatJournal/article/view/242764

E. Sangiamkul and T. Panrungsri (2019, Jun.). Development of Decision Support System in Impact and Severity from Flood in Phuket. Information Technology Journal. [Online]. 15(1), pp. 60-70. Available: https://ph01.tci-thaijo.org/index.php/IT_Journal/article/view/199901

P. Pipatjessadakul and O. Pinngern (2019, Dec.). Development of Business Intelligence System to Support Electrical Distribution. Journal of project in Computer Science and Information Technology. [Online]. 5(2), pp. 49-56. Available: https://ph02.tci-thaijo.org/index.php/projectjournal/article/view/

E. Naowanich and N. Jeerungsuwan (2017 Jun.). The Development of Business Intelligence System for Supporting the Administrations’ Decision Making to Access Occupation Internationally for Students of Rajamangala University of Technology. Academic Journal Bangkokthonburi University. [Online]. 6(1), pp. 184-198. Available: https://so01.tci-thaijo.org/index.php/bkkthon/article/view/210782

S. Hai-Jew. (2021, Jun. 10). Using Decision Trees to Analyze Online Learning Data. [Online]. Available: https://newprairiepress.org/cgi/viewcontent.cgi?article=1005&context=isitl

S. Ray. (2021, Jun. 10). 6 Easy Steps to Learn Naive Bayes Algorithm with Codes in Python and R. India. [Online]. Available: https://www.analyticsvidhya.com/blog/2017/09/naive-bayes-explained/

A. Dertat. (2021, Jun. 10). Applied Deep Learning - Part1: Artificial Neural Networks. [Online]. Available: https://towardsdatascience.com/applied-deep-learning-part-1-artificial-neural-networks-d7834f67a4f6

H. Deng, G. Runger, and E. Tuv. “Artificial Neural Networks and Machine Learning,” Presented at ICANN 2011. Conf. Artificial Neural Networks, Jun. 14-17, 2011.

B. Hembree. (2006, Feb.). One way ANOVA (Analysis of Variance). [Online]. Available: https://www.itl.nist.gov/div898/handbook/ppc/section2/ppc231.htm

P. Siriattakul. (2012, Sep.). One-Way ANOVA: SocialScience Research. Journal of Interdisciplinary Research: Graduate Studies, vol. 1, no. 1, pp. 1-11, Sep. 2012.

N. Hongboonmee and P. Trepanichkul (2019, Jun.). Comparison of Data Classification Efficiency to Analyze Risk Factors that Affect the Occurrence of Hyperthyroidusing Data Mining Techniques. Journal of Information Science and Technology (JIST). [Online] 9(1), pp. 41-51. Available: https://ph02.tcithaijo.

org/index.php/JIST/articleview/17918

R. Caruana and A. Niculescu-Mizil. (2006, Jun.). An Empirical Comparison of Supervised Learning Algorithms. Present at Proceedings of the 23rd International Conference on Machine Learning, Pittsburgh, PA. [Online]. Available: https://www.researchgate.net/publication/215990477_

An_Empirical_Comparison_of_Supervised_Learning_Algorithms

A. Chutipascharoen (2018, Nov.). A Comparison of the Efficiency of Algorithms and Feature Selection Methods for Predicting the Success of Personal Overseas Money Transfer.

KKU Research Journal of Humanities and Social Sciences. [Online]. 6(3), pp. 105-113. Available: https://so04.tci-thaijo.org/index.php/gskkuhs/article/view/156370

N. Hongboonmee and P. Trepanichkul. (2019, Jun.). Comparison of Data Classification Efficiency to Analyze Risk Factors that Affect the Occurrence of Hyperthyroid using Data Mining Techniques. Journal of Information Science and Technology. [Online]. 9(1). pp. 41-51. Available:

https://ph02.tci-thaijo.org/

R. Caruana and A. Niculescu-Mizil. (2006, Jun.). An Empirical Comparison of Supervised Learning Algorithms. Present at Proceedings of the 23rd International Conference on Machine Learning, Pittsburgh, PA. [Online]. Available: https://www.researchgate.net/publication/215990477_

An_Empirical_Comparison_of_Supervised_Learning_Algorithms