Perancangan Data Warehouse Penjualan Restoran Hotel Grand Allison Sentani Dengan Skema Galaxy

Hotel Grand Allison Sentani Papua is one of the largest hotels in Sentani Papua which has an income of billions of rupiah in one year, where one of its income comes from the sale of hotel restaurants. This hotel uses POS (Point Of Sales) to record daily hotel restaurant sales. Transaction data from the POS has not been stored and processed properly, so that the hotel has not been able to process it into the information needed. In this research, a Data Warehouse is designed using the Galaxy scheme which is implemented with MySQL database engine that is free for use. In addition, a web-based Online Analytical Processing (OLAP) application was created that displays graphs using the Highcharts toolkit. The Prototying approach is used to create OLAP applications. The test results demonstrate that the Data Warehouse, which consists of two fact tables, is helpful for housing all transaction data thus far, and the OLAP application produced is also capable of presenting information effectively via graphs processed with the Highcharts library