EUVIMEDEUVIMED entdecken
Crossref

Business Intelligence for Multidimensional Retail Sales Analysis Using a Data Warehouse

Hendra Marcos, Niko Lugas Prambudi, Willy Agung Ramdani

Applied Computer Science and Software Engineering · 2026

DOI: 10.63254/acsse.v2i1.60 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Applied Computer Science and Software Engineering, 2026. Verfasst von Hendra Marcos und 2 weiteren Autor:innen.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Retail transaction data must be transformed into reliable analytical information to support data-driven decision-making. This study develops a Business Intelligence (BI) framework based on a star-schema data warehouse for multidimensional retail sales analysis across customer, product, and time dimensions. A public Kaggle dataset containing 1,000 synthetic transactions from 2023 and nine attributes was processed through an Extract, Transform, and Load (ETL) pipeline implemented in Pentaho Data Integration and loaded into MySQL. Data validity was assessed using completeness, arithmetic-consistency, and referential-integrity criteria. The pipeline loaded all 1,000 transactions, with no missing required values, no discrepancies between Total Amount and Quantity × Price per Unit, and no unmatched foreign keys. The analysis produced a total sales value of 456,000 monetary units and 2,514 units sold. Electronics generated the highest sales value (156,905), whereas Clothing had the highest volume (894 units). Monthly sales peaked in May (53,150) and were lowest in September (23,620). Female and male customers contributed 51.06% and 48.94%, respectively. The framework demonstrates a traceable approach to multidimensional retail analytics, although generalization is limited by the synthetic dataset.

Zitieren

APA

Marcos, H., Prambudi, N. L., & Ramdani, W. A. (2026). Business Intelligence for Multidimensional Retail Sales Analysis Using a Data Warehouse. Applied Computer Science and Software Engineering. https://doi.org/10.63254/acsse.v2i1.60

Vancouver

Marcos H, Prambudi NL, Ramdani WA. Business Intelligence for Multidimensional Retail Sales Analysis Using a Data Warehouse. Applied Computer Science and Software Engineering. 2026. doi:10.63254/acsse.v2i1.60

BibTeX
@article{Marcos2026,
  author = {Marcos, Hendra and Prambudi, Niko Lugas and Ramdani, Willy Agung},
  title = {Business Intelligence for Multidimensional Retail Sales Analysis Using a Data Warehouse},
  journal = {Applied Computer Science and Software Engineering},
  year = {2026},
  doi = {10.63254/acsse.v2i1.60}
}
Kostenlos starten →