Designing a Dashboard for Sales Trends and Analysis at Coventown Glodok Jakarta
Abstract
Coventown is a coffee shop with a Chinese theme located in the Petak Enam Glodok area, Jakarta. The sales dashboard design allows Coventown Glodok Jakarta to identify sales patterns, and predict sales performance through historical data analysis. This study aims to present data in easy-to-understand visualizations to demonstrate the use of dashboards in improving the efficiency of sales monitoring, providing strategic insights into trends, and achieving sales targets to support more precise and effective decision-making. The prototype development iterations were planned quickly, and the data was processed using Microsoft Power BI and the Python programming language. The results of this study show that the sales dashboard at Coventown Glodok Jakarta effectively monitors sales in line with Key Performance Indicators (KPIs) such as time, category, product, price, and quantity. The resulting dashboard improves the efficiency of monitoring sales performance and helps the company display sales trends for best-selling products.
Keywords
References
F. Fonggo, J. T. Beng, and D. Arisandi, “Web-based canteen payment and ordering system,” IOP Conference Series: Materials Science and Engineering, vol. 879, no. 1, pp. 1–7, 2020, doi: 10.1088/1757-899X/879/1/012037.
R. Akbar, M. Silvana, M. H. Hersyah, and M. Jannah, “Implementation of Business Intelligence for Sales Data Management Using Interactive Dashboard Visualization in XYZ Stores,” in Proc. 2020 Int. Conf. on Information Technology Systems and Innovation (ICITSI), Bandung–Bali, Indonesia, 2020, pp. 242–249, doi: 10.1109/ICITSI50517.2020.9264970.
E. Jumantoro, Strategi Pengembangan Destinasi Pariwisata Kawasan Pecinan di Kota Tangerang, Undergraduate Thesis, Universitas Sultan Ageng Tirtayasa, Serang, Indonesia, 2022.
D. A. Andini and R. N. Nugraha, “Kawasan Pecinan Glodok sebagai Daya Tarik Wisata Kuliner,” Jurnal Pariwisata dan Budaya, vol. 6, pp. 1–12, 2023.
A. A. Rahman, Y. B. Adamu, and P. Harun, “Review on dashboard application from managerial perspective,” in Proc. Int. Conf. on Research and Innovation in Information Systems (ICRIIS), Langkawi, Malaysia, 2017, pp. 1–6, doi: 10.1109/ICRIIS.2017.8002532.
D. S. Nazir, G. Virginia, R. Restyandito, A. Filiana, and A. G. Prabawati, “Pembangunan Dashboard untuk Mendukung Analisis Kartu Rencana Studi dan Kartu Hasil Studi Mahasiswa,” Jurnal Teknik Informatika dan Sistem Informasi, vol. 7, no. 1, pp. 20–29, Apr. 2021, doi: 10.28932/jutisi.v7i1.3539.
J. Wenngren and A. Rizk, “Prototyping for Digital Innovation: Investigating the Impact of Digital Technology on Prototyping Elements,” Administrative Sciences, vol. 14, no. 7, p. 142, Jul. 2024, doi: 10.3390/admsci14070142.
E. D. Lunzaga, R. G. Padoginog, L. M. Razalo, and W. Borja, “Research and Education Sustainability: Unlocking Opportunities in Shaping Today’s Generation Decision Making and Building Connections,” in Proc. Int. Conf. on Research and Education Sustainability (I-CRES), Manila, Philippines, Oct. 2024.
S. A. Asri, I. N. G. A. Astawa, I. G. A. M. Sunaya, K. A. Yasa, I. N. E. Indrayana, and W. Setiawan, “Implementation of Prototyping Method on Smart Village Application,” Journal of Physics: Conference Series, vol. 1569, no. 2, p. 022007, 2020, doi: 10.1088/1742-6596/1569/2/022007.
R. S. Pressman and B. R. Maxim, Business Intelligence Analytics and Data Science: A Managerial Perspective, in Software Engineering: A Practitioner’s Approach, 9th ed. New York, NY, USA: McGraw-Hill Education, 2020.
R. S. Pressman and B. R. Maxim, Software Engineering: A Practitioner’s Approach, 8th ed. New York, NY, USA: McGraw-Hill Education, 2015.
Charlie, J. T. Beng, and D. Arisandi, “Website-based information system for mapping restaurants or eating places in DKI Jakarta using Google Maps,” IOP Conference Series: Materials Science and Engineering, vol. 879, no. 1, pp. 1–6, 2020, doi: 10.1088/1757-899X/879/1/012035.
C. Damar, S. Wardhana, and D. Trisnawarman, “Analitika Kejahatan: Memanfaatkan Metode ADDIE untuk Merancang Dashboard Interaktif tentang Tren dan Analisis Kejahatan (Crime Analytics: Utilizing ADDIE Methods to Design an Interactive Dashboard on Crime Trends and Analytics),” Journal of Information Technology and Computer Science (INTECOMS), vol. 7, no. 3, pp. 45–58, 2024.
M. van de Ven, P. Lara Machado, A. Athanasopoulou, B. Aysolmaz, and O. Turetken, “Key performance indicators for business models: a systematic review and catalog,” Information Systems and e-Business Management, vol. 21, no. 3, pp. 753–794, Sep. 2023, doi: 10.1007/s10257-023-00650-1.
R. A. Jaleel and T. M. J. Abbas, “Design and Implementation of Efficient Decision Support System Using Data Mart Architecture,” in Proc. 2nd Int. Conf. on Electrical, Communication and Computer Engineering (ICECCE), Istanbul, Turkey, Jun. 2020, pp. 1–6, doi: 10.1109/ICECCE49384.2020.9179297.
O. Irvan, J. T. Beng, and D. Trisnawarman, “Dashboard Pengukuran Kinerja Program Studi Perguruan Tinggi,” Jurnal Ilmu Komputer dan Sistem Informasi, vol. 8, no. 2, pp. 115–124, 2021.
How To Cite This :
Refbacks
- There are currently no refbacks.
