Ad-Hoc Business Intelligence for Agile Decision-Making: A Case Study Using Adventure Works 2022

Zuli Maulidati, Satrio Bagas Pangestu, Salma Nur Aini

Abstract

Agile decision-making in today's business is highly crucial for an organisation to stay competitive. Business intelligence has overcome the situation to provide solutions in any crucial condition. Unlike the static dashboard, the ad hoc dashboard is considered to be a viable solution in tailoring business to make a data-driven decision with a high flexibility. This study aims to examine and implement ad-hoc dashboards using the Adventure Works 2022 dataset. The result of the study shows that both dashboards implement interactive filtering, drill-down capabilities, and real-time visualization to enhance data-driven decision-making agility. The design of dashboard A provides a structured, multi-dimensional view suitable for in-depth analysis; meanwhile, dashboard B prioritises simplicity and accessibility, presenting key insights intuitively for quick decision-making. Furthermore, the study highlights the result that the biggest challenges of building a dashboard are information overload and usability. It is important to note that the implementation of ad-hoc BI should balance between analytical capabilities and user-friendliness to ensure that dashboards provide meaningful insights and are easy to use by end users.

Keywords: Ad-hoc BI, Agile Decision Making, BI Dashboard

Full Text:

PDF

References

Abduldaem, A., & Gravell, A. (2019). PRINCIPLES FOR THE DESIGN AND DEVELOPMENT OF DASHBOARDS: LITERATURE REVIEW.

Berthold, H., Rösch, P., Zöller, S., Wortmann, F., Carenini, A., & Campbell, S. (2012). Towards Ad-Hoc and Collaborative Business Intelligence. In Business Intelligence Applications and the Web: Models, Systems and Technologies (pp. 266–284). IGI Global Scientific Publishing. https://doi.org/10.4018/978-1-61350-038-5.ch012

Bhagyashree. (2024, August 22). How to Derive Data-Driven Insights for Agile Decisions? PromptCloud. https://www.promptcloud.com/blog/data-driven-insights-for-agile-decision-making/

Capital, F. (2024). Agility in Decision making: The Key to Effective Business Strategy. FasterCapital. https://fastercapital.com/content/Agility-in-Decision-making--The-Key-to-Effective-Business-Strategy.html

Chu, M. K., & Yong, K. O. (2021). Big Data Analytics for Business Intelligence in Accounting and Audit. Open Journal of Social Sciences, 09(09), 42–52. https://doi.org/10.4236/jss.2021.99004

Dhatchayani, K., Vezhaventhan, D., Sornamugi, P., T, Varsha., S, Priyadharshini., & T, Leha. (2025). Agile Decision-Making Framework using Hybrid Statistical and Predictive Models for Efficient Business Operations. 2025 6th International Conference on Mobile Computing and Sustainable Informatics (ICMCSI), 822–829. https://doi.org/10.1109/ICMCSI64620.2025.10883071

Ghazisaeidi, M., Safdari, R., Torabi, M., Mirzaee, M., Farzi, J., & Goodini, A. (2015). Development of Performance Dashboards in Healthcare Sector: Key Practical Issues. Acta Informatica Medica, 23(5), 317. https://doi.org/10.5455/aim.2015.23.317-321

Hester, P., Ezell, B., Collins, A., Horst, J., & Lawsure, K. (2017). A Method for Key Performance Indicator Assessment in Manufacturing Organizations. International Journal of Operations Research, 14(4), 157–167.

Khatuwal, V. S., & Puri, D. (2022). Business Intelligence Tools for Dashboard Development. 2022 3rd International Conference on Intelligent Engineering and Management (ICIEM), 128–131. https://doi.org/10.1109/ICIEM54221.2022.9853086

Krawatzeck, R., & Dinter, B. (2015). Agile Business Intelligence: Collection and Classification of Agile Business Intelligence Actions by Means of a Catalog and a Selection Guide. Information Systems Management, 32(3), 177–191. https://doi.org/10.1080/10580530.2015.1044336

Krawatzeck, R., Dinter, B., & Pham Thi, D. A. (2015). How to Make Business Intelligence Agile: The Agile BI Actions Catalog. 2015 48th Hawaii International Conference on System Sciences, 4762–4771. https://doi.org/10.1109/HICSS.2015.566

Martins, N., Martins, S., & Brandão, D. (2022). Design Principles in the Development of Dashboards for Business Management. In D. Raposo, J. Neves, & J. Silva (Eds.), Perspectives on Design II (Vol. 16, pp. 353–365). Springer International Publishing. https://doi.org/10.1007/978-3-030-79879-6_26

MashaMSFT. (2024, September 4). AdventureWorks sample databases—SQL Server. https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16

Nookala, G. (2022). Improving Business Intelligence through Agile Data Modeling: A Case Study. Journal of Computational Innovation, 2(1), Article 1. https://researchworkx.com/index.php/jci/article/view/14

O’Hear, E. (2023). THE IMPLICATIONS OF INFORMATION LOAD ON USABILITY AND PERFORMANCE IN DASHBOARDS.

Orlovskyi, D., & Kopp, A. (2020). A Business Intelligence Dashboard Design Approach to Improve Data Analytics and Decision Making.

Rahman, A. A., Adamu, Y. B., & Harun, P. (2017). Review on dashboard application from managerial perspective. 2017 International Conference on Research and Innovation in Information Systems (ICRIIS), 1–5. https://doi.org/10.1109/ICRIIS.2017.8002461

Sarikaya, A., Correll, M., Bartram, L., Tory, M., & Fisher, D. (2019). What Do We Talk About When We Talk About Dashboards? IEEE Transactions on Visualization and Computer Graphics, 25(1), 682–692. https://doi.org/10.1109/TVCG.2018.2864903

Stodder, D. (2015). Visual Analytics for Making Smarter Decisions Faster: Applying Self-Service Business Intelligence Technologies to Data-Driven Objectives.

Tokola, H., Gröger, C., Järvenpää, E., & Niemi, E. (2016). Designing Manufacturing Dashboards on the Basis of a Key Performance Indicator Survey. Procedia CIRP, 57, 619–624. https://doi.org/10.1016/j.procir.2016.11.107

Turban, E., Sharda, R., & Delen, D. (2011). Decision support and business intelligence systems (9th ed). Prentice Hall.

Wang, F. L., Rischmoller, L., Reed, D., & Khanzode4, A. (2018). Ad Hoc Data Analytics and Business Intelligence Service Framework for Construction Projects. 1058–1068. https://doi.org/10.24928/2018/0535

DOI: https://doi.org/10.31284/j.integer.2024.v10i1.7537

Refbacks

  • There are currently no refbacks.