Claim Missing Document
Check
Articles

Found 1 Documents
Search

Implementation of Business Intelligence for Sales Analysis and Customer Segmentation at XYZ Store Azharani, Gerin; Nuryana, I Kadek Dwi
Journal of Emerging Information Systems and Business Intelligence (JEISBI) Vol. 6 No. 4 (2026): Vol. 06 Issue 04
Publisher : Universitas Negeri Surabaya

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.26740/jeisbi.v6i4.72050

Abstract

XYZ Retail Store has a large amount of transaction data, but it has not been optimally utilized for strategic decision making. The research aims to implement a Business Intelligence. Business Intelligence helps analyze sales data and segment key business entities, namely customers, suppliers, and products. The research methodology includes designing a datawarehouse using Kimball's Nine Step method with MySql as the database platform. Extract, Transform, Load (ETL) process is performed to prepare the data before processing with Online Analytical Processing (OLAP) approach for multidimensional sales analysis, and Data Mining with K-Means clustering algorithm to perform segmentation. The results obtained from the entire analysis, visualized using the tools of tableau.