Research Article
Retail Data Visualization in Business Intelligence System for Ayu Nadi Group
@INPROCEEDINGS{10.4108/eai.27-11-2021.2315530, author={Wayan Gede Suka Parwita and Ni Luh Wiwik Sri Rahayu Ginantra and I Made Dwi Putra Asana and I Gusti Lanang Agung Susila Dharma}, title={Retail Data Visualization in Business Intelligence System for Ayu Nadi Group}, proceedings={Proceedings of the 4th International Conference on Vocational Education and Technology, IConVET 2021, 27 November 2021, Singaraja, Bali, Indonesia}, publisher={EAI}, proceedings_a={ICONVET}, year={2022}, month={2}, keywords={business intelligence data warehouse power bi}, doi={10.4108/eai.27-11-2021.2315530} }
- Wayan Gede Suka Parwita
Ni Luh Wiwik Sri Rahayu Ginantra
I Made Dwi Putra Asana
I Gusti Lanang Agung Susila Dharma
Year: 2022
Retail Data Visualization in Business Intelligence System for Ayu Nadi Group
ICONVET
EAI
DOI: 10.4108/eai.27-11-2021.2315530
Abstract
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.