Open AccessDecision support system using data warehouse for retail system
Author(s) -
Abba Suganda Girsang,
Geri Arisandi,
Calista Elysisa,
Michelle,
Melva Hermayanty Saragih
Publication year - 2019
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/1367/1/012007
Subject(s) - dashboard , online analytical processing , data warehouse , online transaction processing , database , database transaction , warehouse , computer science , transaction data , transaction processing , business intelligence , business , marketing
CMK company is a retail company that sell and distributes miniature vehicle items to small stores. CMK has several branches in various countries that use for operational and storage warehouse. This company faces the problem for analysing sales to decide the useful strategy since this company only uses Online Transaction Processing (OLTP) database. This study implements Online Analysis Processing (OLAP) database and data warehouse to provide useful information for this company by using the nine-step method designed by Kimball & Ross. The data will be performed into dashboard to make easier for CMK Company to analyze data. Furthermore, many useful information can be provided in short and efficient time.