Analysis of the Relationship Between Discounts, Payment Methods, and Total Purchases at Coffee Shop Can Ngopi

Abstract

This study aims to analyze the effect of discounts and payment methods on total customer purchases at Coffee Shop Can Ngopi. A total of 2,415 transactions were processed using a quantitative approach and multiple linear regression, supported by a data warehouse architecture based on the Kimball Lifecycle to ensure structured and reliable data preparation. The results indicate that both discounts and payment methods significantly influence total purchases; discounts enhance perceived value, while digital payments such as QRIS and e-wallets encourage higher spending due to their convenience. Although the model shows a low R², this is typical in consumer behavior research, and the model remains valid. The novelty of this study lies in the use of a data warehouse and real transactional data, providing more precise insights than survey-based approaches. The findings highlight that optimizing promotional strategies and selecting effective payment methods can improve sales performance in the F&B sector.