Claim Missing Document
Check
Articles

Penerapan Dashboard Business Intelligence untuk Analisis Piutang Customer pada Perusahaan Manufaktur Bintang Noviansyah Syamsu; Dedi Trisnawarman; Agus Budiyantara
JURNAL PENELITIAN SISTEM INFORMASI (JPSI) Vol. 4 No. 2 (2026): Mei: JURNAL PENELITIAN SISTEM INFORMASI
Publisher : Institut Teknologi dan Bisnis (ITB) Semarang

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.54066/jpsi.v4i2.4074

Abstract

Manual management of customer receivables in manufacturing companies often leads to inefficiencies, including slow analysis processes, difficulty in monitoring outstanding balances, and limited ability to track payment trends comprehensively. This study designed a Business Intelligence Dashboard using Microsoft Power BI to address these issues at PT. XX Industry, employing a Software Development Life Cycle (SDLC) approach consisting of four stages: Planning, Analysis, Design, and Implementation. During the design phase, a data warehouse was built using a star schema model in SQL Server Management Studio, followed by an Extract, Transform, Load (ETL) process to ensure data accuracy and consistency prior to integration into Power BI. Five Key Performance Indicators (KPIs) were established collaboratively with company management through a series of online discussions, comprising Total Invoice, Total Payment, Total Receivables, Payment Rate, and Average Payment Time, all implemented using DAX expressions. The resulting dashboard features monthly trend visualizations, customer-based receivables distribution, and interactive filter capabilities. System testing confirmed that all components functioned correctly, while ETL validation verified consistency between processed and source data. User Acceptance Testing (UAT) conducted by management yielded an average score of 4.7 out of 5, reflecting a very high level of user acceptance. Overall, this dashboard proved effective in improving receivables monitoring efficiency and supporting faster, data-driven decision-making.
EXAMINING STUDENTS' BEHAVIORAL USE OF CAMPUS JOURNALS WITH THE TECHNOLOGY ACCEPTANCE MODEL APPROACH Agus Pratama W; Asrul Sani; Siti Aisyah; Merliani Ivone S; Agus Budiyantara
Jurnal Riset Informatika Vol. 4 No. 2 (2022): March 2022
Publisher : Kresnamedia Publisher

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (842.031 KB) | DOI: 10.34288/jri.v4i2.158

Abstract

Understudy conduct is an action completed by understudies for every person. Students who visit campus journal websites are essential in terms of journal accreditation aspects, where this is a benchmark for increasing the journal's potential as a reference. However, some factors influence it where the frequency of students visiting campus journal websites is not as expected in exploring journals, and the enthusiasm of students to download articles is still below the desired expectations. It causes the potential for the journal to obtain national accreditation at a small percentage, and students may think that there are very few reference sources for journals, so it is less attractive on the campus journal website system. Data collection methods were used in this study, such as interviews, literature study, and questionnaires. Meanwhile, evaluate the campus journal website system on student behavior using the Technology Acceptance Model (TAM) with four variables: perceived ease of use, usefulness, attitude toward using, and behavioral intention to use. This method makes the user feel it is easier to access the campus journal website; then, the user feels the campus journal website can provide benefits and usability. The user has a great curiosity about accessing the campus journal, and finally, the user wants to access the website and take the initiative to influence. other users in to access the same
SALES LEVEL ANALYSIS USING THE ASSOCIATION METHOD WITH THE APRIORI ALGORITHM Samuel Samuel; Asrul Sani; Agus Budiyantara; Merliani Ivone S; Frieyadie Frieyadie
Jurnal Riset Informatika Vol. 4 No. 4 (2022): September 2022
Publisher : Kresnamedia Publisher

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (822.013 KB) | DOI: 10.34288/jri.v4i4.194

Abstract

The company does not yet know the pattern of consumer purchases because, so far, the sales transaction data has not been used correctly and does not have a unique method to determine consumer buying patterns. The problems on the company, this research was done to reprocess sales transaction data for 2018-2019 using data mining techniques with association methods and apriori algorithms. RapidMiner is a supporting application to find association rules derived from transaction data. Processed transaction data using the Knowledge Discovery in Database approach. Thus, the company can determine consumer habits in buying goods from sales transaction data for 2018-2019. The results of this study are that in 2018, nine association rules were obtained, of which the best were CT G-246 ⇒ CT G-250 and CT G-250 ⇒ CT G-246. In 2019, nineteen association rules were received, of which the best were PN 0441, SK 0175 ⇒ SK 0530, and SK 0175, SK 0283, ⇒ SK 0530. From the best association rules, the goods in the Coat (imported), Pants, and Skirt categories are often bought together.
Penggunaan Metode Certainty Factor Pada Sistem Pakar Troubleshooting Jaringan Lan Komputer Ksatria Muhammad Al Rustam; Agus Budiyantara
SABER : Jurnal Teknik Informatika, Sains dan Ilmu Komunikasi Vol. 3 No. 1 (2025): Januari : Jurnal Teknik Informatika, Sains dan Ilmu Komunikasi
Publisher : STIKes Ibnu Sina Ajibarang

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.59841/saber.v3i1.2062

Abstract

An expert system is a computer program designed to imitate the decision-making abilities of an expert in a particular field, combining knowledge and rules obtained from experts to diagnose problems, provide advice, or make complex decisions, especially in computer LAN network disruptions, so this is needed application of an expert system for troubleshooting computer LAN networks for users which supports the diagnosis process using the certainty factor method, with an explanation of the certainty factor which has a concept based on symptoms and diagnosis from the weight of an expert's value and the user's value, then calculated using the formula in CF, the final result is the creation website-based computer LAN network troubleshooting expert system.
Developing a UKM Activity Application for Universities in North Jakarta Using Scrum Kevin Christianto; Francka Sakti Lee; Putu Sita Witari; Johanes Fernandes Andry; Agus Budiyantara
Journal of Information System and Informatics Vol 6 No 4 (2024): December
Publisher : Asosiasi Doktor Sistem Informasi Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.51519/journalisi.v6i4.956

Abstract

Student Activity Units (UKM) plays an important role in supporting the development of student skills outside of academic activities. However, the management of UKM activities often faces obstacles in communication, administration, and membership management. This study aims to develop a UKM Activity Application designed to improve the operational efficiency of UKMs at Universities in North Jakarta. This application is equipped with key features such as member registration, activity management, attendance, and transparency of financial administration. The development was carried out using the Scrum method, which involves an iterative process starting from user needs analysis, product backlog preparation, to feature development in sprints. Daily stand-up meetings are held to monitor progress, and sprint reviews are used for evaluation and adjustment. The final result of this study is an application that is able to improve the efficiency of UKM activity management, strengthen communication between members, and increase student involvement in campus activities. This application is expected to be a modern digital solution to facilitate the management of UKMs in the university environment.
Co-Authors Achmad Udin Zaelani Addarda, Binan Ade Davy Wiranata Agus Pratama W Ahmad Taufik Ahmad Taufik Alexandra, Jennifer Ananda, Deah Anang Maulana Andreanus Kevin Wijaya Anthony Gunawan Anton Hindardjo Arafat, Fadhilah ari ardiansyah sinta Arif Yuliawan Asrul Sani Asrul Sani Azhari, Ozmar Bernanda, Devi Yurisca Bintang Dwinanto Prakoso Bintang Noviansyah Syamsu Bunevasius Pekelmus Christianto, Kevin Dedi Trisnawarman Dirga Setia Fahreza Doharma, Rouli Doharma, Rouly Francka Sakti Lee Fresh Krist Wit Nesty Sarumaha Frieyadie Grace Apriliani Puteri Santoso Gunadi, Goldie Halim, Thirza Juan Hamzah Kadar Honni, Honni I Ketut Sudaryana, I Ketut Irma Suryani Irvan Lewenusa Irvan Lewenusa, Irvan Irwansyah Irwansyah Irwansyah Irwansyah Irwansyah Irwansyah Irwansyah Irwansyah Jap Wie Tjhe Jefry Leonardo Johanes Fernandes Andry Johanes Fernandes Andry Jovita Sutanto Kevin Christianto Kevin Christianto Ksatria Muhammad Al Rustam Mario, Eric Marsela Nihim Maulana, Brian Arif Merliani Ivone S Michael Rolland Mochamad Sofyan Muryono, Tupan Tri Nababan, Andika Jakaria Nastiti Tri Permatasari Nawangtyas, Nur Ninuk Wiliani Nur Nawaningtyas Pusparini Nur Nawaningtyas Pusparini Nur Nawaningtyas Pusparini Owen, Bryan Permatasari, Nastiti Tri Pusparini, Nur Nawaningtyas Putu Sita Witari Randy Anderias Adu Rizaldy Khair Samuel Samuel Sandri Sagitarius Sarumaha Sandy Duta Alam Sani, Asrul Shan Putra Elliotman Sarumaha Siti Aisyah Siti Aisyah Sofian Lusa Sofyan, Mochamad Supit, Merliani Ivone T. Husain Tezar Maula Tjhe, Jap Wie Tri M, Tupan Wildatur Rohmah