Integrating Forecast Models into Business Intelligence Solutions: A Case Study on Retail Dataset

Authors

  • Nguyen Phat Dat Trường Đại học Kinh tế - Luật, Đại học Quốc gia TP. Hồ Chí Minh Author
  • Nguyen Van Ho Trường Đại học Kinh tế - Luật, Đại học Quốc gia TP. Hồ Chí Minh Author
  • Le Ba Thien Trường Đại học Kinh tế - Luật, Đại học Quốc gia TP. Hồ Chí Minh Author
  • Trinh Thu Huyen Trang Trường Đại học Kinh tế - Luật, Đại học Quốc gia TP. Hồ Chí Minh Author
  • Lam Thi Hoang Anh Đại học Kinh tế Thành phố Hồ Chí Minh Author

DOI:

https://doi.org/10.24311/jabes/2023.34.5.4

Keywords:

Forecast Model, Retail Dataset, Management Information System, Support Decision-making, Business Intelligence, Data Analysis

Abstract

Business Intelligence (BI) is a collection of solutions for collecting, managing, and exploiting data to support decision-making in enterprises. In recent years, this solution is gradually becoming popular and applied by many businesses based on the “accumulation” of data over time. However, current business intelligence solutions are restricted to descriptive statistics, the use of forecasting models are still limited due to the complexity of integration, cost, as well as specialized capacity. subjects related to machine learning models. Since then, this study has formed a solution to integrate predictive models into business intelligence solutions, experimenting on retail data sets, and focusing on small and medium-sized companies to optimize costs and ease. deployment. The results from the study have four main contributions, including (1) Helping administrators to structure, arrange and organize data according to Business Functions; (2) Helping administrators have an overview of the operation of the business from detailed to overview; (3) Helping managers make the right decisions, business strategies, quickly, timely and accurately; (4) Helping administrators easily integrate predictive models into business intelligence solutions. This solution is completely suitable and can be applied to businesses with sales data tracking.

References

Bordeleau, F.-E., Mosconi, E., de Santa-Eulalia, L. A. (2020). Business intelligence and analytics value creation in industry 4.0: A multiple case study in manufacturing medium enterprises. Production Planning & Control, 31(2–3), 173–185.

Chatfield, C. (1996). Simple descriptive techniques. In The Analysis of Time Series (5th ed.) (pp. 9–15). London: Chapman & Hall.

Castelo-Branco, F., Reis, J. L., Vieira, J. C., & Cayolla, R. (2020). Business intelligence and data mining to support sales in retail. In Rocha, Á., Reis, J., Peter, M., Bogdanović, Z. (eds), Marketing and Smart Technologies. Smart Innovation, Systems and Technologies (vol. 167). Singapore: Springer.

Elena, C. (2011). Business intelligence. Journal of Knowledge Management, Economics and Information Technology, 1(2), 1–12.

Fildes, R., Ma, S., & Kolassa, S. (2022). Retail forecasting: Research and practice. International Journal of Forecasting, 38(4), 1283–1318. doi: 10.1016/j.ijforecast.2019.06.004

Gang, T., Kai, C., & Bei, S. (2008). The research & application of Business Intelligence system in retail industry. IEEE International Conference on Automation and Logistics (pp. 87–91), 01–03 September, 2008, Qingdao.

Ghadge, A., Bag, S., Goswami, M., & Tiwari, M. K. (2021). Mitigating demand risk of durable goods in online retailing. International Journal of Retail & Distribution Management, 49(2), 165–186. doi: 10.1108/IJRDM-04-2020-0127

Montgomery, D. C., Jennings, C. L., & Kulahci, M. (2015). Introduction to Time Series Analysis and Forecasting. Canada: John Wiley & Sons, Inc.

Nguyễn Quang Dong, & Nguyễn Thị Minh. (2015). Giáo trình Kinh tế lượng. Hà Nội: Trường Đại học Kinh tế Quốc dân.

Nguyễn Thị Thu Phương, & Hồ Trung Thành. (2020). Giải pháp hệ quản trị thông minh và hỗ trợ ra quyết định trong kế toán quản trị. Tạp chí Khoa học Đại học Mở Thành phố Hồ Chí Minh, 15(1), 142–157.

Nguyễn Trọng Hoài, Phùng Thanh Bình, & Nguyễn Khánh Duy. (2009). Dự Báo và Phân Tích Dữ Liệu trong Kinh Tế và Tài Chính. TP.HCM: Trường Đại học Kinh tế TP.HCM.

Isik, O., Jones, M. C., & Sidorova, A. (2011). Business Intelligence (BI) success and the role of BI capabilities. Intelligent Systems in Accounting, Finance and Management, 18(4), 161–176.

Phung, T. K., & Hai, D. P. (2019). Assessing the organizational readiness for implementing BI systems in ERP environment. VNUHCM Journal of Economics, Business and Law, 3(1), 58–67.

Sapo. (2021). BI là gì? 8 "siêu lợi ích" mà BI đem lại cho doanh nghiệp. Truy cập ngày 29/12/2021, từ https://www.sapo.vn/blog/bi-la-gi

Sato, A., & Huang, R. (2015). From data to knowledge: A cognitive approach to retail business intelligence. International Conference on Data Science and Data Intensive Systems, 11–13 December, 2015, Sydney, NSW, Australia. doi: 10.1109/DSDIS.2015.106

Tutunea, M. F., & Rus, R. V. (2012). Business intelligence solutions for SMEs. Procedia Economics and Finance, 3, 865–870.

Vugec, D. S., Vukšić, V. B., Bach, M. P., Jaklič, J., & Štemberger, M. I. (2020). Business intelligence and organizational performance: The role of alignment with business process management. Business Process Management Journal, 26(6), 1709–1730. doi: 10.1108/BPMJ-08-2019-0342

Vercellis, C. (2009). Business Intelligence: Data Mining and Optimization for Decision Making. Canada: Wiley.

Wang, G., Gunasekaran, A., Ngai, E. W. T., & Papadopoulos, T. (2016). Big data analytics in logistics and supply chain management: Certain investigations for research and applications. International Journal of Production Economics, 176, 98–110. doi: 10.1016/j.ijpe.2016.03.014

Wooldridge, J. (2015). Introductory Econometrics: A Modern Approach. USA: South-Western, Cengage Learning.

Published

2023-04-27

Issue

Section

Articles

How to Cite

Nguyen Phat , D., Nguyen Van , H., Le Ba, T., Trinh Thu Huyen , T., & Lam Thi Hoang , A. (2023). Integrating Forecast Models into Business Intelligence Solutions: A Case Study on Retail Dataset. JOURNAL OF ASIAN BUSINESS AND ECONOMIC STUDIES, 34(5), 81–99. https://doi.org/10.24311/jabes/2023.34.5.4