Claim Missing Document
Check
Articles

Analisa Pola Penjualan Berbasis Data Warehouse Menggunakan Metode ETL dan OLAP (Studi Kasus: Restoran Khayangan Kuliner) Pratama, I Putu Agus Eka; I Komang Wahyu Hadi Permana
TEMATIK Vol 10 No 1 (2023): Tematik : Jurnal Teknologi Informasi Komunikasi (e-Journal) - Juni 2023
Publisher : LPPM POLITEKNIK LP3I BANDUNG

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.38204/tematik.v10i1.1317

Abstract

Sebagai salah satu restoran yang terdampak pandemi Covid19, Khayangan Kuliner mengalami penurunan penjualan serta perubahan pada pola penjualannya. Permasalahan utama pada penelitian ini yaitu Khayangan Kuliner belum memiliki sistem berbasis Teknologi Informasi (TI) untuk memudahkan proses analisis data dan menyederhanakan laporan bisnis mereka. Untuk itu, penelitian ini bertujuan membantu Khayangan Kuliner di dalam menyediakan sistem Data Warehouse untuk memudahkan mereka menganalisa data, mengetahui pola penjualan di masa pendemi, menentukan strategi penjualan, serta pengambilan keputusan. Langkah-langkah yang dilakukan di dalam penelitian meliputi pengumpulan data, pembuatan data multi dimensi, desain Data Warehouse, implementasi, pengujian, analisa, kesimpulan, dan dokumentasi. Penelitian ini menggunakan kombinasi metode On-Line Analytical Processing (OLAP) dan metode Extraction, Tranformation, Loading (ETL). Implementasi Data Warehouse menggunakan Talend Data Integration dan Tableau, untuk mendukung integrasi data pada semua jenis file, serta menghasilkan analisa dan laporan. Data dari sumber data diubah menjadi data multi dimensi untuk memudahkan proses analisa data. Hasil pengujian menunjukkan bahwa di masa pandemi (September 2021), menu makanan yang paling banyak terjual adalah gule dengan pembelian langsung di tempat. Report yang ditampilkan oleh sistem, membantu restoran Khayangan Kuliner di dalam melakukan analisa pola penjualan serta meningkatkan strategi penjualan dan pengambilan keputusan.
Smart Security Risk Management pada Bali Smart Island menggunakan OSINT, OTGv4.2, dan ISO 31000:2018 Pratama, I Putu Agus Eka
TEMATIK Vol. 10 No. 2 (2023): Tematik : Jurnal Teknologi Informasi Komunikasi (e-Journal) - Desember 2023
Publisher : LPPM POLITEKNIK LP3I BANDUNG

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

The integration of web-based services and information on Bali Smart Island, on the one hand, provides convenience, but on the other hand raises issues of threats and risks related to system, data, and information security. Current security testing only uses OWASP and OSINT but is not accompanied by risk assessment and risk management. This research conducted security testing on the Bali Smart Island domain using a combination of OSINT and OWASP Testing Guide (OTGv4.2) accompanied by ISO 31000:208 risk assessment and risk management. The research uses experimental methodology with Proof of Concept (PoC) using the Harvester tool in the target domain. The test results measure the level of risk, accompanied by recommendations. The final results of the research show that the combination of OSINT, OTGv4.2, and ISO 31000:2018, can provide the best and most effective solution for information technology security risk management guidelines on the Bali Smart Island, through security testing, assessing security test results, evaluation, and providing recommendations post-evaluation system improvements. In the future, this research can be continued by using a combination of other tools and methods for web security.
Data Mining Association Rules Menggunakan Algoritma Apriori untuk Menemukan Pola Pembelian Wisatawan pada Pasar Seni Guwang Bali Pratama, I Putu Agus Eka
TEMATIK Vol. 10 No. 2 (2023): Tematik : Jurnal Teknologi Informasi Komunikasi (e-Journal) - Desember 2023
Publisher : LPPM POLITEKNIK LP3I BANDUNG

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

As one of the art markets of interest to tourists, the Guwang Art Market in Gianyar Regency, Bali, has purchased transaction data that has not been utilized optimally to help traders understand consumer purchasing patterns and the relationship between items as a basis for decision making. For this reason, in this research, DAMIARPRI was designed and implemented as a web-based system using Data Mining Association Rules and the Apriori Algorithm to manage consumer purchasing transaction data at the Guwang Art Market. This research uses the Design Science Research Methodology (DSRM) research methodology, with case study qualitative research methods, as well as the BlackBox Testing testing method. The research results show that the system can show information on consumer purchasing patterns and the relationship between items, where the items most frequently purchased by tourists are men's beach pants, followed by men's beach t-shirts and men's beach sandals, with a support value of 3% and confidence of 100%. Based on this, traders at the Guwang Art Market can make decisions to add these items to increase income. In the future, it is hoped that the system can be further developed according to user needs.
Manajemen Risiko Teknologi Informasi Terkait Manipulasi dan Peretasan Sistem pada Bank XYZ Tahun 2020 Menggunakan ISO 31000:2018 Pratama, I Putu Agus Eka; Pratika, Made Toby Sathya
Jurnal Telematika Vol. 15 No. 2 (2020)
Publisher : Yayasan Petra Harapan Bangsa

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.61769/telematika.v15i2.333

Abstract

PT XYZ is the largest private bank in Indonesia which was founded in 1955. The use of Information Technology (IT) at XYZ Bank has changed the mindset of the public in transactions. This can be seen from the ease with which online shopping and non-cash payments are made using the application. Along with the use of IT at XYZ Bank, it is necessary to pay attention to the risks that result from using IT. Risk is the possibility of an event occurring in making a decision. To meet the strategic objectives of using IT, a company must implement risk management called Enterprise Risk Management (ERM). Currently XYZ Bank has used the Operational Risk Management Framework (ORMF). This research will try to implement risk management using the ISO 31000: 2018 framework related to IT problems faced by XYZ Bank in 2020. The method used is the assessment process in ISO 31000: 2018 which includes risk identification, risk analysis, and risk evaluation. This research has obtained results in the form of a large enough chance of the problem to recur and it is necessary to reduce the risk impact. From this research, it is hoped that a conclusion can be drawn regarding the need for a review regarding the problems faced so that the business objectives of XYZ Bank can be achieved. PT XYZ adalah bank swasta terbesar di Indonesia yang berdiri pada tahun 1955. Penggunaan Teknologi Informasi (TI) pada Bank XYZ telah mengubah pola pikir masyarakat dalam bertransaksi. Hal ini terlihat dengan mudahnya belanja secara daring dan juga pembayaran secara nontunai menggunakan aplikasi. Seiring dengan penggunaan TI di Bank XYZ, perlu diperhatikan risiko yang diakibatkan dari penggunaan TI. Risiko adalah kemungkinan terjadinya suatu kejadian dalam pengambilan suatu keputusan. Untuk memenuhi tujuan strategis penggunaan TI, suatu perusahaan harus menerapkan manajemen risiko yang bernama Enterprise Risk Management (ERM). Saat ini Bank XYZ telah menggunakan Operational Risk Management Framework (ORMF). Penelitian ini akan mencoba untuk menerapkan manajemen risiko menggunakan framework ISO 31000:2018 terkait dengan permasalahan TI yang dihadapi oleh Bank XYZ di tahun 2020. Metode yang digunakan adalah dengan proses penilaian yang ada pada ISO 31000:2018 yang meliputi identifikasi risiko, analisis risiko, dan evaluasi risiko. Penelitian ini memperoleh hasil berupa peluang terjadinya kembali permasalahan tersebut cukup besar, sehingga perlu dilakukan pengurangan dampak risiko. Dari penelitian ini, diharapkan dapat diperoleh kesimpulan mengenai perlunya peninjauan ulang terkait masalah-masalah yang dihadapi, sehingga tujuan bisnis dari Bank XYZ dapat tercapai.
EVALUASI DAN RANCANG ULANG TAMPILAN ANTARMUKA WEBSITE MENGGUNAKAN METODE SYSTEM USABILITY SCALE DAN DESIGN THINKING Wibowo, I Kadek Tribuana Tungga; Pratama, I Putu Agus Eka
J-Icon : Jurnal Komputer dan Informatika Vol 11 No 2 (2023): Oktober 2023
Publisher : Universitas Nusa Cendana

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35508/jicon.v11i2.12654

Abstract

The Communication and Informatics Agency of Gianyar Regency is responsible for providing information and services to the public through their official website. However, as with many organizations, they are faced with the challenge of ensuring optimal usability and quality of user experience. In this study, a usability evaluation of the official website of the Communication and Information Technology Office of Gianyar Regency was conducted using the System Usability Scale (SUS) method. The evaluation results show that their current website has a low level of usability with an average score of 45.28 (grade scale F). Furthermore, these results are used as a reference to provide a solution design to the problems faced using the Design Thinking approach. After that, testing the solution design that has been given to improve the website interface. The test results showed a significant improvement in usability, with an average score of 88.78 (grade scale A). This shows that the improvements and design changes that have been implemented have successfully improved the user experience and usability of the website of the Communication and Information Agency of Gianyar Regency.
Enterprise Resource Planning (ERP) Business Process Reengineering with Accelerated SAP (ASAP) and Kanban Methods (Case Study: Sahana Bali Craft) Liukae, Herry Daniel Prasetia; Pratama, I Putu Agus Eka; Putri, Gusti Agung Ayu
Jurnal Ilmiah Merpati (Menara Penelitian Akademika Teknologi Informasi) Vol 12 No 1 (2024): Vol. 12, No. 1, April 2024
Publisher : Lembaga Penelitian dan Pengabdian kepada Masyarakat Universitas Udayana

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24843/JIM.2024.v12.i01.p04

Abstract

Sahana Bali Craft, a handicraft company that produces Ayaman Bags typical of Tengenan Village, Karangasem Regency, Bali where through the results of interviews and observations, it was revealed that this company faced obstacles in recording production and cost calculations that were still done manually, application of the Make to Order concept was not well integrated, and the company did not have an Enterprise Resource Planning system and re-engineering was carried out. This research recommends the implementation of business process re-engineering as an effort to improve business process efficiency with the ASAP and Kanban methods. The ASAP method is used in designing ERP systems to optimize costs, time, and available resources, while the Kanban method is applied in project management at the business blueprint and realization stages. The business process engineering has been tested with the User Acceptance Testing method and shows 1320 < 1718 < 1760 which means that the proposed business process system is considered positive or quite successful for the company.
Website Quality Analysis Using WebQual 4.0, Customer Satisfaction Index, and Importance Performance Analysis Adhigamika, Dewa Putu Surya; Pratama, I Putu Agus Eka; Raharja, I Made Sunia
Jurnal Ilmiah Merpati (Menara Penelitian Akademika Teknologi Informasi) Vol 12 No 1 (2024): Vol. 12, No. 1, April 2024
Publisher : Lembaga Penelitian dan Pengabdian kepada Masyarakat Universitas Udayana

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24843/JIM.2024.v12.i01.p02

Abstract

The development of technology is currently growing rapidly in various aspects of human life, including in the field of education such as the creation of academic information systems. The study aims to analyze the quality of service on the SISAKTI-NG website based on user expectations and website performance. Question indicators in making questionnaires refer to three dimensions, namely: usability, information quality and interaction quality in the WebQual 4.0 Method by distributing questionnaires to 100 respondents. Analysis of website quality using the Customer Satisfaction Index Method to analyze satisfaction with SISAKTI-NG services and the Importance Performance Analysis Method to analyze the quality of SISAKTI-NG services and obtain indicators that require improvement and are maintained based on the perceptions and expectations of website users. The results show that the satisfaction of SISAKTI-NG website users is "SATISFIED" with a percentage of 73.88%. The results of IPA analysis there are 2 priority improvement question items and 10 question items that need to be maintained by the SISAKTI-NG website manager. Recommendations are given to USDI UNUD based on indicators that require improvement to improve service quality which is still low.
Digitalization of Web-Based Notary and PPAT Office Service Management Pratama, I Putu Agus Eka; Putri, Gusti Agung Ayu; Wati, Ni Luh Made Adi Dharma
Jurnal Ilmiah Merpati (Menara Penelitian Akademika Teknologi Informasi) Vol 11 No 3 (2023): Vol. 11, No. 3, December 2023
Publisher : Lembaga Penelitian dan Pengabdian kepada Masyarakat Universitas Udayana

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24843/JIM.2023.v11.i03.p01

Abstract

Notaris dan Pejabat Pembuat Akta Tanah (PPAT) merupakan sebuah lembaga yang disebutkan dalam Kitab Undang-Undang Hukum Perdata memiliki kewenangan berkaitan dengan pembuatan akta autentik. Seperti halnya dengan lembaga lain, Notaris dan PPAT membutuhkan sistem informasi untuk membantu meningkatkan efektivitas dan efisiensi pelayanan jasa lembaga tersebut. Oleh karena itu, penelitian ini dibuat dengan tujuan menghasilkan sistem informasi yang dapat membantu proses manajemen, melakukan pemantauan, dan pelaporan terhadap pelayanan jasa yang dilakukan oleh Notaris dan PPAT. Penelitian ini dilakukan dengan memanfaatkan metode Waterfall sebagai metode pengembangan yang menghasilkan 7 modul diantaranya Modul Manajemen Data Pegawai, Modul Manajemen Data Client, Modul Manajemen Autentikasi, Modul Manajemen Pelayanan Notaris, Modul Manajemen Pelayanan Notaris, dan Modul Pelaporan serta telah diuji dengan menggunakan Metode Pengujian Blackbox dan Post-Study System Usability Questionnaire (PSSUQ) yang menunjukan bahwa sistem ini dapat berjalan baik dan tepat guna dengan skor keseluruhan (Overall) pengujian 1.27.
Analisa Kategori Barang dengan Penjualan Terbanyak dalam Jangka Waktu 3 Bulan Menggunakan Data Warehouse Eka Pratama, I Putu Agus; Bernard, Rey
Jurnal ELTIKOM : Jurnal Teknik Elektro, Teknologi Informasi dan Komputer Vol. 6 No. 1 (2022)
Publisher : P3M Politeknik Negeri Banjarmasin

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31961/eltikom.v6i1.457

Abstract

UD. Makmur Sejahtera as one of the largest distributors of daily necessities in Manokwari Papua has sales transaction data for each category of goods and types of goods. These data are still physically stored in the form of notes and have not been digitized so that they can be utilized optimally to help UD. Makmur Sejahtera increases sales. This research has the basic idea of using digital sales transaction data to find out which categories of goods have the most sales in a period of three months (July 2020 to September 2020) through the Extraction, Transformation, Loading (ETL) process based on Pentaho Data Integration, to then be stored in multi-dimensional data forms, categorized, and visualized using Tableau. The test results show that rice commodity is the category of goods with the most sales in a period of three months and the implementation of the Data Warehouse is very helpful for UD. Makmur Sejahtera in achieving its business goals.
DATA WAREHOUSE KEPEMILIKAN MCK MENGGUNAKAN METODE ETL DAN BLACK-BOX (STUDI KASUS: KELURAHAN NITU, NTB) Pratama, I Putu Agus Eka; Syakurrahman, Muhammad
Jurnal Indonesia : Manajemen Informatika dan Komunikasi Vol. 4 No. 1 (2023): Januari
Publisher : Lembaga Penelitian dan Pengabdian Kepada Masyarakat (LPPM) STMIK Indonesia Banda Aceh

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35870/jimik.v4i1.107

Abstract

Preparation of government policies related to public services and facilities requires population data and its supporting technology. The Government of Bima, West Nusa Tenggara (NTB) has population data related to the ownership of each family in Nitu Village but is constrained by the technology to process these data. This research designs and implements a Data warehouse using the Extraction, Transformation, and Loading (ETL) method with the concept of multi-dimensional data. The system is implemented using Pentaho, then tested using the Black-Box method. The Data warehouse collects data from residents of the Nitu Kelurahan related to MCK ownership, then processed it to produce reports and data visualization. The stages of the research include data collection, identification of data dimensions, design, implementation, and Testing of the Data warehouse, as well as conclusions. The final results of the research show that the Data warehouse that was built helps the government in determining policy strategies and making decisions regarding the provision of MCK facilities for the people of Nitu Village, through reports and data visualization
Co-Authors Adhigamika, Dewa Putu Surya Adinatha, Dewa Gde Eka Krisna Altry David Purba Anak Agung Bagus Arya Wiradarma Anam, Fahri Choirul Andreyana, Putu Veda Anindya, Tabina Dea Arista, I Putu Gede Eka Yuda Arya Widyaningrat, Made Gunawan Assegaf, Achmad Jefri Ayu Wirdiani Bernard, Rey Budi Rahardjo Butarbutar, Ryan Timothy Benget Daulat Daniswara, Rasendriya Revo Debora, Uli Rindu Dewa Gede Kesuma Yoga Dharmawangsa, I Dewa Gede Govindha Dharmesta, Putu Adhika Dwi Chayani, Ni Kadek Chita Dwi Putra Githa Efraim William Solang Gede Rasben Dantes Geovaldo, I Putu Hendra Gusti Agung Ayu Putri Gusti Made Arya Sasmita Hrikesa, I Gusti Ngurah Agung Agie I Gede Agus Pradipta I Gusti Agung Made Wirautama I Gusti Ayu Triwayuni I Ketut Adi Purnawan I ketut Gede Darma Putra I Komang Wahyu Hadi Permana I Made Adhiarta Wikantyasa I Made Agus Dwi Suarjaya I Made Candiasa I Made Oka Widyantara I Made Sunia Raharja I Made Sunia Raharja I Made Sunia Raharja, I Made Sunia I Nyoman Gunantara I Nyoman Piarsa I Putu Gede Eka Yuda Arista I Wayan Gus Arisna Ida Bagus Kade Taruna Irianto Yohanes Sampe Isna Wanda Robiulla Johan Tamin Kevin Christopher Bakkara Krisnadinatha, I Gede Arya Lampung, Pramayota Fane'a Linawati Linawati Linawati Liukae, Herry Daniel Prasetia Mahaputra, Putu Andre Maharani, Ni Putu Berliana Mahawardana, Putu Pasek Okta Meilani, Ni Putu Cindy Mohammad Ernico Suryo Wicaksono Muhammad Syakurrahman NI Kade Mega Handayani Ni Made Ika Marini Mandenni nugraha, gemara adiyasa parahita Nurjana, Putu Ramaditya Pramayota Fane'a Lampung Pratika, Made Toby Sathya pratiwi, Dewa Ayu gandhi Prawira, I Gede Denis Yuda Purniawan, I Made Arta Putra, I Putu Bayu Aditya Putra, Yogiswara Dharma Putu Adhika Dharmesta Putu Adhika Dharmesta Putu Bayu Suarnata Wahyu Putra Putu Ramaditya Nurjana Putu Veda Andreyana Putu Veda Andreyana Radityawan, I Wayan Ananta Reyhan Todo Noer Yamin Riani, Dinda Sasmita, Gusti Arya Sasmita, Gusti Made Arya Satriya, Rizki Dwi Setyan, Ardath Prahara Syakurrahman, Muhammad Theca Difa Yulian Syahputri Wati, Ni Luh Made Adi Dharma Wibowo, I Kadek Tribuana Tungga Wicaksono, Mohammad Ernico Suryo Wiradarma, Anak Agung Bagus Arya Wiranatha, A. A. Kt. Agung Cahyawan Yogiswara Dharma Putra