Article Per Year (5 Year)
p-Index From 2021 - 2026
0.408
P-Index
This Author published in this journals
All Journal JSITP Journal Of Informatics And Busisnes
Novaldi, Alexander
Unknown Affiliation
Computer Science & IT Decision Sciences, Operations Research & Management Economics, Econometrics & Finance

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

Found 1 Documents
Search
Journal : Journal Of Informatics And Busisnes

 1 
Perancangan Data Warehouse Menggunakan Model Star Schema untuk Analisis Penjualan Retail Berbasis PostgreSQL Wijaya, Andri; Novaldi, Alexander
Journal Of Informatics And Busisnes Vol. 3 No. 3 (2025): Oktober - Desember
Publisher : CV. ITTC INDONESIA

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47233/jibs.v3i3.3759

Abstract

The retail industry faces significant challenges in managing massive transaction data volumes. Reliance on operational systems (OLTP) often hinders complex historical data analysis. This study aims to design and implement a Data Warehouse using the Star Schema approach to support efficient retail sales analysis. Utilizing the Sample Superstore dataset, the development follows Kimball’s methodology with technical ETL implementation on PostgreSQL. The research produced a Star Schema architecture consisting of one fact table and five dimension tables. Validation testing confirmed complete data integrity during migration. The results demonstrate the system's capability to present rapid multidimensional insights, including positive annual sales trends and profitability disparities across product categories. This implementation proves that PostgreSQL effectively serves as a robust infrastructure for business intelligence, providing a solid foundation for strategic management decision-making.
Co-Authors Andri Wijaya Stefanus Charles Selvianto