Article Per Year (5 Year)
p-Index From 2021 - 2026
3.673
P-Index
This Author published in this journals
All Journal JIK Jurnal Ilmu Komputer Jurnal Sarjana Teknik Informatika Jurnal Edukasi dan Penelitian Informatika (JEPIN) JUITA : Jurnal Informatika JURNAL MEDIA INFORMATIKA BUDIDARMA Indonesian Journal of Artificial Intelligence and Data Mining Sebatik JURTEKSI Progresif: Jurnal Ilmiah Komputer Indonesian Journal of Electrical Engineering and Computer Science Journal of Applied Data Sciences Jurnal Computer Science and Information Technology (CoSciTech) Majalah Ilmiah UPI YPTK Journal of Computer Scine and Information Technology Jurnal Pustaka Data : Pusat Akses Kajian Database, Analisa Teknologi, dan Arsitektur Komputer Jurnal Teknoif Teknik Informatika Institut Teknologi Padang Prosiding Seminar Nasional Sisfotek (Sistem Informasi dan Teknologi Informasi) Jurnal Komtekinfo Jurnal Teknologi
Eka Praja Wiyata Mandala
Universitas Putra Indonesia YPTK Padang
Civil Engineering, Building, Construction & Architecture Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Economics, Econometrics & Finance Education Electrical & Electronics Engineering Engineering Industrial & Manufacturing Engineering Materials Science & Nanotechnology Mechanical Engineering Social Sciences

Published : 36 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 2 Documents
Search
Journal : journal of computer scine and information technology

 1 
Designing a Star Schema for Optimizing the Total Sales of Motorcycles Eka Praja Wiyata Mandala; Randy Permana; Dewi Eka Putri
Journal of Computer Scine and Information Technology Volume 7 Issue 4 (2021): JCSITech
Publisher : Universitas Putra Indonesia YPTK Padang

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35134/jcsitech.v7i4.23

Abstract

Motorcycle sales have increased significantly, motorcycle manufacturers are competing to produce the latest models which are then sold to consumers. As a result, motorcycle dealers are overwhelmed with more and more data, not knowing what to do with it. Motorcycle dealers also have difficulty calculating the total sales of motorcycles. We try to provide solutions to deal with data overflow. We propose designing a star schema as the basis for creating a data warehouse. To create a star schema, we propose a four-step sequence in creating an effective star schema, starting from requirements analysis and reporting, understanding business processes, connecting and matching business processes with suitable entities and determining the dimensions of the business processes. We get a star schema with 1 fact table, motorcycle_sales and 11 of dimension tables, such as brand, color, customer, customer_contract, distributor, district, motorcycle, repair_workshop, sell_location, type and time. The star schema is an optimized model that provides the best performance in presenting more complex information
Decision Support System for Loan Eligibility using the Simple Additive Weighting (SAW) Method Kurnia, M Reza Tri; Mandala, Eka Praja Wiyata; Prawiro, Radius
Journal of Computer Scine and Information Technology Volume 9 Issue 4 (2023): JCSITech
Publisher : Universitas Putra Indonesia YPTK Padang

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35134/jcsitech.v9i4.84

Abstract

The Solok City Bakti Husada Employees Cooperative is a non-bank financial institution in the form of a cooperative that serves the needs of its members in lending services with collateral in the form of member savings. The aim of this research is to make it easier for the Bakti Husada Cooperative to determine the suitability of loans to borrowers and to create a Decision Making System using the Simple Additive Weighting (SAW) method which is able to assist the Bakti Husada Cooperative in determining the suitability of loans to borrowers. The data collection method was carried out by direct observation and interviews with employees from the Bakti Husada Cooperative, Solok City. The results obtained are effective in making decisions about loan eligibility at the Bakti Husada Cooperative in Solok City in accordance with the criteria that have been determined in the selection. This result is proven. By using this system, members who apply for a loan get a score that is in accordance with the criteria and weights that have been set and from there it can be seen if there are criteria that are not in accordance with the standard requirements of the member's application for a loan so that members can improve the loan requirements so that Loan applications are accepted by the cooperative. Gusnelawati obtained the calculation results using the SAW method to determine the feasibility of providing loans to cooperatives with a value of 0.9625 and was the 1st Best in making this decision.
Co-Authors Afdhal, Muhammad Dewi Eka Putri Dewi Eka Putri Dewi Eka Putri Dewi Eka Putri Dewi Eka Putri Dewi Eka Putri Emil Naf'an Faradila Mustika Gunadi Widi Nurcahyo Kurnia, M Reza Tri Laksamana, Ridho Mardhiah, Sitty Muhammad Reza Putra Muhammad Ridwan Muhammad, Abulwafa Musli Yanto Naf'an, Emil Prawiro, Radius Putra, Dede Wira Trise Putri, Dewi Eka Rafli, M Nerdi Randy Permana Rhayatun Aviqah Rianti, Eva Ridho Laksamana Rini Sovia Rini Sovia Sarjon Defit Subrianto Chandra Sumijan Sumijan Yuhandri Yuhandri, Yuhandri Zulfikri, Rahmat