International Journal of Scientific & Technology Research

Home About Us Scope Editorial Board Blog/Latest News Contact Us
10th percentile
Powered by  Scopus
Scopus coverage:
Nov 2018 to May 2020


IJSTR >> Volume 9 - Issue 11, November 2020 Edition

International Journal of Scientific & Technology Research  
International Journal of Scientific & Technology Research

Website: http://www.ijstr.org

ISSN 2277-8616

Designing Data Warehouse To Data Visualization For Identify Document Patterns At Customs And Excise Office

[Full Text]



Nadya Hastono Putri, Syaifudin, Teddy Siswanto



Services, Data Warehouse, Visualization, Information, Case-Based Reasoning (CBR)



The increase in import volume at the Pasar Baru Post Customs Office caused relatively long service processes. This is due to several processes that must be passed, including physical checking of goods, determining criteria for value of goods, lines, and status by the office. To streamline services, information is needed regarding the process that must be passed.In this study, the design and implementation of a data warehouse were conducted to visualize information in the form of the most frequently used path types and statuses. Users can easily understand the service process that causes buildup. The Case-Based Reasoning (CBR) method is used to determine the similarity of the new case to the old case based on weight



[1] J. Akuntansi, M. Bisnis, D. Kartika, T. A. Batam, A. Tipe, and M. Kuning, “Afrianto,” Accounting, Econ. and Manaj. Business, vol. 6, no. 1, pp. 107–118, 2018.
[2] G. Ngurah and M. Nata, “Detection of Outlier Transactions Using Olap Visualization in Private Higher Education Data Warehouses,” J. Appl. Intell. Syst. UDINUS, vol. 1, no. 2, pp. 77–89, 2016.
[3] A. Armadyah, “Designing and Making Data Warehouses in Yogyakarta STAKIK AKAKOM Library,” Tesis. Perpust. MTI, pp. 39–52, 2009.
[4] R. Darman, “Visualization Analysis and Mapping of Rice Crop Data in Indonesia Using Microsoft Power BI," J. Ilm. Engineering and Management,” J. Ilm. Rekayasa dan Manaj. Sist. Inf., vol. 4, no. 2, pp. 156–162, 2018.
[5] J. T. Geodesi, “Evaluation of Data Visualization System Development (Case Study: Data Management at the Indonesian Ministry of Home Affairs) MUHAMMAD FIKRY ABYADL, SUMARNO, INDRIANAWATI,” vol. 2016, no. 2, pp. 80–89, 2016.
[6] F. Kalna, A. Erraissi, M. Banane, and A. Belangour, “A scalable business intelligence decision-making system in the era of big data,” Int. J. Innov. Technol. Explor. Eng., vol. 8, no. 12, pp. 2034–2042, 2019.
[7] Firmansyah “The Most Commonly Used Database Type.” [Online]. Available:https://www.nesabamedia.com/pengertian-database-dan-fungsinya [20 Jul. 2020].
[8] Wijaya, R., & Pudjoatmodjo, B. (2016). Application of Extraction-Transformation-Loading (ETL) in Data Warehouses (Case Study: Ministry of Agriculture). National Journal of Informatics Engineering Education (JANAPATI), 5(2), 61.
[9] A. Aryati and D. Anwar, “ournal of Industrial and Logistics Management DESIGN OF BUSINESS INTELIGENCY SYSTEM IN JAMU PRODUCT SUPPLY CHAIN BASED ON THE PENTAHO BUSINESS INTELLIGENCE,” J. Manaj.Ind. dan Logistik, vol. 1, no. 2, 2018.
[10] A. Sreekant, P. Senthilnathan, G. Gopichand, M. Rajapandy, and N. Kannan, “Necessity of machine learning and data visualization principles in marketing investment management,” Int. J. Innov. Technol. Explor. Eng., vol. 8, no. 6 Special Issue 4, pp. 527–530, 2019.
[11] Eaton, M. 2017. Seeing library data: A prototype data visualization application for librarians. Journal of Web Librarianship 11(1): 6978. DOI:10.1080/19322909.2016.1239236 [30 Jun. 2020].
[12] Naradhipa, A. R., Syaifudin, & Sari, S. (2020). Knowledge management system for broiler and laying cultivation. International Journal of Scientific and Technology Research, 9(3), 1373–1378.
[13] D. P. Utomo and S. D. Nasution, “Expert System to Detect Damage Toner Using the Case-Based Reasoning Method,” J. Ris. Komput., vol. 3, no. 5, pp. 3–6, 2016.
[[14] A. Aryati and D. Anwar, “ournal of Industrial and Logistics Management BUSINESS INTELLECTENS DESIGN SYSTEM IN SUPPLY CHAINS PENTAHO-BASED JAMU PRODUCTS BUSINESS INTELLIGENCE,” J. Manaj.Ind. dan Logistik, vol. 1, no. 2, 2018.
[15] I. T. Del, P. R. Togatorop, J. Sisingamangaraja, D. Sitoluama, and K. Laguboti, “Dimension Design Model in Data Warehouse for New Student Admissions in,” vol. 01, no. 01, 2018.
[16] S. Mathur, V. Bali, S. L. Gupta, and P. Pahwa, “Data warehousetesting and security: A conspectus,” Int. J. Innov. Technol. Explor. Eng., vol. 8, no. 9 Special Issue, pp. 843–850, 2019.
[17] R. J. Salaki, J. Waworuntu, and I. R. H. T. Tangkawarow, “Extract transformation loading from OLTP to OLAP data using pentaho data integration,” IOP Conf. Ser. Mater. Sci. Eng., vol. 128, no. 1, 2016.
[18] H. M. Jumasa, S. Fauziati, and A. E. Permanasari, “Case-Based Application in Determining Equity Based on Oil Palm Land Conformity,” Citee 2017, pp. 306–313, 2017.
[19] T. Kautz and J. J. Heckman, The Effect of Import Duties and Taxes in the Framework of Imports (Bm and Pdri) Against Total Revenue” NBER Work. Pap. Ser., vol. 10, no. 1, pp. 1–8, 2013.