(Politeknik Negeri Bandung, Bandung, 40559, Indonesia)
(2) Soraya Kautsar
(Politeknik Negeri Bandung, Bandung, 40559, Indonesia)(3) Zia Wardhany
(Politeknik Negeri Bandung, Bandung, 40559, Indonesia)(4) Akhmad Bakhrun
(Politeknik Negeri Bandung, Bandung, 40559, Indonesia)(5) Safina Salsabila Suci Maheswari
(Politeknik Keuangan Negara STAN, Tangerang Selatan, 15222, Indonesia)*Corresponding author
AbstractThe Fast Moving Consumer Goods (FMCG) industry operates in a highly dynamic and competitive market, where fast and accurate decision-making is essential. This study aims to develop an interactive dashboard that visualizes sales data to generate actionable business insights. By utilizing Power BI and secondary data from 2017 to 2020, the dashboard enables users to explore sales trends, market performance, product contributions, and profit margins interactively. The results show that total revenue reached 985 million with 2 million units sold. Additionally, Delhi NCR and Mumbai were identified as the most contributing regions in sales volume, while Distribution-labeled products accounted for nearly 50% of total revenue. These findings demonstrate that data visualization significantly accelerates performance analysis, identifies market opportunities, and enhances the precision of managerial decisions.
KeywordsData Visualization; Dashboard; Business Insight; Decision Making; FMCG
|
DOIhttps://doi.org/10.33122/ejeset.v6i1.646 |
Article metricsAbstract views : 848 | PDF views : 707 |
Cite |
Full Text Download
|
References
Azzam, T., & Evergreen, S. (2013). Data visualization, Part 1: New directions for evaluation, number 139. John Wiley & Sons.
Chen, M., Mao, S., & Liu, Y. (2014). Big data: A survey. Mobile Networks and Applications, 19(2), 171–209. https://doi.org/10.1007/s11036-013-0489-0
Contreras, J., Koelpin, S., Delgado, E., & Sigman, E. P. (2018). Splunk 7 essentials: Demystify machine data by leveraging datasets, building reports, and sharing powerful insights, 3rd edition (3rd ed.). Packt Publishing.
Embarak, O. (2018). The importance of data visualization in business intelligence. Data Analysis and Visualization Using Python, 85-124. https://doi.org/10.1007/978-1-4842-4109-7_2
Feas, E. (2022). Exvatools: Value added in exports and other input-output table analysis tools. CRAN: Contributed Packages. https://doi.org/10.32614/cran.package.exvatools
Few, S. (2009). Now You See It: Simple Visualization Techniques for Quantitative Analysis. Analytics Press.
Fugini, M., Finocchi, J., & Locatelli, P. (2021). A big data analytics architecture for smart cities and smart companies. Big Data Research, 24, 100192. https://doi.org/10.1016/j.bdr.2021.100192
Gandomi, A., & Haider, M. (2015). Beyond the hype: Big data concepts, methods, and analytics. International Journal of Information Management, 35(2), 137–144. https://doi.org/10.1016/j.ijinfomgt.2014.10.007
Haque Sazu, M., & Akter Jahan, S. (2022). Can big data analytics improve the quality of decision-making in businesses? Iberoamerican Business Journal, 6(1), 04-27. https://doi.org/10.22451/5817.ibj2022.vol6.1.11063
Harinath, G., & Venkateswar Rao, R. (2023). The role of green marketing and how it effects on consumers in FMCG sector. International Journal of Science and Research (IJSR), 12(9), 1473-1477. https://doi.org/10.21275/sr23902121558
Katal, A., Wazid, M., & Goudar, R. H. (2013). Big data: Issues, challenges, tools and good practices. In 2013 Sixth International Conference on Contemporary Computing (IC3), 404–409. https://doi.org/10.1109/IC3.2013.6612229
Knaflic, C. N. (2015). Storytelling with data: A data visualization guide for business professionals. John Wiley & Sons.
Kolokolov, A., & Zelensky, M. (2024). Data visualization with Microsoft power BI. O'Reilly Media.
Kurniawan, A., & Pratama, R. (2022). Implementasi Dashboard Interaktif untuk Analisis Penjualan Menggunakan Power BI. Jurnal Teknologi dan Sistem Komputer, 10(1), 44–52.
LaValle, S., Lesser, E., Shockley, R., Hopkins, M. S., & Kruschwitz, N. (2011). Big data, analytics and the path from insights to value. MIT Sloan Management Review, 52(2), 21–32.
Leach, C. (2022). The theory, and how it applies to the FMCG industry. How to Save the FMCG Industry, 47-85. https://doi.org/10.1007/978-3-030-92986-2_3
Mahmood, Z. (2021). Fog Computing: Theory and Practice. In Fog Computing: Theory and Practice (pp. 253–270). Springer. https://doi.org/10.1007/978-3-030-57624-4_13
Microsoft. (2023). Power BI Overview. Retrieved from https://powerbi.microsoft.com
Nagarjuna, B. (n.d.). Information technology integration with supply chain management in FMCG industry. Archers & Elevators Publishing House.
Peck, G. (2021). Data Analytics and Visualization with Power BI. Wiley. ISBN: 9781119698787
Pettey, C., & Goasduff, L. (2011). Data Deluge: Business Intelligence Gets Smart. Gartner Research.
Price, T. (2017). Big data, dashboards, and data-driven educational decision making. Encyclopedia of Strategic Leadership and Management, 1314-1325. https://doi.org/10.4018/978-1-5225-1049-9.ch091
Reddy, R. J. S. (n.d.). AtliQ Hardware dataset (Version 1) [Data set]. Kaggle. Retrieved June 11, 2025, from https://www.kaggle.com/datasets/rajjshekharreddy/atliq-hardware-dataset
Rubaca, U. (2023). Readiness to manage more diversity and inclusion to gain competitive advantage in changing landscape of the workplace. The Changing Landscape of Workplace and Workforce. https://doi.org/10.5772/intechopen.1003122
Sivarajah, U., Kamal, M. M., Irani, Z., & Weerakkody, V. (2017). Critical analysis of Big Data challenges and analytical methods. Journal of Business Research, 70, 263–286. https://doi.org/10.1016/j.jbusres.2016.08.001
Sundararajan, B. (2025). Ultimate Apache Superset for data visualization and analytics: Leverage Apache Superset to create interactive dashboards and master modern business intelligence. Orange Education Pvt.
Tableau Software. (2019). Whitepaper: Dashboards for Everyone. https://www.tableau.com
Tominski, C., & Schumann, H. (2020). Interactive visual data analysis. CRC Press.
Wexler, S., Shaffer, J., & Cotgreave, A. (2017). The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios. Wiley.
Zhou, M., Zhang, W., & Guo, M. (2020). Modern Data Visualization Platforms: A Case for Power BI. IEEE Computing in Science & Engineering, 22(3), 84–90. https://doi.org/10.1109/MCSE.2020.2984962
Refbacks
- There are currently no refbacks.
Copyright (c) 2025 Kamila Nisa Az-Zahra*, Soraya Kautsar, Zia Wardhany, Akhmad Bakhrun, & Safina Salsabila Suci Maheswari
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Electronic Journal of Education, Social Economics and Technology (eJESET)
ISSN 2723-6250 (Online)
Published by the SAINTIS Publishing
Homepage: http://ejeset.saintispub.com
Editor E-mail : ; editor.ejeset@gmail.com
Editorial Office Address:
