Utilization of Sales Data Analysis to Optimize Stock Management and Product Promotion Strategies in Web-Based Perfume Stores
Keywords:
Sales Data Analysis, Inventory Management, Promotion Strategy, Business Intelligence, Web Based Systems, Retail.Abstract
The competitive nature of the online perfume store business requires efficient inventory management to avoid overstocking and understocking, as well as targeted promotional strategies. Historical sales data is a strategic asset, but it is often not optimally utilized in decision making. This study aims to develop a sales data analysis model that is integrated into a web-based Business Intelligence (BI) system. The main objectives are to help perfume stores optimize product availability, adjust promotional strategies based on consumer behavior, and improve operational efficiency through a data-driven approach. This study uses a descriptive-exploratory design by analyzing 10,450 sales transaction data. Data analysis methods include time series analysis to identify trends, inventory turnover analysis for inventory management, and the Apriori algorithm to discover promotional patterns. The analysis results are implemented into a web-based BI dashboard and evaluated using the System Usability Scale (SUS). This study successfully identified fast-moving products (e.g., Floral Blossom) and slow-moving products (e.g., Sweet Vanilla). It was found that discount promotions (22.5% increase) and bundling (17.8% increase) were the most effective strategies for increasing sales. The developed BI dashboard system was proven to reduce manual analysis time by 65% and obtain. This study successfully identified fast-moving products (e.g., Floral Blossom) and slow-moving products (e.g., Sweet Vanilla). It was found that discount promotions (22.5% increase) and bundling (17.8% increase) were the most effective strategies for increasing sales. The developed BI dashboard system was proven to reduce manual analysis time by 65% and obtained a SUS score of 83, which is categorized as “very good.” This study concluded that integrating sales data analysis into a web-based BI system effectively transforms transactional data into strategic insights. This system has been proven to optimize inventory management, promote effective promotional strategies, and provide valid decision-making tools for perfume store management.
Downloads
References
REFRENSI
[1] N. P. Rana, “Understanding dark side of artificial intelligence (AI) integrated business analytics: assessing firm’s operational inefficiency and competitiveness,” Eur. J. Inf. Syst., vol. 31, no. 3, pp. 364–387, 2022, doi: 10.1080/0960085X.2021.1955628.
[2] S. M. C. Loureiro, “Artificial intelligence in business: State of the art and future research agenda,” J. Bus. Res., vol. 129, pp. 911–926, 2021, doi: 10.1016/j.jbusres.2020.11.001.
[3] Y. Park, “The role of business intelligence and communication technologies in organizational agility: A configurational approach,” J. Assoc. Inf. Syst., vol. 18, no. 9, pp. 648–686, 2017, doi: 10.17705/1jais.00001.
[4] E. Y. Klein, “Assessment of WHO antibiotic consumption and access targets in 76 countries, 2000–15: an analysis of pharmaceutical sales data,” Lancet Infect. Dis., vol. 21, no. 1, pp. 107–115, 2021, doi: 10.1016/S1473-3099(20)30332-7.
[5] Y. Ensafi, “Time-series forecasting of seasonal items sales using machine learning – A comparative analysis,” Int. J. Inf. Manag. Data Insights, vol. 2, no. 1, 2022, doi: 10.1016/j.jjimei.2022.100058.
[6] Y. Hsia, “Consumption of oral antibiotic formulations for young children according to the WHO Access, Watch, Reserve (AWaRe) antibiotic groups: an analysis of sales data from 70 middle-income and high-income countries,” Lancet Infect. Dis., vol. 19, no. 1, pp. 67–75, 2019, doi: 10.1016/S1473-3099(18)30547-4.
[7] F. P. E. Putra, S. M. Dewi, Maugfiroh, and A. Hamzah, “Privasi dan Keamanan Penerapan IoT Dalam Kehidupan Sehari-Hari : Tantangan dan Implikasi,” 2023. [Online]. Available: https://jsisfotek.org/index.php/JSisfotek/article/view/232
[8] B. Zhu, “Generation Y consumer online repurchase intention in Bangkok: Based on Stimulus-Organism-Response (SOR) model,” Int. J. Retail Distrib. Manag., vol. 48, no. 1, pp. 53–69, 2020, doi: 10.1108/IJRDM-04-2018-0071.
[9] R. Zheng, “How customer engagement in the live-streaming affects purchase intention and customer acquisition, E-tailer’s perspective,” J. Retail. Consum. Serv., vol. 68, 2022, doi: 10.1016/j.jretconser.2022.103015.
[10] Z. P. Fan, “Product sales forecasting using online reviews and historical sales data: A method combining the Bass model and sentiment analysis,” J. Bus. Res., vol. 74, pp. 90–100, 2017, doi: 10.1016/j.jbusres.2017.01.010.
[11] A. Nandi, “Global antibiotic use during the COVID-19 pandemic: analysis of pharmaceutical sales data from 71 countries, 2020–2022,” Eclinicalmedicine, vol. 57, 2023, doi: 10.1016/j.eclinm.2023.101848.
[12] Z. A. Khan, S. Amjad, F. Ahmed, A. M. Almasoud, M. Imran, and N. Javaid, “A Blockchain-Based Deep-Learning-Driven Architecture for Quality Routing in Wireless Sensor Networks,” IEEE Access, vol. 11, pp. 31036–31051, 2023, doi: 10.1109/ACCESS.2023.3259982.
[13] G. Sun, Y. Chen, J. Huang, Q. Ma, and Y. Ge, “Digital Surface Model Super-Resolution by Integrating High-Resolution Remote Sensing Imagery Using Generative Adversarial Networks,” IEEE J. Sel. Top. Appl. Earth Obs. Remote Sens., vol. 17, pp. 10636–10647, 2024, doi: 10.1109/JSTARS.2024.3399544.
[14] B. Tahir, A. Jolfaei, and M. Tariq, “A Novel Experience-Driven and Federated Intelligent Threat-Defense Framework in IoMT,” IEEE J. Biomed. Heal. Informatics, vol. 29, no. 4, pp. 2345–2352, 2023, doi: 10.1109/JBHI.2023.3236072.
[15] E. Reynard, “Integrated Approach for the Inventory and Management of Geomorphological Heritage at the Regional Scale,” Geoheritage, vol. 8, no. 1, pp. 43–60, 2016, doi: 10.1007/s12371-015-0153-0.
[16] S. Tiwari, “Sustainable inventory management with deteriorating and imperfect quality items considering carbon emission,” J. Clean. Prod., vol. 192, pp. 281–292, 2018, doi: 10.1016/j.jclepro.2018.04.261.
[17] S. A. Yang, “Trade credit, risk sharing, and inventory financing portfolios,” Manage. Sci., vol. 64, no. 8, pp. 3667–3689, 2018, doi: 10.1287/mnsc.2017.2799.
[18] M. Feng, “Does ineffective internal control over financial reporting affect a firm’s operations? Evidence from firms’ inventory management,” Account. Rev., vol. 90, no. 2, pp. 529–557, 2015, doi: 10.2308/accr-50909.
[19] U. Mishra, “Optimum sustainable inventory management with backorder and deterioration under controllable carbon emissions,” J. Clean. Prod., vol. 279, 2021, doi: 10.1016/j.jclepro.2020.123699.
[20] T. M. Fernández-Caramés, “Towards an Autonomous Industry 4.0 Warehouse: A UAV and Blockchain-Based System for Inventory and Traceability Applications in Big Data-Driven Supply Chain Management,” Sensors Basel Switz., vol. 19, no. 10, 2019, doi: 10.3390/s19102394.
[21] L. Lee, “The impact of consumers’ perceptions regarding the ethics of online retailers and promotional strategy on their repurchase intention,” Int. J. Inf. Manage., vol. 57, 2021, doi: 10.1016/j.ijinfomgt.2020.102264.
[22] N. N. K. Yasa, “The role of competitive advantage in mediating the effect of promotional strategy on marketing performance,” Manag. Sci. Lett., vol. 10, no. 12, pp. 2845–2848, 2020, doi: 10.5267/j.msl.2020.4.024.
[23] P. Chen, “Promotional pricing and online business model choice in the presence of retail competition,” Omega United Kingdom, vol. 94, 2020, doi: 10.1016/j.omega.2019.07.001.
[24] K. Kuru, “MetaOmniCity: Toward Immersive Urban Metaverse Cyberspaces Using Smart City Digital Twins,” IEEE Access, vol. 11, pp. 43844–43868, 2023, doi: 10.1109/ACCESS.2023.3272890.
[25] G. Moreira, M. Hosseini, M. N. Alam Nipu, M. Lage, N. Ferreira, and F. Miranda, “The Urban Toolkit: A Grammar-Based Framework for Urban Visual Analytics,” IEEE Trans. Vis. Comput. Graph., vol. 30, no. 1, pp. 1402–1412, 2024, doi: 10.1109/TVCG.2023.3326598.
[26] A. Garcia-Requejo, M. Carmen Perez-Rubio, J. M. Villadangos, and A. Hernandez, “Activity Monitoring and Location Sensory System for People With Mild Cognitive Impairments,” IEEE Sens. J., vol. 23, no. 5, pp. 5448–5458, 2023, doi: 10.1109/JSEN.2023.3239980.
[27] H. Xu et al., “Smart Mobility in the Cloud: Enabling Real-Time Situational Awareness and Cyber-Physical Control Through a Digital Twin for Traffic,” IEEE Trans. Intell. Transp. Syst., vol. 24, no. 3, pp. 3145–3156, 2023, doi: 10.1109/TITS.2022.3226746.
[28] F. P. Eka Putra, Amir Hamzah, W. Agel, and R. O. Firmansyah Kusuma, “Impelementasi Sistem Keamanan Jaringan Mikrotik Menggunakan Firewall Filtering dan Port Knocking,” J. Sistim Inf. dan Teknol., pp. 82–87, 2024, doi: 10.60083/jsisfotek.v5i4.329.
[29] Z. Wang, “Business Innovation based on artificial intelligence and Blockchain technology,” Inf. Process. Manag., vol. 59, no. 1, 2022, doi: 10.1016/j.ipm.2021.102759.
[30] A. Kaplan, “Rulers of the world, unite! The challenges and opportunities of artificial intelligence,” Bus. Horiz., vol. 63, no. 1, pp. 37–50, 2020, doi: 10.1016/j.bushor.2019.09.003.
[31] A. R. Al-Ali, “A smart home energy management system using IoT and big data analytics approach,” IEEE Trans. Consum. Electron., vol. 63, no. 4, pp. 426–434, 2017, doi: 10.1109/TCE.2017.015014.
[32] F. P. Eka Putra, F. Muslim, N. Hasanah, Holipah, R. Paradina, and R. Alim, “Analisis Komparasi Protokol Websocket dan MQTT Dalam Proses Push Notification,” J. Sistim Inf. dan Teknol., pp. 63–72, 2024, doi: 10.60083/jsisfotek.v5i4.325.
[33] Y. Sheng, “Rh promotional effects on Pt–Rh alloy catalysts for chemoselective hydrogenation of nitrobenzene to p-aminophenol,” Chem. Eng. J., vol. 452, 2023, doi: 10.1016/j.cej.2022.139448.
[34] S. Ebrahimi, “Proposing a delay in payment contract for coordinating a two-echelon periodic review supply chain with stochastic promotional effort dependent demand,” Int. J. Mach. Learn. Cybern., vol. 10, no. 5, pp. 1037–1050, 2019, doi: 10.1007/s13042-017-0781-6.
[35] W. Cai et al., “A Novel Hyperspectral Image Classification Model Using Bole Convolution With Three-Direction Attention Mechanism: Small Sample and Unbalanced Learning,” IEEE Trans. Geosci. Remote Sens., vol. 61, 2023, doi: 10.1109/TGRS.2022.3201056.
[36] M. Gilbert, “Use of get checked online, a comprehensive web-based testing service for sexually transmitted and blood-borne infections,” J. Med. Internet Res., vol. 19, no. 3, 2017, doi: 10.2196/jmir.7097.
[37] D. M. Quaye, “Export promotion programmes and export performance: A study of selected SMEs in the manufacturing sector of Ghana,” Rev. Int. Bus. Strateg., vol. 27, no. 4, pp. 466–483, 2017, doi: 10.1108/RIBS-03-2017-0021.
[38] I. M. Enholm, “Artificial Intelligence and Business Value: a Literature Review,” Inf. Syst. Front., vol. 24, no. 5, pp. 1709–1734, 2022, doi: 10.1007/s10796-021-10186-w.
[39] E. Dong, “An interactive web-based dashboard to track COVID-19 in real time,” 2020. doi: 10.1016/S1473-3099(20)30120-1.
[40] L. Adreani, P. Bellini, M. Fanfani, P. Nesi, and G. Pantaleo, “Smart City Digital Twin Framework for Real-Time Multi-Data Integration and Wide Public Distribution,” IEEE Access, vol. 12, pp. 76277–76303, 2024, doi: 10.1109/ACCESS.2024.3406795.
[41] M. Mariani, “Business intelligence and big data in hospitality and tourism: a systematic literature review,” 2018. doi: 10.1108/IJCHM-07-2017-0461.
[42] K. Wang, “A comprehensive emission inventory of multiple air pollutants from iron and steel industry in China: Temporal trends and spatial variation characteristics,” Sci. Total Environ., vol. 559, pp. 7–14, 2016, doi: 10.1016/j.scitotenv.2016.03.125.
[43] A. Hiassat, “A genetic algorithm approach for location-inventory-routing problem with perishable products,” J. Manuf. Syst., vol. 42, pp. 93–103, 2017, doi: 10.1016/j.jmsy.2016.10.004.
[44] T. Wu, S. Gorbachev, H. K. Lam, J. H. Park, L. Xiong, and J. Cao, “Adaptive Event-Triggered Space-Time Sampled-Data Synchronization for Fuzzy Coupled RDNNs Under Hybrid Random Cyberattacks,” IEEE Trans. Fuzzy Syst., vol. 31, no. 6, pp. 1855–1869, 2023, doi: 10.1109/TFUZZ.2022.3215747.
[45] X. Hu, “Promotional role of nano TiO2 for pomegranate-like SnS2@C spheres toward enhanced sodium ion storage,” Chem. Eng. J., vol. 363, pp. 213–223, 2019, doi: 10.1016/j.cej.2019.01.130.
[46] F. Prasetyo Eka Putra, Moh Riski, Riyan, Yayu Rahma Febriani, and Muhammad Umar Mansyur, “Optimization Of Web Based Academic Information System Design To Increase Efficiency In Junior High Schools,” J. Inf. dan Teknol., pp. 150–158, 2024, doi: 10.60083/jidt.v6i2.545.
[47] F. Prasetyo Eka Putra, S. Mellyana Dewi, and A. Hamzah, “Jurnal Sistim Informasi dan Teknologi https://jsisfotek.org/index.php Privasi dan Keamanan Penerapan IoT Dalam Kehidupan Sehari-Hari : Tantangan dan Implikasi,” J. Sistim Inf. Dan …, vol. 5, no. 2, pp. 26–32, 2023, [Online]. Available: https://jsisfotek.org/index.php
[48] F. P. Eka Putra, F. I. Maulana, N. M. Akbar, and W. Febriantoro, “Twitter sentiment analysis about economic recession in indonesia,” Bull. Soc. Informatics Theory Appl., vol. 7, no. 1, pp. 1–7, 2023, doi: 10.31763/businta.v7i1.592.
[49] F. Prasetyo, E. Putra, M. Riski, M. S. Yahya, and M. H. Ramadhan, “Mengenal Teknologi Jaringan Nirkabel Terbaru Teknologi 5G,” J. Sistim Inf. dan Teknol., vol. 5, no. 2, pp. 167–174, 2023, [Online]. Available: https://jsisfotek.org/index.php
[50] A. Zulfikri, F. P. E. Putra, M. A. Huda, H. Hasbullah, M. Mahendra, and M. Surur, “Analisis Keamanan Jaringan Dari Serangan Malware Menggunakan Filtering Firewall Dengan Port Blocking,” 2023. doi: 10.47709/digitech.v3i2.3379.
[51] Q. Cong, “Promotional effect of nitrogen-doping on a ceria unary oxide catalyst with rich oxygen vacancies for selective catalytic reduction of NO with NH3,” Chem. Eng. J., vol. 379, 2020, doi: 10.1016/j.cej.2019.122302.
[52] F. P. Eka Putra, M. N. Arifin, K. Zulfana Imam, E. Saputra, and Sofiyullah, “Pengembangan Sistem Informasi Laboratorium Terintegerasi Sistem Akademik Menggunakan Agile Scrum,” J. Inf. dan Teknol., pp. 109–119, 2023, doi: 10.37034/jidt.v5i2.367.
[53] F. P. E. Putra, U. Ubaidi, R. N. Saputra, F. M. Haris, and S. N. R. Barokah, “Application of Internet of Things Technology in Monitoring Water Quality in Fishponds,” 2024. doi: 10.47709/brilliance.v4i1.4231.
[54] F. P. E. Putra, U. Ubaidi, A. Zulfikri, G. Arifin, and R. M. Ilhamsyah, “Analysis of Phishing Attack Trends, Impacts and Prevention Methods: Literature Study,” 2024, pdfs.semanticscholar.org. doi: 10.47709/brilliance.v4i1.4357.
[55] F. P. E. Putra, F. Fauzan, S. Syirofi, M. Mursidi, D. Wahid, and A. Nuraini, “Sistem Pengendali Lingkungan Pertanian Dengan Wireless Sensor Network Untuk Mengoptimalkan Budidaya Hidroponik,” 2024. doi: 10.47709/digitech.v3i2.3461.
[56] M. Van Den Ende, I. Lior, J. P. Ampuero, A. Sladen, A. Ferrari, and C. Richard, “A Self-Supervised Deep Learning Approach for Blind Denoising and Waveform Coherence Enhancement in Distributed Acoustic Sensing Data,” IEEE Trans. Neural Networks Learn. Syst., vol. 34, no. 7, pp. 3371–3384, 2023, doi: 10.1109/TNNLS.2021.3132832.
[57] Q. Li, H. Huang, W. Yu, and S. Jiang, “Optimized Views Photogrammetry: Precision Analysis and a Large-Scale Case Study in Qingdao,” IEEE J. Sel. Top. Appl. Earth Obs. Remote Sens., vol. 16, pp. 1144–1159, 2023, doi: 10.1109/JSTARS.2022.3233359.
[58] J. Yin, X. Ren, S. Su, F. Yan, and T. Tao, “Resilience-Oriented Train Rescheduling Optimization in Railway Networks: A Mixed Integer Programming Approach,” IEEE Trans. Intell. Transp. Syst., vol. 24, no. 5, pp. 4948–4961, 2023, doi: 10.1109/TITS.2023.3236004.
[59] H. Wang, “Knowledge graph convolutional networks for recommender systems,” 2019. doi: 10.1145/3308558.3313417.
[60] S. Arifin, N. P. Dewi, . U., M. N. Arifin, and F. P. E. Putra, “Aplikasi Pengolahan Data Mahasiswa Kkn Pada Universitas Madura,” Insa. Comtech Inf. Sci. Comput. Technol. J., vol. 8, no. 2, p. 24, 2023, doi: 10.53712/jic.v8i2.2085.
[61] F. P. E. Putra, U. Ubaidi, A. Hamzah, W. A. Pramadi, and A. Nuraini, “Systematic Literature Review: Security Gap Detection On Websites Using Owasp Zap,” 2024. doi: 10.47709/brilliance.v4i1.4227.
[62] N. Muhammad Akbar, F. Prasetyo Eka Putra, K. Zulfana Imam, and M. Umar Mansyur, “Analisis Kinerja dan Interopabilitas STB Sebagai Server Penilaian Akhir Tahun,” J. Inf. dan Teknol., pp. 91–96, 2023, doi: 10.37034/jidt.v5i2.365.
[63] F. P. Eka Putra, M. N. Arifin, K. Zulfana Imam, E. Saputra, and Sofiyullah, “Pengembangan Sistem Informasi Laboratorium Terintegerasi Sistem Akademik Menggunakan Agile Scrum,” J. Inf. dan Teknol., pp. 109–119, 2023, doi: 10.37034/jidt.v5i2.367.
[64] F. P. E. Putra, M. A. Mahmud, and ..., “Pengembangan Sistem Pemantauan Lingkungan Berbasis Internet of Things (IoT) di Kampus,” 2023, researchgate.net. [Online]. Available: https://jurnal.itscience.org/index.php/digitech/article/view/3457
[65] A. Baidawi, “JARINGAN SENSOR NIRKABEL DAN IoT UNTUK KOTA PINTAR PAMEKASAN,” J. Sist. Inf. Kaputama, vol. 7, no. 2, pp. 104–110, 2023, doi: 10.59697/jsik.v7i2.108.
[66] F. P. E. Putra, K. Mufidah, R. M. Ilhamsyah, S. A. Efendy, and S. N. R. Barokah, “Tinjauan Performa RouterOS Mikrotik dalam Jaringan Internet: Analisis Kinerja dan Kelayakan,” 2024. doi: 10.47709/digitech.v3i2.3446.
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Akmal, Fahmi Abdillah (Penulis)
This work is licensed under a Creative Commons Attribution 4.0 International License.
