Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Sinergi : Jurnal Ilmiah Multidisiplin
Kevin Alexander Yech
Program Studi Sistem Informasi, Fakultas Sains dan Teknologi, Universitas Katolik Musi Charitas, Indonesia
Aerospace Engineering Humanities Biochemistry, Genetics & Molecular Biology Education Environmental Science Health Professions Immunology & microbiology Physics Social Sciences

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

Found 1 Documents
Search

 1 
Perancangan Data Warehouse Penjualan E-Commerce untuk Analisis Tren Produk dan Brand Populer Branchris; Kevin Alexander Yech; Andri Wijaya
Sinergi : Jurnal Ilmiah Multidisiplin Vol. 2 No. 1 (2026): Sinergi: Jurnal Ilmiah Multidisiplin
Publisher : PT. AHLAL PUBLISHER NUSANTARA

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

This study presents the design of a data warehouse to support analysis of product trends and popular brands in e-commerce sales. The system integrates sales data from multiple sources through the ETL (Extract, Transform, Load) process and applies a star schema model. Using multidimensional analysis (OLAP), insights on monthly trends, brand performance, and product sales variations over time were generated. The results show that the designed data warehouse effectively supports operational decision-making and marketing strategies. Keywords: data warehouse, e-commerce, OLAP, ETL, star schema   Abstrak Penelitian ini membahas perancangan data warehouse untuk mendukung analisis tren produk dan brand populer pada penjualan e-commerce. Sistem dirancang untuk mengintegrasikan data penjualan dari berbagai sumber (pelanggan, produk, transaksi), melalui proses ETL (Extract, Transform, Load), lalu dianalisis menggunakan model star schema. Analisis data menggunakan visi multidimensi (Online Analytical Processing) menghasilkan insight tren per bulan, performa brand, serta variasi penjualan produk dalam periode tertentu. Hasil rancangan ini menunjukkan bahwa data warehouse mampu mendukung keputusan operasional dan strategi pemasaran. Kata kunci: data warehouse, e-commerce, OLAP, ETL, star schema
Co-Authors Andri Wijaya Branchris