Proceedings of the 4th International Conference on Vocational Education and Technology, IConVET 2021, 27 November 2021, Singaraja, Bali, Indonesia

Research Article

Retail Data Visualization in Business Intelligence System for Ayu Nadi Group

Download384 downloads
  • @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
Wayan Gede Suka Parwita1,*, Ni Luh Wiwik Sri Rahayu Ginantra1, I Made Dwi Putra Asana1, I Gusti Lanang Agung Susila Dharma1
  • 1: STMIK STIKOM Indonesia
*Contact email: gede.suka@gmail.com

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.