Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Jurnal Tekinkom (Teknik Informasi dan Komputer)
Marbun, Timo Adelina
Unknown Affiliation
Computer Science & IT

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

Found 1 Documents
Search

 1 
PENERAPAN TEKNOLOGI BUSINESS INTELLIGENCE DALAM MENINGKATKAN STRATEGI PENJUALAN DENGAN METODE OLAP PADA CAFÉ LE KAHVE Sipayung, Arif Richardo Idola; Zendrato, Nur Eni; Marbun, Timo Adelina; Telaumbanua, Jeremia Nicholas; Sihombing, Oloan
Jurnal Tekinkom (Teknik Informasi dan Komputer) Vol 7 No 2 (2024)
Publisher : Politeknik Bisnis Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.37600/tekinkom.v7i2.1529

Abstract

This research aims to develop a data warehouse system and information dashboard based on Business Intelligence (BI) technology with the OLAP method to improve sales strategies at Le Kahve, a coffee shop company. The BI implementation uses Pentaho Data Integration for the ETL (Extract, Transform, Load) process and Microsoft Power BI for dashboard visualization. The ETL process is carried out to collect, process, and link sales data obtained from the Point of Sales (POS) system in Excel format. The data is then processed into a data warehouse using a star schema, which facilitates multidimensional analysis. Through the OLAP method, sales data is analyzed across various dimensions such as product, time, and payment method. The data visualization results in the form of a dashboard enable the company to quickly view sales performance and make more effective decisions. This dashboard provides information on best-selling products, product categories, and sales trends over time. The research results show that by implementing BI and OLAP, the company can improve operational efficiency, accelerate analysis, and support decision-making to enhance sales strategies and company competitiveness.
Co-Authors Oloan Sihombing, Oloan Sipayung, Arif Richardo Idola Telaumbanua, Jeremia Nicholas Zendrato, Nur Eni