Business Intelligence for Multidimensional Retail Sales Analysis Using a Data Warehouse
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.
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}
}
EUVIMED