Retail Data Visualization in Business Intelligence System for Ayu Nadi Group

Ayu Nadi is a company engaged in the daily needs retail industry. Ayu Nadi applies a computer-based information system in recording and managing data that produces operational information on company transactions, including sales reports, purchase reports, goods return reports, stock cards, etc. The report format was presented in tabular form, where data and information were presented in the form of tables. The resulting report could not display interactive information such as describing sales growth. The difference between item sales comparisons became the weaknesses of the report results. Thus, other applications were needed to reprocess tabulated data into information in the form of graphs. In this study, a website-based business intelligence system was built to assist companies in processing the tabulated data into information in graphs that did not require a long time. The research method used in this study was the nine steps Kimball method. The research was conducted through functional needs analysis, data warehouse design, extract transform load process, implementation of business intelligence, and system testing. This system was tested using the black box testing method and user acceptance test and has provided the results of the system was running as needed. The result of this study was a dashboard that showed information in the form of graphs to assist in decision-making.