Claim Missing Document
Check
Articles

Found 2 Documents
Search
Journal : Journal of Computer Scine and Information Technology

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 M Reza Tri Kurnia; Eka Praja Wiyata Mandala; Radius Prawiro
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.