Pub Date : 2022-12-23DOI: 10.15408/jti.v15i2.27324
Riska Zulfiqoh, M. B. Ulum
This study discusses problems on the website of the NPPS companywhich will also be used by its branch company, namely NPPSLK.While the website currently only supports one company, it isnecessary to develop the website to become multicompany. If thewebsite is made multicompany, then the applications in it areautomatically adjusted. One of the applications on the website is anapplication with systematic approval, namely the Dynamic ApprovalMatrix (DAM). DAM was developed to be able to supportmulticompany, support flow management features, status, andapproval actions for each company. So, a multi-company configuration is carried out on one system, and using the waterfall method with steps. Advance Dynamic ApprovalMatrix (ADAM) was created as multi-enterprise support DAMdevelopment. So, it can be used by multi-company. ADAM is madeusing waterfall method using Odoo with Python, XML, andPostgreSQL. The app contains forms to manage related apps, approvalflow settings, multi-company, status settings, and Call-to-Actionbuttons to facilitate document approval. The ADAM application has been tested on the TDCR application using black box indicator with the conclusion that website results aremore effective and efficient because it can be used by multicompany,and administrators can freely adjust according to company needs.
{"title":"Dynamic Approval Matrix Application Design for Technical Department Document Change Request Application","authors":"Riska Zulfiqoh, M. B. Ulum","doi":"10.15408/jti.v15i2.27324","DOIUrl":"https://doi.org/10.15408/jti.v15i2.27324","url":null,"abstract":"This study discusses problems on the website of the NPPS companywhich will also be used by its branch company, namely NPPSLK.While the website currently only supports one company, it isnecessary to develop the website to become multicompany. If thewebsite is made multicompany, then the applications in it areautomatically adjusted. One of the applications on the website is anapplication with systematic approval, namely the Dynamic ApprovalMatrix (DAM). DAM was developed to be able to supportmulticompany, support flow management features, status, andapproval actions for each company. So, a multi-company configuration is carried out on one system, and using the waterfall method with steps. Advance Dynamic ApprovalMatrix (ADAM) was created as multi-enterprise support DAMdevelopment. So, it can be used by multi-company. ADAM is madeusing waterfall method using Odoo with Python, XML, andPostgreSQL. The app contains forms to manage related apps, approvalflow settings, multi-company, status settings, and Call-to-Actionbuttons to facilitate document approval. The ADAM application has been tested on the TDCR application using black box indicator with the conclusion that website results aremore effective and efficient because it can be used by multicompany,and administrators can freely adjust according to company needs.","PeriodicalId":52586,"journal":{"name":"Jurnal Sarjana Teknik Informatika","volume":" 13","pages":""},"PeriodicalIF":0.0,"publicationDate":"2022-12-23","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"72497562","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2022-12-23DOI: 10.15408/jti.v15i2.27006
Gabrielle Jovanie Sitepu, E. S. Nugraha
Providing credit has become a main source of profit for financial and non-financial institutions. However, this transaction might lead into credit risk. This risk occurred if debtors unable to complete their obligations that will led loss for creditors. It is necessity for company to create assessment in distinguishing eligible or non-eligible prospective customer. Artificial Neural Network (ANN) is introduced in solving this typical classification case. Furthermore, one of learning algorithm in ANN namely Backpropagation is able to minimizing error of output in order to receive accurate result. This research aims to form models that capable in classifying the loan status of applicants by utilizing historical data. The method developed in this research is Backpropagation with activation function is a sigmoid function. In addition, this research formed two data model for analyzed; with first data model is every variable given in dataset and for the second data model is the variables that influenced the loan acceptance. Backpropagation shows high performance with more or less data variables. The results of this research show that the both data model has highest accuracy of prediction is 94.37% while the lowest accuracy prediction is 80.28%.
{"title":"A Backpropagation Artificial Neural Network Approach for Loan Status Prediction","authors":"Gabrielle Jovanie Sitepu, E. S. Nugraha","doi":"10.15408/jti.v15i2.27006","DOIUrl":"https://doi.org/10.15408/jti.v15i2.27006","url":null,"abstract":"Providing credit has become a main source of profit for financial and non-financial institutions. However, this transaction might lead into credit risk. This risk occurred if debtors unable to complete their obligations that will led loss for creditors. It is necessity for company to create assessment in distinguishing eligible or non-eligible prospective customer. Artificial Neural Network (ANN) is introduced in solving this typical classification case. Furthermore, one of learning algorithm in ANN namely Backpropagation is able to minimizing error of output in order to receive accurate result. This research aims to form models that capable in classifying the loan status of applicants by utilizing historical data. The method developed in this research is Backpropagation with activation function is a sigmoid function. In addition, this research formed two data model for analyzed; with first data model is every variable given in dataset and for the second data model is the variables that influenced the loan acceptance. Backpropagation shows high performance with more or less data variables. The results of this research show that the both data model has highest accuracy of prediction is 94.37% while the lowest accuracy prediction is 80.28%.","PeriodicalId":52586,"journal":{"name":"Jurnal Sarjana Teknik Informatika","volume":"37 1","pages":""},"PeriodicalIF":0.0,"publicationDate":"2022-12-23","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"79273896","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2022-12-23DOI: 10.15408/jti.v15i2.27741
D. Khairani, Muhammad Ammaridho Romdhan Siregar, S. Masruroh, Miftakhul Nuuril Azizah
The multiple bandwidths that internet service providers offer make it difficult for people to choose, especially for regular people unfamiliar with the internet; therefore, most people choose because the price is reasonable. Numerous users also lament the difficulty and slow internet usage. The issue is then concentrated on internet service providers, who are thought to be poor at offering services. The quantity of bandwidth consumed, which does not correspond to the user’s needs, is one factor contributing to slow internet. As a result, the appropriate bandwidth must be chosen based on the requirements of each user. Compared to other algorithms, the C4.5 decision tree method can deliver the best and correct decision, according to the current literature. As a result, this project will develop a web application based on the C4.5 decision tree algorithm that can assist in determining bandwidth and internet following community needs. Using this C4.5 Decision Tree, decisions are based on patterns identified in previously collected data. Predictions about various forms of internet use in the neighborhood may subsequently be produced from these patterns. Based on the calculation, the accuracy obtained is 0.54, or a percentage of 54%. The black box testing indicated that the bandwidth determination application was functioning correctly
{"title":"Selection of Home Wifi Internet: Machine Learning Implementation With Decision Tree C4.5 Algorithm Method","authors":"D. Khairani, Muhammad Ammaridho Romdhan Siregar, S. Masruroh, Miftakhul Nuuril Azizah","doi":"10.15408/jti.v15i2.27741","DOIUrl":"https://doi.org/10.15408/jti.v15i2.27741","url":null,"abstract":"The multiple bandwidths that internet service providers offer make it difficult for people to choose, especially for regular people unfamiliar with the internet; therefore, most people choose because the price is reasonable. Numerous users also lament the difficulty and slow internet usage. The issue is then concentrated on internet service providers, who are thought to be poor at offering services. The quantity of bandwidth consumed, which does not correspond to the user’s needs, is one factor contributing to slow internet. As a result, the appropriate bandwidth must be chosen based on the requirements of each user. Compared to other algorithms, the C4.5 decision tree method can deliver the best and correct decision, according to the current literature. As a result, this project will develop a web application based on the C4.5 decision tree algorithm that can assist in determining bandwidth and internet following community needs. Using this C4.5 Decision Tree, decisions are based on patterns identified in previously collected data. Predictions about various forms of internet use in the neighborhood may subsequently be produced from these patterns. Based on the calculation, the accuracy obtained is 0.54, or a percentage of 54%. The black box testing indicated that the bandwidth determination application was functioning correctly","PeriodicalId":52586,"journal":{"name":"Jurnal Sarjana Teknik Informatika","volume":"47 1","pages":""},"PeriodicalIF":0.0,"publicationDate":"2022-12-23","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"73576342","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2022-12-23DOI: 10.15408/jti.v15i2.26762
M. Untoro, Eko Dwi Nugroho, Mugi Praseptiawan, Aidil Afriansyah, Muhammad Nadhif Athalla
Controlling hydroponic plants, which is currently being carried outmanually, can be said to be less effective because it still involves thehard work of farmers to continuously monitor the condition of thehydroponic plants. Therefore, the general objective of this research isto develop a model that can be used as a recommendation system foractions that farmers need to take based on hydroponic crop conditions.The model formed with this machine learning method will then beused in the Hydromon application which allows farmers to manageand monitor the condition of hydroponic plants and take action basedon the recommendations given. This model was developed using adeep neural network algorithm consisting of five layers with the helpof the TensorFlow framework. The results show that the model isaccurate with an accuracy value of 96.47% on the test data to classifyplant conditions so that it can be used in the Hydromon application.
{"title":"Action Recommendation Model Development for Hydromon Application Using Deep Neural Network (DNN) Method","authors":"M. Untoro, Eko Dwi Nugroho, Mugi Praseptiawan, Aidil Afriansyah, Muhammad Nadhif Athalla","doi":"10.15408/jti.v15i2.26762","DOIUrl":"https://doi.org/10.15408/jti.v15i2.26762","url":null,"abstract":"Controlling hydroponic plants, which is currently being carried outmanually, can be said to be less effective because it still involves thehard work of farmers to continuously monitor the condition of thehydroponic plants. Therefore, the general objective of this research isto develop a model that can be used as a recommendation system foractions that farmers need to take based on hydroponic crop conditions.The model formed with this machine learning method will then beused in the Hydromon application which allows farmers to manageand monitor the condition of hydroponic plants and take action basedon the recommendations given. This model was developed using adeep neural network algorithm consisting of five layers with the helpof the TensorFlow framework. The results show that the model isaccurate with an accuracy value of 96.47% on the test data to classifyplant conditions so that it can be used in the Hydromon application.","PeriodicalId":52586,"journal":{"name":"Jurnal Sarjana Teknik Informatika","volume":"96 1","pages":""},"PeriodicalIF":0.0,"publicationDate":"2022-12-23","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"75706991","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2022-12-23DOI: 10.15408/jti.v15i2.25842
Warsino Warsino
Sarcasm is a statement that conveys an opposing viewpoint viapositive or exaggeratedly positive phrases. Due to this intentionalambiguity, sarcasm identification has become one of the importantfactors in sentiment analysis that make many researchers in naturallanguage processing intensively study sarcasm detection. Thisresearch is using multiple channels embedding the attentionbidirectional long-short memory (MCEA-BLSTM) model thatexplored sarcasm detection in news headlines and has differentapproach from previous research-developed models that lexical,semantic, and pragmatic properties. This research found that multiplechannels embedding attention mechanism improve the performance ofBLSTM, making it superior to other models. The proposed methodachieves 96.64% accuracy with an f-measure of 97%
{"title":"Hacking as a Cyber Crime, Reviewed from the Perspective of Quran Surah An-Nur Verse 27","authors":"Warsino Warsino","doi":"10.15408/jti.v15i2.25842","DOIUrl":"https://doi.org/10.15408/jti.v15i2.25842","url":null,"abstract":"Sarcasm is a statement that conveys an opposing viewpoint viapositive or exaggeratedly positive phrases. Due to this intentionalambiguity, sarcasm identification has become one of the importantfactors in sentiment analysis that make many researchers in naturallanguage processing intensively study sarcasm detection. Thisresearch is using multiple channels embedding the attentionbidirectional long-short memory (MCEA-BLSTM) model thatexplored sarcasm detection in news headlines and has differentapproach from previous research-developed models that lexical,semantic, and pragmatic properties. This research found that multiplechannels embedding attention mechanism improve the performance ofBLSTM, making it superior to other models. The proposed methodachieves 96.64% accuracy with an f-measure of 97%","PeriodicalId":52586,"journal":{"name":"Jurnal Sarjana Teknik Informatika","volume":"60 1","pages":""},"PeriodicalIF":0.0,"publicationDate":"2022-12-23","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"76057820","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2022-12-23DOI: 10.15408/jti.v15i2.27956
Elisabeth Levana Thedjakusuma, Fetty Fitriyanti Lubis
The Technical Implementation Unit is a part of a university or institute that supports the three pillars of higher education, one of which is the library. Library has a large collection of resources that can be accessed through a library catalog. ITB Library is a mobile application that allows users to search catalogs, but it currently lacks optimal appearance and user experience. The aim of this final project is to improve the ITB Library by implementing a user-centered design approach, which focuses on understanding and addressing user needs. The end goal is to create a high-fidelity prototype that meets the usability goals of effective to use, have good utility, easy to learn, and the user experience goal of being helpful. To evaluate the design, usability testing was conducted on the prototype. Testing was evaluated using several metrics, including task completion rate (100%), System Usability Scale (SUS) (93/100), Single Ease Question (SEQ) (6.7/7), and Intrinsic Motivation Inventory (IMI) (6.7/7 for the value/usefulness subscale) during the third iteration. Based on the results of the testing, the interaction design of the ITB Library meets the usability and user experience goals that were set out to be achieved.
{"title":"Interaction Design of ITB Library Application Using User-Centered Design","authors":"Elisabeth Levana Thedjakusuma, Fetty Fitriyanti Lubis","doi":"10.15408/jti.v15i2.27956","DOIUrl":"https://doi.org/10.15408/jti.v15i2.27956","url":null,"abstract":"The Technical Implementation Unit is a part of a university or institute that supports the three pillars of higher education, one of which is the library. Library has a large collection of resources that can be accessed through a library catalog. ITB Library is a mobile application that allows users to search catalogs, but it currently lacks optimal appearance and user experience. The aim of this final project is to improve the ITB Library by implementing a user-centered design approach, which focuses on understanding and addressing user needs. The end goal is to create a high-fidelity prototype that meets the usability goals of effective to use, have good utility, easy to learn, and the user experience goal of being helpful. To evaluate the design, usability testing was conducted on the prototype. Testing was evaluated using several metrics, including task completion rate (100%), System Usability Scale (SUS) (93/100), Single Ease Question (SEQ) (6.7/7), and Intrinsic Motivation Inventory (IMI) (6.7/7 for the value/usefulness subscale) during the third iteration. Based on the results of the testing, the interaction design of the ITB Library meets the usability and user experience goals that were set out to be achieved.","PeriodicalId":52586,"journal":{"name":"Jurnal Sarjana Teknik Informatika","volume":"109 1","pages":""},"PeriodicalIF":0.0,"publicationDate":"2022-12-23","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"88666262","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2022-09-30DOI: 10.35793/jti.17.3.2022.37151
Fransisca Xaveria Dyah Kusumawardhani, Vecky C. Poekoel, Arthur M. Rumagit
Setiap orang tidak dapat memperkirakan kondisi cuaca yang setiap saat bisa berubah-ubah secara cepat dan ekstrim. Perubahan cuaca yang ekstrim juga berpengaruh terhadap berbagai bidang seperti pertanian, penerbangan, peternakan dan lain sebagainya. Oleh sebab itu, mengetahui informasi suatu kondisi cuaca saat itu sangat penting dan digunakan utuk melihat perubahan cuaca yang sering berubah di tempat umum yang bisa terkontrol seperti kampus, tempat-tempat industri, juga rumah dan lain sebagainya. Saat ini masalah yang sering terjadi ialah diperlukan suatu sistem yang dapat memonitoring kondisi cuaca yang akurat. Dalam penelitian Tugas Akhir ini akan dibuat sebuah aplikasi android sistem monitoring kondisi cuaca, yang berguna bagi orang disekitar agar dapat mengetahui informasi kondisi perubahan cuaca dengan cepat. Sistem ini menggunakan modul bluetooth pada mikrokontroler ESP-32 DevKit v1 DOIT untuk proses pengiriman datanya, maka dari itulah alasannya mengapa kita masih membutuhkan sistem monitoring ini karena dapat memudahkan kita memperoleh informasi kondisi cuaca di sekitar dalam waktu yang singkat dan secara realtime dengan mengaksesnya pada aplikasi yang ada di smartphone android yang kita miliki tanpa adanya internet.
{"title":"Pembuatan Aplikasi Sistem Monitoring Kondisi Cuaca","authors":"Fransisca Xaveria Dyah Kusumawardhani, Vecky C. Poekoel, Arthur M. Rumagit","doi":"10.35793/jti.17.3.2022.37151","DOIUrl":"https://doi.org/10.35793/jti.17.3.2022.37151","url":null,"abstract":"Setiap orang tidak dapat memperkirakan kondisi cuaca yang setiap saat bisa berubah-ubah secara cepat dan ekstrim. Perubahan cuaca yang ekstrim juga berpengaruh terhadap berbagai bidang seperti pertanian, penerbangan, peternakan dan lain sebagainya. Oleh sebab itu, mengetahui informasi suatu kondisi cuaca saat itu sangat penting dan digunakan utuk melihat perubahan cuaca yang sering berubah di tempat umum yang bisa terkontrol seperti kampus, tempat-tempat industri, juga rumah dan lain sebagainya. Saat ini masalah yang sering terjadi ialah diperlukan suatu sistem yang dapat memonitoring kondisi cuaca yang akurat. Dalam penelitian Tugas Akhir ini akan dibuat sebuah aplikasi android sistem monitoring kondisi cuaca, yang berguna bagi orang disekitar agar dapat mengetahui informasi kondisi perubahan cuaca dengan cepat. Sistem ini menggunakan modul bluetooth pada mikrokontroler ESP-32 DevKit v1 DOIT untuk proses pengiriman datanya, maka dari itulah alasannya mengapa kita masih membutuhkan sistem monitoring ini karena dapat memudahkan kita memperoleh informasi kondisi cuaca di sekitar dalam waktu yang singkat dan secara realtime dengan mengaksesnya pada aplikasi yang ada di smartphone android yang kita miliki tanpa adanya internet.","PeriodicalId":52586,"journal":{"name":"Jurnal Sarjana Teknik Informatika","volume":"26 1","pages":""},"PeriodicalIF":0.0,"publicationDate":"2022-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"83439492","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2022-09-21DOI: 10.35793/jti.17.3.2022.41270
Merlin Florentina Blonteng, A. Sambul, S. Paturusi
Usability atau kegunaan merupakan salah satu faktor yang bisa berpengaruh terhadap keberhasilan suatu website. Pengguna website juga membutuhkan kenyamanan ataupun kepuasan agar mendapat pengalaman yang baik selama berinteraksi dengan suatu sistem atau produk. Dengan hal itu, tentunya penting jika memiliki User Interface/User Experience (UI/UX) yang bagus. Karena User Experience (UX) adalah salah satu komponen penting, pengguna yang berinteraksi dengan suatu sistem harus merasakan kemudahan secara efektif. Penelitian ini bertujuan untuk menganalisa pengalaman pengguna Portal INSPIRE Universitas Sam Ratulangi menggunakan metode kuesioner SUS karena sangat cocok dipakai agar lebih efektif dan efisien serta mampu menunjukkan kepuasan dari suatu sistem yang subjektif sehingga proses evaluasi dan analisis berpotensi lebih singkat. Hasil penelitian ini menunjukkan bahwa Analisa User Experience (UX) pada Portal INSPIRE Universitas Sam Ratulangi dapat dilakukan dengan mengevaluasi usability, dengan itu pengalaman pengguna dapat dilihat dari penerimaan pengguna berdasarkan perhitungan serta pengujian kuesioner dimana dari hasil perhitungan dan pengujian tersebut, Portal INSPIRE Universitas Sam Ratulangi termasuk dalam kategori Acceptable.
{"title":"Analysis of User Experience in University Academic Portal Using System Usability Scale (A Case Study in INSPIRE Portal of Sam Ratulangi University)","authors":"Merlin Florentina Blonteng, A. Sambul, S. Paturusi","doi":"10.35793/jti.17.3.2022.41270","DOIUrl":"https://doi.org/10.35793/jti.17.3.2022.41270","url":null,"abstract":"Usability atau kegunaan merupakan salah satu faktor yang bisa berpengaruh terhadap keberhasilan suatu website. Pengguna website juga membutuhkan kenyamanan ataupun kepuasan agar mendapat pengalaman yang baik selama berinteraksi dengan suatu sistem atau produk. Dengan hal itu, tentunya penting jika memiliki User Interface/User Experience (UI/UX) yang bagus. Karena User Experience (UX) adalah salah satu komponen penting, pengguna yang berinteraksi dengan suatu sistem harus merasakan kemudahan secara efektif. Penelitian ini bertujuan untuk menganalisa pengalaman pengguna Portal INSPIRE Universitas Sam Ratulangi menggunakan metode kuesioner SUS karena sangat cocok dipakai agar lebih efektif dan efisien serta mampu menunjukkan kepuasan dari suatu sistem yang subjektif sehingga proses evaluasi dan analisis berpotensi lebih singkat. Hasil penelitian ini menunjukkan bahwa Analisa User Experience (UX) pada Portal INSPIRE Universitas Sam Ratulangi dapat dilakukan dengan mengevaluasi usability, dengan itu pengalaman pengguna dapat dilihat dari penerimaan pengguna berdasarkan perhitungan serta pengujian kuesioner dimana dari hasil perhitungan dan pengujian tersebut, Portal INSPIRE Universitas Sam Ratulangi termasuk dalam kategori Acceptable.","PeriodicalId":52586,"journal":{"name":"Jurnal Sarjana Teknik Informatika","volume":"30 1","pages":""},"PeriodicalIF":0.0,"publicationDate":"2022-09-21","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"75048169","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Abstract - Pool Daily Report (LHP) is a report used by the Operations department and other relevant departments to find out the position, condition, and availability of rental units. In the process, this report is formed by several data sources including from the main system and mobile applications. Differences in data structure and format become the next obstacle faced in the data integration process. The management decision-making process is hampered because the information provided is less relevant, because some of the data is in another database that is different from the database used by the company. The implementation of a data warehouse is one of the efforts to integrate data. Extract-transform-load (ETL) is a method that can be used in a data warehouse to extract, transform, and save data back into the prepared target table. The result of this research is the implementation of the ETL process with a snowflake approach to produce the required dimensions, which are then related to form reports that are in accordance with the wishes of the user. Keywords- data warehouse, ETL, snowflake, pool daily reports. Intisari - Laporan Harian Pool (LHP) merupakan laporan yang digunakan oleh departemen Operation dan departemen terkait lainnya untuk mengetahui posisi, kondisi, dan ketersediaan unit sewa. Dalam prosesnya, laporan ini dibentuk oleh beberapa sumber data diantaranya berasal dari sistem utama dan aplikasi mobile. Perbedaan struktur dan format data menjadi kendala berikutnya yang dihadapi dalam proses integrasi data. Proses pengambilan keputusan manajemen menjadi terhambat karena informasi yang diberikan kurang relevan, dikarenakan sebagian data berada pada basis data lain yang berbeda dengan basis data yang digunakan oleh perusahaan. Penerapan data warehouse menjadi salah satu upaya dalam mengintegrasikan data. Extract-transform-load (ETL) merupakan salah satu metode yang dapat digunakan dalam data warehouse untuk mengekstrak, mentransformasi, dan menyimpan kembali data kedalam tabel target yang telah disiapkan. Hasil dari penelitian ini adalah di implementasikannya proses ETL dengan pendekatan snowflake untuk menghasilkan dimensi-dimensi yang dibutuhkan, untuk selanjutnya di relasikan membentuk pelaporan yang sesuai dengan keinginan pengguna. Kata Kunci— data warehouse, ETL, snowflake, laporan harian pool.
摘要/ Abstract摘要:租赁单位每日报表(LHP)是运营部门和其他相关部门用来了解租赁单位的位置、状况和可用性的报表。在此过程中，本报告由几个数据源组成，包括来自主系统和移动应用程序。数据结构和格式的差异成为数据集成过程中面临的下一个障碍。管理决策过程受到阻碍，因为提供的信息不太相关，因为一些数据在另一个数据库中，与公司使用的数据库不同。数据仓库的实现是集成数据的努力之一。提取-转换-加载(ETL)是一种在数据仓库中用于提取、转换数据并将其保存回准备好的目标表的方法。这项研究的结果是使用雪花方法实现ETL过程，以产生所需的维度，然后将其与符合用户愿望的表单报告相关联。关键词:数据仓库，ETL，雪花，池日报表。Intisari - Laporan Harian Pool (LHP) merupakan Laporan yang digunakan oleh department(行动部门)terkait lainnya untuk mengetahui posisi, kondisi, dan ketersedian unit sewa。数据处理，数据处理，数据处理，数据处理，数据处理，数据处理，数据处理，数据处理，数据处理，数据处理，数据处理，数据处理。Perbedaan构造和格式数据menjadi kendala berikutnya yang dihadapi dalam处理集成数据。论文:pengambilan keputusan management menjadi terhambat karena informasi yang diberikan kurang relevan, dikarenakan sebagian data berada ada pada basis data lain yang berbeda dengan basis data yang digunakan oleh perusahaan。日本数据仓库menjadi salah satu upaya dalam mengintegrasikan数据。提取-转换-加载(ETL)数据仓库，数据仓库，数据仓库，数据仓库，数据仓库。Hasil dari penelitian ini adalah di implementasikannya proproetl dengan pendekatan雪花untuk menghasilkan维数-维数yang dibutuhkan, untuk selanjutnya di relasikan membentuk pelaporan yang sesuai dengan keinginan pengguna。卡塔昆慈-数据仓库，ETL，雪花，拉波兰哈里安池。
{"title":"Implementasi Extract-Transform-Load (ETL) Data Warehouse Laporan Harian Pool","authors":"D. Andriansyah","doi":"10.51998/jti.v8i2.486","DOIUrl":"https://doi.org/10.51998/jti.v8i2.486","url":null,"abstract":"Abstract - Pool Daily Report (LHP) is a report used by the Operations department and other relevant departments to find out the position, condition, and availability of rental units. In the process, this report is formed by several data sources including from the main system and mobile applications. Differences in data structure and format become the next obstacle faced in the data integration process. The management decision-making process is hampered because the information provided is less relevant, because some of the data is in another database that is different from the database used by the company. The implementation of a data warehouse is one of the efforts to integrate data. Extract-transform-load (ETL) is a method that can be used in a data warehouse to extract, transform, and save data back into the prepared target table. The result of this research is the implementation of the ETL process with a snowflake approach to produce the required dimensions, which are then related to form reports that are in accordance with the wishes of the user.\u0000Keywords- data warehouse, ETL, snowflake, pool daily reports.\u0000Intisari - Laporan Harian Pool (LHP) merupakan laporan yang digunakan oleh departemen Operation dan departemen terkait lainnya untuk mengetahui posisi, kondisi, dan ketersediaan unit sewa. Dalam prosesnya, laporan ini dibentuk oleh beberapa sumber data diantaranya berasal dari sistem utama dan aplikasi mobile. Perbedaan struktur dan format data menjadi kendala berikutnya yang dihadapi dalam proses integrasi data. Proses pengambilan keputusan manajemen menjadi terhambat karena informasi yang diberikan kurang relevan, dikarenakan sebagian data berada pada basis data lain yang berbeda dengan basis data yang digunakan oleh perusahaan. Penerapan data warehouse menjadi salah satu upaya dalam mengintegrasikan data. Extract-transform-load (ETL) merupakan salah satu metode yang dapat digunakan dalam data warehouse untuk mengekstrak, mentransformasi, dan menyimpan kembali data kedalam tabel target yang telah disiapkan. Hasil dari penelitian ini adalah di implementasikannya proses ETL dengan pendekatan snowflake untuk menghasilkan dimensi-dimensi yang dibutuhkan, untuk selanjutnya di relasikan membentuk pelaporan yang sesuai dengan keinginan pengguna.\u0000Kata Kunci— data warehouse, ETL, snowflake, laporan harian pool.","PeriodicalId":52586,"journal":{"name":"Jurnal Sarjana Teknik Informatika","volume":"1 1","pages":""},"PeriodicalIF":0.0,"publicationDate":"2022-08-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"89709261","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Abstract— The selection of High Level Scholarship Recipients at the Amil Zakat Institute is a job that requires special accuracy in the process of assessing and sorting data on prospective scholarship recipients. It is hoped that this will result in selective, fair and satisfactory results, so that scholarship recipients who are deemed very necessary to be given further education funding assistance are selected according to predetermined criteria. Then the use of a computer-based Decision Support System (DSS) can be used as a solution in order to facilitate decision making. In this study, the method used is the Simple Multi-Attribute Rating Technology (SMART), with several stages in the calculation to determine the best rating. The conclusion from this research is that a computerized SMART decision support system can provide convenience in the scholarship data storage process by using a menu that can organize and manage scholarship data to be more neat and organized. It also provides efficiency in terms of time in the process of selecting scholarship recipients with the criteria for determining whether or not prospective scholarship recipients receive assistance. Keywords— High-Level Scholarship, Decision Support System (SPK), Simple Multy Attribute Rating Technique (SMART). Intisari— Penyeleksian Penerima Beasiswa Tingkat Tinggi di suatu Lembaga Amil Zakat merupakan pekerjaan yang memerlukan ketelitian khusus dalam prosespenilaian dan pemilahan data calon penerima beasiswa. Karena diharapkan dapat memperoleh hasil yang selektif, adil dan memuaskan, sehingga terpilihlah penerima beasiswa yang dianggap sangat perlu dan tepat sasaran untuk diberikan bantuan dana pendidikan tingkat lanjut sesuai dengan kriteria yang telah ditentukan. Karena itulah Penggunaan Sistem Pendukung Keputusan (SPK) berbasis komputer sangat diperlukan dan dapat dijadikan sebuah solusi agar memudahkan dalam pengambilan keputusan. Dalam penelitian ini metode yang digunakan adalah Simple Multy Attribute Rating Tecnique (SMART), dengan beberapa tahapan dalam perhitungan untuk menentukan rating terbaik. Kesimpulan yang dihasilkan dari penelitian ini adalah sistem pendukung keputusan dengan metode SMART secara terkomputerisasi dapat memberikan kemudahan dalam proses penyimpanan data beasiswa dengan penggunaan sebuah menu yang dapat mengatur dan mengelola data beasiswa menjadi lebih rapih dan tertata. Juga memberikan efesiensi waktu dalam proses pemilihan penerima beasiswa dengan kriteria penentu layak tidaknya calon penerima beasiswa dalam menerima bantuan. Kata Kunci— Beasiswa Tingkat Tinggi, Sistem Pendukung Keputusan (SPK), Simple Multy Attribute Rating Tecnique (SMART).
摘要:在Amil Zakat学院选择高水平奖学金获得者是一项工作，在评估和整理潜在奖学金获得者的数据时需要特别的准确性。希望这将导致有选择性、公平和令人满意的结果，以便根据预先确定的标准选出被认为非常有必要获得进一步教育资助的奖学金获得者。然后，使用基于计算机的决策支持系统(DSS)可以作为一种解决方案，以促进决策。在本研究中，使用的方法是简单多属性评级技术(Simple Multi-Attribute Rating Technology, SMART)，通过几个阶段的计算来确定最佳评级。本研究的结论是，计算机化的SMART决策支持系统可以在奖学金数据存储过程中提供便利，通过菜单来组织和管理奖学金数据，使其更加整洁和有条理。它还在选择奖学金获得者的过程中提供了时间上的效率，并确定了未来奖学金获得者是否获得援助的标准。关键词:高水平奖学金，决策支持系统(SPK)，简单多属性评级技术(SMART)。Intisari - penerelksian Penerima Beasiswa Tingkat Tinggi di suatu Lembaga Amil Zakat merupakan pekerjaan yang memerkan ketelitian khusus dalam procsespenilaian dan penilahan数据calon Penerima Beasiswa。Karena diharapkan dapat memperoleh hasil yang selektif, adil dan memuaskan, sehinga terpilihlah penerima beasiswa yang dianggap sangat perlu dan sasaran untuk diberikan bantuan dana pendidikan tingkat lanjut sesuai dengan kria yang telah ditentukan。Pendukung Keputusan (SPK)的计算机基础sangat diperlukan dan dapat dijadikan sebuah solusi agar memudahkan dalam pengambilan Keputusan。简单多属性评级技术(SMART)是一种简单多属性评级技术，是一种简单多属性评级技术。kespuldan yang dihasilkan dari penelitian ini adalah system pendukung keputusan dengan method SMART secara terkomputerisasi dapat memberikan kemudahan dalam处理penyimpanan数据beasiswa dengan penggunaan sebuah menu yang dapat mengatur dan mengelola数据beasiswa menjadi lebih raph dan tertata。Juga memberikan efesiensi waktu dalam promeilihan penerima beasiswa dengan标准penerima layak tidaknya calon penerima beasiswa dalam menerima bantuan。Kata Kunci - Beasiswa Tingkat Tinggi, system Pendukung Keputusan (SPK)， Simple multi - Attribute Rating technique (SMART)。
{"title":"Implementasi Metode SMART pada Seleksi Penerima Beasiswa Tingkat Tinggi di Lembaga Amil Zakat","authors":"Nina Sulawi Jaya Putri, Kusuma Hati","doi":"10.51998/jti.v8i2.502","DOIUrl":"https://doi.org/10.51998/jti.v8i2.502","url":null,"abstract":"Abstract— The selection of High Level Scholarship Recipients at the Amil Zakat Institute is a job that requires special accuracy in the process of assessing and sorting data on prospective scholarship recipients. It is hoped that this will result in selective, fair and satisfactory results, so that scholarship recipients who are deemed very necessary to be given further education funding assistance are selected according to predetermined criteria. Then the use of a computer-based Decision Support System (DSS) can be used as a solution in order to facilitate decision making. In this study, the method used is the Simple Multi-Attribute Rating Technology (SMART), with several stages in the calculation to determine the best rating. The conclusion from this research is that a computerized SMART decision support system can provide convenience in the scholarship data storage process by using a menu that can organize and manage scholarship data to be more neat and organized. It also provides efficiency in terms of time in the process of selecting scholarship recipients with the criteria for determining whether or not prospective scholarship recipients receive assistance.\u0000Keywords— High-Level Scholarship, Decision Support System (SPK), Simple Multy Attribute Rating Technique (SMART).\u0000Intisari— Penyeleksian Penerima Beasiswa Tingkat Tinggi di suatu Lembaga Amil Zakat merupakan pekerjaan yang memerlukan ketelitian khusus dalam prosespenilaian dan pemilahan data calon penerima beasiswa. Karena diharapkan dapat memperoleh hasil yang selektif, adil dan memuaskan, sehingga terpilihlah penerima beasiswa yang dianggap sangat perlu dan tepat sasaran untuk diberikan bantuan dana pendidikan tingkat lanjut sesuai dengan kriteria yang telah ditentukan. Karena itulah Penggunaan Sistem Pendukung Keputusan (SPK) berbasis komputer sangat diperlukan dan dapat dijadikan sebuah solusi agar memudahkan dalam pengambilan keputusan. Dalam penelitian ini metode yang digunakan adalah Simple Multy Attribute Rating Tecnique (SMART), dengan beberapa tahapan dalam perhitungan untuk menentukan rating terbaik. Kesimpulan yang dihasilkan dari penelitian ini adalah sistem pendukung keputusan dengan metode SMART secara terkomputerisasi dapat memberikan kemudahan dalam proses penyimpanan data beasiswa dengan penggunaan sebuah menu yang dapat mengatur dan mengelola data beasiswa menjadi lebih rapih dan tertata. Juga memberikan efesiensi waktu dalam proses pemilihan penerima beasiswa dengan kriteria penentu layak tidaknya calon penerima beasiswa dalam menerima bantuan.\u0000Kata Kunci— Beasiswa Tingkat Tinggi, Sistem Pendukung Keputusan (SPK), Simple Multy Attribute Rating Tecnique (SMART).","PeriodicalId":52586,"journal":{"name":"Jurnal Sarjana Teknik Informatika","volume":"77 4 1","pages":""},"PeriodicalIF":0.0,"publicationDate":"2022-08-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"77410821","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
京公网安备 11010802042870号
京ICP备2023020795号-1
扫码关注我们
求助内容：
应助结果提醒方式：