Article Per Year (5 Year)
p-Index From 2020 - 2025
1.8
P-Index
This Author published in this journals
All Journal Jurnal Algoritma Global Medical and Health Communication Jurnal Biomedika dan Kesehatan Contagion: Scientific Periodical Journal of Public Health and Coastal Health Indonesian Journal of Multidisciplinary Science Jurnal Riset Kedokteran Jurnal Algoritma JKKI : Jurnal Kedokteran dan Kesehatan Indonesia Bandung Conference Series : Medical Science
Yudi Feriandi
Fakultas Kedokteran Universitas Islam Bandung
Humanities Biochemistry, Genetics & Molecular Biology Computer Science & IT Decision Sciences, Operations Research & Management Dentistry Economics, Econometrics & Finance Education Engineering Environmental Science Health Professions Immunology & microbiology Languange, Linguistic, Communication & Media Law, Crime, Criminology & Criminal Justice Library & Information Science Materials Science & Nanotechnology Mathematics Medicine & Pharmacology Neuroscience Nursing Public Health Social Sciences

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

Found 1 Documents
Search
Journal : Jurnal Algoritma

 1 
Penggunaan SQL Server dalam Pengolahan Data Warehouse yang Praktis dan Berkelanjutan Arif Kuntadi; Yudi Feriandi
Jurnal Algoritma Vol 20 No 2 (2023): Jurnal Algoritma
Publisher : Institut Teknologi Garut

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33364/algoritma/v.20-2.1522

Abstract

To accommodate large amounts of data, a structured data warehouse is needed to produce more accurate information and support decision making for organizational stakeholders. To build a data warehouse, software such as Microsoft SQL Server can be used which has advantages in the aspects of data security, scalability, collaborative capabilities and extendability. Serial data on population, health personnel, economics and various continuous primary and secondary data can be uploaded into SQL Server so that it can be stored in a structured and periodic manner. Data stored in the database is processed using certain data mining algorithms to produce information, knowledge and wisdom. This data warehouse and data mining approach can be applied to various sectors, for example health. This research aims to apply a data warehouse and data mining approach to analyzing the ratio of health worker needs in West Java Province, Indonesia using a single moving average algorithm and semi-automatic classification using empirical statistics on SQL Server and SQL Server Agent as well as visualization using Microsoft Power BI. Classification based on forecasting analysis of population data and determining the health worker gap ratio was successful in finding patterns through data mining on SQL Server efficiently and easily visualized using Power BI. Thus, SQL Server can be one of the practical tools chosen for implementing sustainable data mining.
Co-Authors Arif Kuntadi Bestari Yuniah Budi Permana Budiman , Budiman Christina Juliane Dedi Rachmadi Desi Siti Suhartini Eka Nurhayati Ermina Widyastuti Fajar A. Yulianto Fajar Awalia Yulianto Gemah Nuripah, Gemah Hanna Goenawan Kartika Hajar Kirana, Kartika Hajar Kuntadi, Arif Lenny Oktorina Mahmudah Mahmudah Mia Kusmiati Nova Sylviana Oktorina, Lenny R. Kince Sakinah Rio Dananjaya Rizky Suganda Prawiradilaga Ronny Lesmana Santun Bhekti Rahimah Sidik Utoro Soria Putu Pratiwi Soria Putu Pratiwi, Soria Putu Sultan Hudzaifah Jihan Fadhilah Teddy Lestady Titik Respati Yuni Nurchasanah