Article Per Year (5 Year)
p-Index From 2021 - 2026
0.444
P-Index
This Author published in this journals
All Journal Sistemasi: Jurnal Sistem Informasi Jurnal Teknologi Sistem Informasi dan Aplikasi
Asmara, Gilang Windu
Unknown Affiliation
Computer Science & IT Electrical & Electronics Engineering

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

Found 2 Documents
Search

 1 
Design and Implementation of an ETL Pipeline for Prospective Student Data Analysis in Higher Education Admissions Setiyawati, Nina; Bangkalang, Dwi Hosanna; Asmara, Gilang Windu
Sistemasi: Jurnal Sistem Informasi Vol 14, No 5 (2025): Sistemasi: Jurnal Sistem Informasi
Publisher : Program Studi Sistem Informasi Fakultas Teknik dan Ilmu Komputer

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.32520/stmsi.v14i4.5158

Abstract

The number of universities in Indonesia continues to grow. This condition certainly makes the flow of new student admissions increasingly competitive between universities, thus encouraging universities to do branding, show quality, and do the right positioning. Therefore, it is important for universities to adopt a data-driven approach that can provide in-depth insights into prospective students and the effectiveness of marketing strategies. The purpose of this study is to design and build an ETL (Extract, Transform, Load) pipeline to collect, process, and analyze prospective student data as part of the business intelligence (BI) system to be built. The proposed ETL architecture design supports automated microservices-based data transformation in data cleaning, normalization, and integration. In addition, it can also be used as a solution to increase the scalability and flexibility of data mobilization in the BI system. This study introduces a novel approach by designing an ETL pipeline within a business intelligence framework aimed at enhancing university marketing efforts. Unlike prior research, which has primarily applied business intelligence tools to evaluate academic activities within learning management systems, this work shifts the focus to marketing analytics. Additionally, while existing studies on higher education marketing often center around digital marketing techniques and the marketing mix, this research fills a gap by proposing a technical infrastructure that supports data-driven marketing through automated ETL processes. The resulting ETL was tested using several methods, namely Source to Target Count Testing, Source to Target Data Testing, Duplicate Data Check Testing, and Data Transformation Testing. The results of each test are valid
Pembangunan Sumber Daya Sentralisasi Data pada Aplikasi Pengelolaan UMKM Menggunakan RESTFul dan Oauth 2.0 Setiyawati, Nina; Bangkalang, Dwi Hosanna; Asmara, Gilang Windu
Jurnal Teknologi Sistem Informasi dan Aplikasi Vol. 7 No. 2 (2024): Jurnal Teknologi Sistem Informasi dan Aplikasi
Publisher : Program Studi Teknik Informatika Universitas Pamulang

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.32493/jtsi.v7i2.35334

Abstract

Services for Micro, Small and Medium Enterprises (MSMEs) continue to be improved by the Department of Cooperatives, Small and Medium Enterprises (DinKopUKM) of Salatiga City. One way is to implement technology in various services. These applications need to be supported by the principle of information integration so that there is no data redundancy and dissemination of valid and reliable data is achieved. In this research, a resource server was built using RESTFul which allows third party systems to connect to product components to query information about objects and perform basic operations using the HTTP protocol. And using Oauth 2.0 is an open authorization protocol that allows third-party systems or applications via the HTTP protocol to access resources with certain access rights. This system is divided into four main parts, namely MSME actors registered in the system as resource owners, third party applications as data requesters/recipients, resource servers as resource service providers, and authorization servers which are useful for validating the identity of users and third party applications. With an integrated system, MSME players in the city of Salatiga do not need to repeat the MSME data collection process when using other information systems provided by the Salatiga city government while maintaining the security and privacy of user data.
Co-Authors Dwi Hosanna Bangkalang Nina Setiyawati