EUVIMEDEUVIMED entdecken
Open Access · CC BY-SA 4.0

Perancangan Data Warehouse untuk Analisis Penjualan Ritel Elektronik Berbasis Business Intelligence

Reno Naufal Maulidyan, M. Muharrom Al Haromainy

JURNAL ILMIAH PENELITIAN MAHASISWA · 19.06.2026 · 4 (3) · 980-989

DOI: 10.61722/jipm.v4i3.2604 ↗

Kurz gefasst

Fachartikel in der Zeitschrift JURNAL ILMIAH PENELITIAN MAHASISWA, online erschienen am 19.06.2026. Verfasst von Reno Naufal Maulidyan und 1 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY-SA 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

This study proposes a data warehouse design based on a star schema to support electronic retail sales analysis using PostgreSQL, Pentaho Data Integration, and Tableau. The objective is to transform heterogeneous transactional data into a structured analytical environment that can improve business intelligence capability. The research method includes data ingestion into a relational database, staging area construction, ETL-based cleansing and standardization, dimensional modeling, datamart development, and interactive dashboard visualization. The resulting architecture enables multidimensional analysis across time, product, region, sales channel, payment method, and customer type. The findings indicate that the proposed system improves data consistency, analytical efficiency, and decision-support capability, making it suitable as a foundation for retail performance monitoring and strategic planning.

Zitieren

APA

Maulidyan, R. N., & Haromainy, M. M. A. (2026). Perancangan Data Warehouse untuk Analisis Penjualan Ritel Elektronik Berbasis Business Intelligence. JURNAL ILMIAH PENELITIAN MAHASISWA, 4(3), 980-989. https://doi.org/10.61722/jipm.v4i3.2604

Vancouver

Maulidyan RN, Haromainy MMA. Perancangan Data Warehouse untuk Analisis Penjualan Ritel Elektronik Berbasis Business Intelligence. JURNAL ILMIAH PENELITIAN MAHASISWA. 2026;4(3):980-989. doi:10.61722/jipm.v4i3.2604

BibTeX
@article{Maulidyan2026,
  author = {Maulidyan, Reno Naufal and Haromainy, M. Muharrom Al},
  title = {Perancangan Data Warehouse untuk Analisis Penjualan Ritel Elektronik Berbasis Business Intelligence},
  journal = {JURNAL ILMIAH PENELITIAN MAHASISWA},
  year = {2026},
  volume = {4},
  number = {3},
  pages = {980--989},
  doi = {10.61722/jipm.v4i3.2604}
}
Kostenlos starten →