The Use of Book Store GIS Data Warehouse in Implementing the Analysis of Most Book Selling

Data is the part that represents the evidence in presenting the state of the surrounding environment, obtained through research in the form of numbers, sources or scales. with data, conditions can be measured to produce the best solution. GIS Bookstore is one company that needs data every month to be analyzed. However, GIS Bookstore has constraints in processing large data with increasing time. for example GIS bookstore has problems in analyzing bestsellers because of the increasing number of authors and book publishers who work together. In this study, GIS Bookstore found a solution by implementing business intelligence that plays a role in the processing of raw data in large amounts of data into well-structured data information, the results are collected and processed in a data warehouse scheme. Targets stored in the data warehouse are data that will be processed based on the model design method (ERD) and star schema. This paper discusses the GIS Bookstore data warehouse with the aim of analyzing the sales of most books based on a certain time period. The method used in retrieving data uses Pentaho data integration tools, MySQL workbench, report designer, bi server and workbench schema.