Implementation of Business Intelligence for Sales Data Management Using Interactive Dashboard Visualization in XYZ Stores

Abstract

Data Management is one of the crucial processes carried out at XYZ Store to get information about the sale of products. In carrying out its operational activities, XYZ Store uses the Smile Invent application to manage data on products sales transactions. Still, this application has not been able to assist managers in producing the required reports. Therefore, one way to overcome this problem is by implementing the Business Intelligence (BI) application at the XYZ Store by using Interactive Dashboard Visualization. In implementing the BI application, the BI Roadmap is used as a basis for conducting research starting from the identification of problems to be selected. After that, the planning phase is carried out by evaluating the infrastructure and planning projects. Then the analysis phase focuses on carrying out a detailed analysis of business problems and opportunities from BI implementation. Next is the design phase by carrying out the data warehouse design process and ETL using the Pentaho Data Integration (PDI). Then the implementation phase is carried out, namely the selection and use of BI application tools to perform Data Visualization. It is hoped that this research can produce reports in the form of Interactive Dashboard Visualization that can be used by store managers to make better decisions.