Article Per Year (5 Year)
p-Index From 2020 - 2025
0.23
P-Index
This Author published in this journals
All Journal Jurnal Teknologi Informasi dan Pendidikan
Leonardus Adityo Toto Pratomo
Universitas Budi Luhur
Computer Science & IT Control & Systems Engineering Education Engineering

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

Found 1 Documents
Search

 1 
Extract, Transform, Load Monitoring sales Multi Marketplace Leonardus Adityo Toto Pratomo; Deni Mahdiana
Jurnal Teknologi Informasi dan Pendidikan Vol 16 No 1 (2023): Jurnal Teknologi Informasi dan Pendidikan
Publisher : Universitas Negeri Padang

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24036/jtip.v16i1.721

Abstract

This research is made in the design of a database system and online sales files for sales on a medium business scale, Era 5.0 Society many marketplaces make it easy for medium businesses to sell products, So business actors need to see the development of digital business and forecast their merchandise that is sold out online. As for the implementation of 1) database from RDBMS into MYSQL. The research uses an open source database, namely MYSQL, 2) The research method uses Microsoft Access program tools with the link to the Windows 10 operating system odbc in Extract Transform Load (ETL) which is carried out automatically with button 3 process Extract, Transform, Load from the download folder into the relational database management system (RDMS) in ms access and stored in the MySQL database. 3) This research forms raw data facts from several marketplaces and is processed into normalized table dimensions in the data warehouse. This research aims to design a combination of open-source systems and Microsoft access licenses, for business actors who need sales analysis that is sold multichannel (online or offline), to optimize stock and provide products consistently in each sales channel.
Co-Authors Deni Mahdiana