Gusti Made Arya Sasmita
Current Organizations / Institutes
The organizations/institutes from the scholar's latest article
Gusti Made Arya Sasmita has a total of 31 co-authors. Here are the top co-authors by number of shared publications:
- I Putu Agus Eka Pratama
Udayana University
5 shared publications - Anak Agung Ketut Agung Cahyawan Wiranatha
Teknologi Informasi, Universitas Udayana
2 shared publications - A.A Putu Priyamdeva Arya Maheswara
Dept. of information Technology, Faculty of Engineering, Udayana University
1 shared publication - Agus Budiman Wiranata
Universitas Udayana
1 shared publication - Anak Agung Gde Mahendra Yana
Mahasiswa
1 shared publication Anak Agung Ketut Krishna Dwipayana
Universitas Udayana
1 shared publication
Latest Publications
- Open Access
- 30 December 2024
- Published by Universitas Udayana in Jurnal Ilmiah Merpati (Menara Penelitian Akademika Teknologi Informasi)
- Vol. 12 (3) , 191-203
Design and Implementation of Point to Point Wireless Network with VPN IPSec and GRE Security for Internet Network Distribution in Sulangai Village
Sulangai Village experiences limited internet access due to its geographical condition in a mountainous area, so cable infrastructure such as fiber optics is difficult to implement. The proposed solution is to use point-to-point wireless networks to provide reliable internet access. The research method used is the Network Development Life Cycle (NDLC), including the stages of analysis, design, simulation, implementation, monitoring and management. The test results show that the signal strength at the Base Station and Client Station is -69 dBm each, which is in the very good category. Security testing using IPsec VPN and GRE also showed adequate results, with the ability to encrypt data and protect the network from outsiders. Bandwidth speed testing before and after security implementation shows stable and satisfactory network performance, with consistent transmission and reception speeds. The results of the Quality of Service (QoS) analysis also show a significant increase after implementing security, with good throughput, packet loss, delay and jitter values.
- 30 December 2024
- Published by Universitas Udayana in Jurnal Ilmiah Merpati (Menara Penelitian Akademika Teknologi Informasi)
- Vol. 12 (3) , 191-203
Open AccessDesign and Implementation of Point to Point Wireless Network with VPN IPSec and GRE Security for Internet Network Distribution in Sulangai Village
Sulangai Village experiences limited internet access due to its geographical condition in a mountainous area, so cable infrastructure such as fiber optics is difficult to implement. The proposed solution is to use point-to-point wireless networks to provide reliable internet access. The research method used is the Network Development Life Cycle (NDLC), including the stages of analysis, design, simulation, implementation, monitoring and management. The test results show that the signal strength at the Base Station and Client Station is -69 dBm each, which is in the very good category. Security testing using IPsec VPN and GRE also showed adequate results, with the ability to encrypt data and protect the network from outsiders. Bandwidth speed testing before and after security implementation shows stable and satisfactory network performance, with consistent transmission and reception speeds. The results of the Quality of Service (QoS) analysis also show a significant increase after implementing security, with good throughput, packet loss, delay and jitter values.
- Open Access
- 30 December 2024
- Published by Universitas Udayana in Jurnal Ilmiah Merpati (Menara Penelitian Akademika Teknologi Informasi)
- Vol. 12 (3) , 204-213
Performance Analysis of the K-Nearest Neighbors (K-NN) for Sentiment Analysis of Online Loan Application X
The digital economy in Indonesia is growing rapidly, including in online lending services. Application X is one of the popular online lending applications, offering users convenience in applying for loans online. This research employs sentiment analysis on user reviews of Application X to understand their preferences and needs. The K-Nearest Neighbours (K-NN) method is applied as the primary algorithm for sentiment classification. Data collected through user review scraping undergoes a series of preprocessing stages, such as tokenization, stop word removal, and stemming, aimed at improving data quality. The K-NN model is tested in various scenarios to achieve the best results. The best scenario reveals that the highest accuracy is achieved by the K-NN model when the stop word removal process is not applied during the data preprocessing stage where the accuracy without using the stop word process was 92.9%, compared to 89.9% when using stop words.
- 30 December 2024
- Published by Universitas Udayana in Jurnal Ilmiah Merpati (Menara Penelitian Akademika Teknologi Informasi)
- Vol. 12 (3) , 204-213
Open AccessPerformance Analysis of the K-Nearest Neighbors (K-NN) for Sentiment Analysis of Online Loan Application X
The digital economy in Indonesia is growing rapidly, including in online lending services. Application X is one of the popular online lending applications, offering users convenience in applying for loans online. This research employs sentiment analysis on user reviews of Application X to understand their preferences and needs. The K-Nearest Neighbours (K-NN) method is applied as the primary algorithm for sentiment classification. Data collected through user review scraping undergoes a series of preprocessing stages, such as tokenization, stop word removal, and stemming, aimed at improving data quality. The K-NN model is tested in various scenarios to achieve the best results. The best scenario reveals that the highest accuracy is achieved by the K-NN model when the stop word removal process is not applied during the data preprocessing stage where the accuracy without using the stop word process was 92.9%, compared to 89.9% when using stop words.
- Open Access
- 28 November 2024
- Published by Universitas Udayana in Jurnal Ilmiah Merpati (Menara Penelitian Akademika Teknologi Informasi)
- Vol. 12 (2) , 105-113
OWASP Framework and OCTAVE Method for Penetration Testing Web Apps of College X
Information system security is a major focus for many organizations as increasingly sophisticated cyberattacks threaten the confidentiality, integrity and availability of online services. This research aims to identify and assess vulnerabilities in web applications at College X by using the OWASP framework and OCTAVE method. OWASP is used to identify common and critical web vulnerabilities, while OCTAVE provides a holistic understanding of an organization's security risks. Testing was conducted with the tools and techniques recommended by both frameworks. The results found a number of vulnerabilities, including two low-level and one high-level. The findings underscore the importance of systematic penetration testing and risk assessment to keep web applications secure in educational environments.
- 28 November 2024
- Published by Universitas Udayana in Jurnal Ilmiah Merpati (Menara Penelitian Akademika Teknologi Informasi)
- Vol. 12 (2) , 105-113
Open AccessOWASP Framework and OCTAVE Method for Penetration Testing Web Apps of College X
Information system security is a major focus for many organizations as increasingly sophisticated cyberattacks threaten the confidentiality, integrity and availability of online services. This research aims to identify and assess vulnerabilities in web applications at College X by using the OWASP framework and OCTAVE method. OWASP is used to identify common and critical web vulnerabilities, while OCTAVE provides a holistic understanding of an organization's security risks. Testing was conducted with the tools and techniques recommended by both frameworks. The results found a number of vulnerabilities, including two low-level and one high-level. The findings underscore the importance of systematic penetration testing and risk assessment to keep web applications secure in educational environments.
- Open Access
- 14 September 2024
- Published by Publikasi Indonesia in Jurnal Indonesia Sosial Teknologi
- Vol. 5 (9) , 3510-3523
Internet of Things Based Water Quality Control System
Fish incubation, which involves the hatching of fish eggs, represents the process of embryogenesis until the embryo emerges from its protective shell. This intricate developmental journey is influenced by a combination of internal and external factors. External factors can be influenced by water quality that is not suitable for hatching fish eggs. Water quality, which includes temperature, dissolved oxygen, light intensity, salinity, and pH, is an important and limiting factor for living creatures that live in water, including chemical, biological, and physical factors. Poor water quality can prevent fish eggs from hatching and even cause death. The primary objective here is the creation of an Internet of Things (IoT)-based system designed for controlling water quality during fish incubation. This system is intended to aid fish farmers in effectively control the environmental conditions within their incubation ponds. The method used in designing IoT device is research and development, and it uses the Arduino Mega microcontroller as the main device to run pH sensors, turbidity sensors, oxygen sensors, temperature sensors, and relay modules. Water Quality Control System The fish incubation was successful. The average time needed to change the water temperature from 28.5 to 29 degrees Celsius is 4 minutes and 7 seconds; change the dissolved oxygen level from 11 to 11.5 is 3 minutes and 33 seconds; change the pH value of the water from 6.9 to 7.1; and maintain turbidity below 5 with an average time of 5 minutes and 58 seconds. Controlling water quality can speed up the fish egg incubation process for 8 hours.
- 14 September 2024
- Published by Publikasi Indonesia in Jurnal Indonesia Sosial Teknologi
- Vol. 5 (9) , 3510-3523
Open AccessInternet of Things Based Water Quality Control System
Fish incubation, which involves the hatching of fish eggs, represents the process of embryogenesis until the embryo emerges from its protective shell. This intricate developmental journey is influenced by a combination of internal and external factors. External factors can be influenced by water quality that is not suitable for hatching fish eggs. Water quality, which includes temperature, dissolved oxygen, light intensity, salinity, and pH, is an important and limiting factor for living creatures that live in water, including chemical, biological, and physical factors. Poor water quality can prevent fish eggs from hatching and even cause death. The primary objective here is the creation of an Internet of Things (IoT)-based system designed for controlling water quality during fish incubation. This system is intended to aid fish farmers in effectively control the environmental conditions within their incubation ponds. The method used in designing IoT device is research and development, and it uses the Arduino Mega microcontroller as the main device to run pH sensors, turbidity sensors, oxygen sensors, temperature sensors, and relay modules. Water Quality Control System The fish incubation was successful. The average time needed to change the water temperature from 28.5 to 29 degrees Celsius is 4 minutes and 7 seconds; change the dissolved oxygen level from 11 to 11.5 is 3 minutes and 33 seconds; change the pH value of the water from 6.9 to 7.1; and maintain turbidity below 5 with an average time of 5 minutes and 58 seconds. Controlling water quality can speed up the fish egg incubation process for 8 hours.
- Open Access
- 8 April 2024
- Published by MECS Publisher in International Journal of Information Technology and Computer Science
- Vol. 16 (2) , 45-56
Web Application Penetration Testing on Udayana University's OASE E-learning Platform Using Information System Security Assessment Framework (ISSAF) and Open Source Security Testing Methodology Manual (OSSTMM)
Education is a field that utilizes information technology to support academic and operational activities. One of the technologies widely used in the education sector is web-based applications. Web-based technologies are vulnerable to exploitation by attackers, which highlights the importance of ensuring strong security measures in web-based systems. As an educational organization, Udayana University utilizes a web-based application called OASE. OASE, being a web-based system, requires thorough security verification. Penetration testing is conducted to assess the security of OASE. This testing can be performed using the ISSAF and OSSTMM frameworks. The penetration testing based on the ISSAF framework consists of 9 steps, while the OSSTMM framework consists of 7 steps for assessment. The results of the OASE penetration testing revealed several system vulnerabilities. Throughout the ISSAF phases, only 4 vulnerabilities and 3 information-level vulnerabilities were identified in the final testing results of OASE. Recommendations for addressing these vulnerabilities are provided as follows. Implement a Web Application Firewall (WAF) to reduce the risk of common web attacks in the OASE web application. input and output validation to prevent the injection of malicious scripts addressing the stored XSS vulnerability. Update the server software regularly and directory permission checks to eliminate unnecessary information files and prevent unauthorized access. Configure a content security policy on the web server to ensure mitigation and prevent potential exploitation by attackers.
- 8 April 2024
- Published by MECS Publisher in International Journal of Information Technology and Computer Science
- Vol. 16 (2) , 45-56
Open AccessWeb Application Penetration Testing on Udayana University's OASE E-learning Platform Using Information System Security Assessment Framework (ISSAF) and Open Source Security Testing Methodology Manual (OSSTMM)
Education is a field that utilizes information technology to support academic and operational activities. One of the technologies widely used in the education sector is web-based applications. Web-based technologies are vulnerable to exploitation by attackers, which highlights the importance of ensuring strong security measures in web-based systems. As an educational organization, Udayana University utilizes a web-based application called OASE. OASE, being a web-based system, requires thorough security verification. Penetration testing is conducted to assess the security of OASE. This testing can be performed using the ISSAF and OSSTMM frameworks. The penetration testing based on the ISSAF framework consists of 9 steps, while the OSSTMM framework consists of 7 steps for assessment. The results of the OASE penetration testing revealed several system vulnerabilities. Throughout the ISSAF phases, only 4 vulnerabilities and 3 information-level vulnerabilities were identified in the final testing results of OASE. Recommendations for addressing these vulnerabilities are provided as follows. Implement a Web Application Firewall (WAF) to reduce the risk of common web attacks in the OASE web application. input and output validation to prevent the injection of malicious scripts addressing the stored XSS vulnerability. Update the server software regularly and directory permission checks to eliminate unnecessary information files and prevent unauthorized access. Configure a content security policy on the web server to ensure mitigation and prevent potential exploitation by attackers.
- Open Access
- 31 March 2024
- Published by Universitas Pendidikan Ganesha in Jurnal Nasional Pendidikan Teknik Informatika (JANAPATI)
- Vol. 13 (1) , 22-32
SARIMA with Sliding Window Implementation for Forecasting Seasonal Demand Data
Demand forecasting is an essential part of business process management. A comparison of methods is needed to get the best model to provide good forecasting results. Difficulties in meeting consumer demands and predicting these requests using demand data at companies CV. ABCD is the main problem in this research. The SARIMA and decomposition methods are used for comparison and search for the best model before forecasting. SARIMA with a windowing size of 56, indicating the smallest MAPE value of 3,91%. The value <10%, so it can be said to produce an excellent forecasting value. Forecasting results with SARIMA show a meeting between actual and forecasting data in 2022. Therefore, it can be said the forecasting results for 2023 and 2024 can be used as a reference for the company CV. ABCD to meet customer demand and avoid stock shortages.
- 31 March 2024
- Published by Universitas Pendidikan Ganesha in Jurnal Nasional Pendidikan Teknik Informatika (JANAPATI)
- Vol. 13 (1) , 22-32
Open AccessSARIMA with Sliding Window Implementation for Forecasting Seasonal Demand Data
Demand forecasting is an essential part of business process management. A comparison of methods is needed to get the best model to provide good forecasting results. Difficulties in meeting consumer demands and predicting these requests using demand data at companies CV. ABCD is the main problem in this research. The SARIMA and decomposition methods are used for comparison and search for the best model before forecasting. SARIMA with a windowing size of 56, indicating the smallest MAPE value of 3,91%. The value <10%, so it can be said to produce an excellent forecasting value. Forecasting results with SARIMA show a meeting between actual and forecasting data in 2022. Therefore, it can be said the forecasting results for 2023 and 2024 can be used as a reference for the company CV. ABCD to meet customer demand and avoid stock shortages.
- Open Access
- 23 February 2024
- Published by Universitas Udayana in JITTER : Jurnal Ilmiah Teknologi dan Komputer
- Vol. 5 (1) , 2082-2090
Perancangan Integrasi Sistem Enkripsi dan Steganografi untuk Pengamanan Data Suara Manusia Berbasis Web
Audio steganography on images is a method used to secretly hide audio messages in images. The Least Significant Bit (LSB) method is also combined with Advanced Encryption Standard (AES) to increase the security of confidential messages. Audio messages that you want to keep secret can be encrypted using Advanced Encryption Standard (AES) before being inserted into the image. Advanced Encryption Standard (AES) can be combined with the use of Rivest Shamir Adleman (RSA) on Advanced Encryption Standard (AES) keys. Rivest Shamir Adleman (RSA) is used to increase the security of Advanced Encryption Standard (AES) keys. The Advanced Encryption Standard (AES) key can be encrypted using Rivest Shamir Adleman (RSA) before being inserted into the image using the Least Significant Bit (LSB) Method, so that only recipients who have the Rivest Shamir Adleman (RSA) key are suitable for accessing the audio message. kept secret. The results of this processing can be measured from the PSNR (Peak-Signal-to-Noise Ratio) figure.
- 23 February 2024
- Published by Universitas Udayana in JITTER : Jurnal Ilmiah Teknologi dan Komputer
- Vol. 5 (1) , 2082-2090
Open AccessPerancangan Integrasi Sistem Enkripsi dan Steganografi untuk Pengamanan Data Suara Manusia Berbasis Web
Audio steganography on images is a method used to secretly hide audio messages in images. The Least Significant Bit (LSB) method is also combined with Advanced Encryption Standard (AES) to increase the security of confidential messages. Audio messages that you want to keep secret can be encrypted using Advanced Encryption Standard (AES) before being inserted into the image. Advanced Encryption Standard (AES) can be combined with the use of Rivest Shamir Adleman (RSA) on Advanced Encryption Standard (AES) keys. Rivest Shamir Adleman (RSA) is used to increase the security of Advanced Encryption Standard (AES) keys. The Advanced Encryption Standard (AES) key can be encrypted using Rivest Shamir Adleman (RSA) before being inserted into the image using the Least Significant Bit (LSB) Method, so that only recipients who have the Rivest Shamir Adleman (RSA) key are suitable for accessing the audio message. kept secret. The results of this processing can be measured from the PSNR (Peak-Signal-to-Noise Ratio) figure.
- Open Access
- 18 October 2023
- Published by Universitas Udayana in JITTER : Jurnal Ilmiah Teknologi dan Komputer
- Vol. 4 (3) , 1933-1944
Development of a Notification-Based Network Security Monitoring System Using Network Development Life Cycle (NDLC)
Developments in information and communication technology which are increasing rapidly, it is also required to improve the quality of security. The increase of internet usage has led to high number of intrusions or attacks that exploit weaknesses in internet protocols, operating systems and application software. Due to the high number of attacks, information technology security is an important thing to consider in an organization or individual. One solution that can be applied to overcome this problem is to monitor network security. One of the implementations of network security monitoring is the implementation of an Intrusion Detection System (IDS). The purpose of this research was to design a Snort-based network security monitoring system as a tool for implementing IDS to detect attacks by sending notifications via Telegram Bot which is integrated with the server owned by Unit Sumber Daya Informasi Universitas Udayana using the Network Development Life Cycle (NDLC) method. Based on the configuration results of research conducted on the Unit Sumber Daya Informasi Universitas Udayana server, there was the lowest data on May 16, 2023 with 64,418 data and the highest data on April 04, 2023 with 261,672 data and 2 Nmap Scan attack data as the lowest type of attack and 13,703 DDoS attack data as the highest type of attack.
- 18 October 2023
- Published by Universitas Udayana in JITTER : Jurnal Ilmiah Teknologi dan Komputer
- Vol. 4 (3) , 1933-1944
Open AccessDevelopment of a Notification-Based Network Security Monitoring System Using Network Development Life Cycle (NDLC)
Developments in information and communication technology which are increasing rapidly, it is also required to improve the quality of security. The increase of internet usage has led to high number of intrusions or attacks that exploit weaknesses in internet protocols, operating systems and application software. Due to the high number of attacks, information technology security is an important thing to consider in an organization or individual. One solution that can be applied to overcome this problem is to monitor network security. One of the implementations of network security monitoring is the implementation of an Intrusion Detection System (IDS). The purpose of this research was to design a Snort-based network security monitoring system as a tool for implementing IDS to detect attacks by sending notifications via Telegram Bot which is integrated with the server owned by Unit Sumber Daya Informasi Universitas Udayana using the Network Development Life Cycle (NDLC) method. Based on the configuration results of research conducted on the Unit Sumber Daya Informasi Universitas Udayana server, there was the lowest data on May 16, 2023 with 64,418 data and the highest data on April 04, 2023 with 261,672 data and 2 Nmap Scan attack data as the lowest type of attack and 13,703 DDoS attack data as the highest type of attack.
- Open Access
- 3 May 2023
- Published by Universitas Udayana in JITTER : Jurnal Ilmiah Teknologi dan Komputer
- Vol. 4 (2) , 1829-1840
APPLICATION OF BUSINESS INTELLIGENCE IN THE CRIMINAL ACTION OF CURANMOR (CASE STUDY OF THE LEGAL AREA OF DENPASAR POLICE)
Kejahatan merupakan suatu bentuk tindakan yang dapat merugikan orang lain, salah satunya tindak kejahatan pencurian kendaraan bermotor. Terdapat banyak faktor yang menyebabkan seseorang melakukan tindakan pencurian kendaraan bermotor, salah satunya adalah kurangnya pengaman didalam kendaraan bermotor yang menyebabkan mudahkan pencuri melakukan tindakan curanmor. Provinsi Bali mengalami peningkatan tingkat curnamor setiap tahunnya. Berdasarkan hal tersebut polisi daerah Provinsi Bali membutuhkan strategi yang tepat didalam memantau perkembangan tingkat curanmor beserta cara agar menanggulanginya. Penelitian ini bertujuan untuk membangun dashboard business intelligence untuk memudahkan didalam memonitoring tingkat kejahatan curanmor khususnya di Provinsi Bali sekaligus menggantikan pemakaian kertas menjadi media database. Proses didalam pembuatan dashboard menggunakan beberapa metode diantaranya ETL (Extraction, Transformation, Loading) yang nantinya hasil pengolahan data akan disimpan kedalam database menggunakan tools MySQL, dan OLAP (Online Analytical Processing) yang nantinya menghasilkan visualisasi dalam bentuk dashboard menggunakan tools Microsoft Power BI dan adanya penambahan peramalan menggunakan metode regresi linier. Visualisasi yang dihasilkan didalam penelitian ini akan berupa bar chart, line chart, dan geographic information system atau GIS.
- 3 May 2023
- Published by Universitas Udayana in JITTER : Jurnal Ilmiah Teknologi dan Komputer
- Vol. 4 (2) , 1829-1840
Open AccessAPPLICATION OF BUSINESS INTELLIGENCE IN THE CRIMINAL ACTION OF CURANMOR (CASE STUDY OF THE LEGAL AREA OF DENPASAR POLICE)
Kejahatan merupakan suatu bentuk tindakan yang dapat merugikan orang lain, salah satunya tindak kejahatan pencurian kendaraan bermotor. Terdapat banyak faktor yang menyebabkan seseorang melakukan tindakan pencurian kendaraan bermotor, salah satunya adalah kurangnya pengaman didalam kendaraan bermotor yang menyebabkan mudahkan pencuri melakukan tindakan curanmor. Provinsi Bali mengalami peningkatan tingkat curnamor setiap tahunnya. Berdasarkan hal tersebut polisi daerah Provinsi Bali membutuhkan strategi yang tepat didalam memantau perkembangan tingkat curanmor beserta cara agar menanggulanginya. Penelitian ini bertujuan untuk membangun dashboard business intelligence untuk memudahkan didalam memonitoring tingkat kejahatan curanmor khususnya di Provinsi Bali sekaligus menggantikan pemakaian kertas menjadi media database. Proses didalam pembuatan dashboard menggunakan beberapa metode diantaranya ETL (Extraction, Transformation, Loading) yang nantinya hasil pengolahan data akan disimpan kedalam database menggunakan tools MySQL, dan OLAP (Online Analytical Processing) yang nantinya menghasilkan visualisasi dalam bentuk dashboard menggunakan tools Microsoft Power BI dan adanya penambahan peramalan menggunakan metode regresi linier. Visualisasi yang dihasilkan didalam penelitian ini akan berupa bar chart, line chart, dan geographic information system atau GIS.
- Open Access
- 3 May 2023
- Published by Universitas Udayana in JITTER : Jurnal Ilmiah Teknologi dan Komputer
- Vol. 4 (2) , 1868-1879
Penerapan Business Intelligence Untuk Prediksi Penjualan Produk (Studi Kasus PT. XYZ)
Kemajuan teknologi yang begitu cepat dan pertumbuhan dunia bisnis yang meningkat pesat menimbulkan banyaknya persaingan yang terjadi dalam dunia perekonomian. Manajemen pemasaran harus dilakukan dengan baik, mengingat pemasaran adalah hal itu penting dilakukan oleh setiap perusahaan. Permintaan produk oli meningkat setiap tahunnya, dengan anggaran sebesar ± Rp 7 triliun pada tahun 2012 atau naik 3% jika dilihat tahun sebelumnya. Peningkatan permintaan oli merupakan salah satu faktor yang mendorong perluasan pasar. PT. XYZ merupakan sebuah perusahaan anggota dari XYZ Group. Penerapan Business intelligence berupa perancangan dashboard information system dapat membantu proses pengambilan keputusan sesuai dengan kebutuhan dari bisnis, seperti pengambilan keputusan didalam perusahaan. Penelitian ini bertujuan untuk membangun Business intelligence Dashboard yang berfungsi memberikan informasi terhadap penjualan oli PT. XYZ mengingat pentingnya informasi ini karena berpengaruh pada peningkatan penjualan. Proses pembuatan dashboard menggunakan beberapa metode diantaranya database untuk membuat skema menggunakan MySQL, untuk menampilkan visualisasi data menggunakan tools Microsoft Power BI dan forecasting menggunakan metode ARIMA menggunakan tools Jupyter Notebook yang menghasilkan nilai rata-rata tingkat error MAPE sebesar 1,35%.
- 3 May 2023
- Published by Universitas Udayana in JITTER : Jurnal Ilmiah Teknologi dan Komputer
- Vol. 4 (2) , 1868-1879
Open AccessPenerapan Business Intelligence Untuk Prediksi Penjualan Produk (Studi Kasus PT. XYZ)
Kemajuan teknologi yang begitu cepat dan pertumbuhan dunia bisnis yang meningkat pesat menimbulkan banyaknya persaingan yang terjadi dalam dunia perekonomian. Manajemen pemasaran harus dilakukan dengan baik, mengingat pemasaran adalah hal itu penting dilakukan oleh setiap perusahaan. Permintaan produk oli meningkat setiap tahunnya, dengan anggaran sebesar ± Rp 7 triliun pada tahun 2012 atau naik 3% jika dilihat tahun sebelumnya. Peningkatan permintaan oli merupakan salah satu faktor yang mendorong perluasan pasar. PT. XYZ merupakan sebuah perusahaan anggota dari XYZ Group. Penerapan Business intelligence berupa perancangan dashboard information system dapat membantu proses pengambilan keputusan sesuai dengan kebutuhan dari bisnis, seperti pengambilan keputusan didalam perusahaan. Penelitian ini bertujuan untuk membangun Business intelligence Dashboard yang berfungsi memberikan informasi terhadap penjualan oli PT. XYZ mengingat pentingnya informasi ini karena berpengaruh pada peningkatan penjualan. Proses pembuatan dashboard menggunakan beberapa metode diantaranya database untuk membuat skema menggunakan MySQL, untuk menampilkan visualisasi data menggunakan tools Microsoft Power BI dan forecasting menggunakan metode ARIMA menggunakan tools Jupyter Notebook yang menghasilkan nilai rata-rata tingkat error MAPE sebesar 1,35%.