Designing an analytics dashboard for knowledge extraction in the retail industry using descriptive and predictive analytics

Muhammad Aldyan Ruansyah, M Zaky Hadi, Muhammad Iqbal, Juniwati Juniwati, Lina Aulia

Abstract


With the rise of digitalization and data growth, many business sectors are increasingly focused on data. As a result, developing a descriptive and predictive analytics dashboard is essential for extracting insights from complex datasets and supporting decision-making. This study addresses data analytics challenges in the retail industry by designing a dashboard system for analyzing and visualizing data. It also proposes future predictions for customer analytics, simplifying the interpretation of results from complex datasets obtained through business activities in the retail supply chain. These processes have implications for decision-making in areas such as customer segmentation, demographic analysis, and sales performance. The dashboard design includes a pre-processing stage for retail industry datasets and the creation of descriptive and predictive analytics models using clustering methods. It also simulates the development of these models into a comprehensive dashboard. The primary analysis employs the K-Means algorithm for RFM (Recency, Frequency, Monetary) analytics, customer segmentation, and demographic analysis. Results show that the use of this dashboard enhances the visualization of data, supporting decision-making processes related to marketing strategies, sales performance, and inventory management. By applying advanced analytic techniques to marketing strategies, supply chain management, and inventory planning, retail businesses can optimize their operations. This optimization is achieved through better data analytics tools.

Keywords


Big Data Analytics; Descriptive Analytics; Knowledge Extraction; Predictive Analytics; Retail Industry

Full Text:

PDF

References


Shopify Plus, “Commerce Trends 2023: Industry Report,” 2023.

Global Base Sourcing Limited, “2023 Statistics, Trends, and Forecasts for the Retail Industry,” https://globalbasesourcing.com/2023-retail-industry-statistics-trends-forecasts.

P. C. Verhoef, P. K. Kannan, and J. J. Inman, “From Multi-Channel Retailing to Omni-Channel Retailing. Introduction to the Special Issue on Multi-Channel Retailing.,” Journal of Retailing, vol. 91, no. 2, 2015, doi: 10.1016/j.jretai.2015.02.005.

H. Chen, R. H. L. Chiang, and V. C. Storey, “Business intelligence and analytics: From big data to big impact,” MIS Q, vol. 36, no. 4, 2012, doi: 10.2307/41703503.

S. F. Wamba, A. Gunasekaran, S. Akter, S. J. fan Ren, R. Dubey, and S. J. Childe, “Big data analytics and firm performance: Effects of dynamic capabilities,” J Bus Res, vol. 70, 2017, doi: 10.1016/j.jbusres.2016.08.009.

A. Frederiksen, “Competing on analytics: The new science of winning,” Total Quality Management & Business Excellence, vol. 20, no. 5, 2009, doi: 10.1080/14783360902925454.

R. Bose, “Advanced analytics: opportunities and challenges,” Industrial Management & Data Systems, vol. 109, no. 2, 2009, doi: 10.1108/02635570910930073.

O. Kwon, N. Lee, and B. Shin, “Data quality management, data usage experience and acquisition intention of big data analytics,” Int J Inf Manage, vol. 34, no. 3, 2014, doi: 10.1016/j.ijinfomgt.2014.02.002.

U. Sivarajah, M. M. Kamal, Z. Irani, and V. Weerakkody, “Critical analysis of Big Data challenges and analytical methods,” J Bus Res, vol. 70, 2017, doi: 10.1016/j.jbusres.2016.08.001.

H. V. Jagadish, “Big Data and Science: Myths and Reality,” 2015. doi: 10.1016/j.bdr.2015.01.005.

S. Fosso Wamba, S. Akter, A. Edwards, G. Chopin, and D. Gnanzou, “How ‘big data’ can make big impact: Findings from a systematic review and a longitudinal case study,” Int J Prod Econ, vol. 165, 2015, doi: 10.1016/j.ijpe.2014.12.031.

M. T. Sembiring, K. Adhinata, D. Wahyuni, and M. Z. Hadi, “Determining Kansei Words in Chocolate Product Development Model Design Based on Social Media Trend by Using Key Element Extraction (KEE) Algorithm,” in IOP Conference Series: Materials Science and Engineering, 2019. doi: 10.1088/1757-899X/505/1/012031.

M. Z. Hadi, T. Djatna, and Sugiarto, “A modeling of dynamic storage assignment for order picking in beverage warehousing with Drive-in Rack system,” in IOP Conference Series: Materials Science and Engineering, 2018. doi: 10.1088/1757-899X/337/1/012020.

M. Z. Hadi, “Peluang Implementasi Teknologi Big Data Dan Block Chain Untuk Peningkatan Kinerja Perdagangan Pada Sektor UMKM di Indonesia Pada Era Industri 4.0,” Cendekia Niaga, vol. 3, no. 1, 2020, doi: 10.52391/jcn.v3i1.463.

F. Chaffey, D., & Ellis-Chadwick, “Digital Marketing: Strategy, Implementation and practice (6th ed.),” International Journal of Business and Economic Affairs, vol. 6, no. 2, 2016.

D. R. Heath, “Prediction machines: the simple economics of artificial intelligence,” Journal of Information Technology Case and Application Research, vol. 21, no. 3–4, 2019, doi: 10.1080/15228053.2019.1673511.

J. Manyika, M. Chui Brown, B. B. J., R. Dobbs, C. Roxburgh, and A. Hung Byers, “Big data: The next frontier for innovation, competition and productivity,” McKinsey Global Institute, no. June, 2011.

Z. Chen, J. Zhao, and C. Jin, “Business intelligence for Industry 4.0: predictive models for retail and distribution,” International Journal of Retail and Distribution Management, 2023, doi: 10.1108/IJRDM-02-2023-0101.

J. Tian, Y. Zhang, and C. Zhang, “Predicting consumer variety-seeking through weather data analytics,” Electron Commer Res Appl, vol. 28, 2018, doi: 10.1016/j.elerap.2018.02.001.

H. N. Dai, H. Wang, G. Xu, J. Wan, and M. Imran, “Big data analytics for manufacturing internet of things: opportunities, challenges and enabling technologies,” Enterp Inf Syst, vol. 14, no. 9–10, 2020, doi: 10.1080/17517575.2019.1633689.

F. Xia, L. Akoglu, C. Aggarwal, and H. Liu, “Deep Anomaly Analytics: Advancing the Frontier of Anomaly Detection,” 2023. doi: 10.1109/MIS.2023.3255590.

S. Kumar, A. K. Kar, and P. V. Ilavarasan, “Applications of text mining in services management: A systematic literature review,” 2021. doi: 10.1016/j.jjimei.2021.100008.

S. Pratap, S. K. Jauhar, A. Gunasekaran, and S. S. Kamble, “Optimizing the IoT and big data embedded smart supply chains for sustainable performance,” 2024. doi: 10.1016/j.cie.2023.109828.

A. V. Rao and P. Shalini, “Leveraging big data and IOT for retail,” Indian J Econ Dev, vol. 4, no. 3, 2016.

K. Chaudhary and M. Alam, Big Data Analytics: Digital Marketing and Decision-Making. 2022. doi: 10.1201/9781003307761.

K. Chaudhary and M. Alam, Big Data Analytics; Applications in Business and Marketing, vol. 1, no. 1. 2022.

M Zaky Hadi, Ari Hasudungan Pratama Pasaribu, Fatin Saffanah Didin, and Lina Aulia, “A design of cross-selling products based on frequent itemset mining for coffee shop business,” TEKNOSAINS : Jurnal Sains, Teknologi dan Informatika, vol. 11, no. 2, pp. 286–297, Jul. 2024, doi: 10.37373/tekno.v11i2.1065.

B. Arshdeep, Big Data Analytics: A Hands-On Approach, vol. 21, no. 8. 2019.

Y. Shi, Advances in Big Data Analytics: Theory, Algorithms and Practices. 2022. doi: 10.1007/978-981-16-3607-3.

SHAHZAD ASLAM, “Consumer Behavior and Shopping Habits Dataset: E-Commerce Transaction Trends: A Comprehensive Dataset,” https://www.kaggle.com/datasets/zeesolver/consumer-behavior-and-shopping-habits-dataset.

G. Shmueli, P. C. Bruce, P. Gedeck, and N. R. Patel, Data Mining for Business Analytics. Concepts, Techniques and Applications in Python. 2020.

R. Sharda, D. Delen, and E. Turban, Business Intelligence, Analytics, and Data Science A Managerial Perspective. 2018.

M. J. Zaki and W. J. Meira, Data Mining and Machine Learning Fundamental Concepts and Algorithms, vol. 53, no. 9. 2020.




DOI: http://dx.doi.org/10.62870/jiss.v10i2.27900

Refbacks

  • There are currently no refbacks.


  is supported by