Building SME Resilience through Agile Data Architecture: Integrating Data Vault 2.0 and Business Intelligence for Competitive Advantage
Keywords:
Business Intelligence, Data Vault 2.0, SME Resilience, TAM-TOE ModelAbstract
Purpose: In the wake of global disruptions such as the COVID-19 pandemic, Small and Medium-sized Enterprises (SMEs) face heightened pressure to digitize operations to maintain competitive advantage. This study explores the intersection of advanced data modeling—specifically Data Vault 2.0—and modern Business Intelligence (BI) tools to create a resilient infrastructure for decision-making.
Design/Methodology/Approach: The research utilizes a systematic integrative review, synthesizing literature on Crisis Management, Knowledge Management Systems (KMS), and the TAM-TOE (Technology Acceptance Model and Technology-Organization-Environment) adoption framework. It further analyzes the technical specifications of BI platforms (Tableau, Power BI) and data warehousing methodologies to propose a comprehensive adoption framework.
Findings: The analysis suggests that traditional data warehousing techniques (Star Schemas) often lack the agility required for modern SMEs. The implementation of Data Vault modeling, when coupled with governed BI strategies, significantly correlates with improved Intellectual Capital and operational flexibility. Furthermore, the integration of AI within these BI ecosystems is modulated by organizational readiness and environmental pressures.
Originality/Value: This paper bridges the gap between technical data engineering concepts (ETL, Data Modeling) and strategic management theories (Intellectual Capital, Crisis Resilience), offering a practical roadmap for SMEs to leverage data as a strategic asset rather than a byproduct of operations.
References
Hossain MR, Akhter F, Sultana MM. SMEs in Covid-19 crisis and combating strategies: a systematic literature review (SLR) and a case from emerging economy. Oper Res Perspectives. 2022. https://doi.org/10.1016/j.orp.2022.100222.
Maier R. Knowledge management systems: information and communication technologies for knowledge management. Heidelberg: Springer Berlin; 2007. https://doi.org/10.1007/978-3-540-71408-8.
Chatterjee S, Rana NP, Dwivedi YK, Baabdullah AM. Understanding AI adoption in manufacturing and production firms using an integrated TAM-TOE model. Technol Forecast Soc Chang. 2021;170:120880. https://doi.org/10.1016/J.TECHFORE.2021.120880.
Dadhich M, Hiran KK. Empirical investigation of extended TOE model on corporate environment sustainability and dimensions of operating performance of SMEs: a high order PLS-ANN approach. J Clean Prod. 2022. https://doi.org/10.1016/j.jclepro.2022.132309.
Todericiu R, Stăniţ A. Intellectual capital—the key for sustainable competitive advantage for the SME’s sector. Procedia Econ Finance. 2015;27:676–81. https://doi.org/10.1016/s2212-5671(15)01048-5.
Linstedt, D. Building a Scalable Data Warehouse with Data Vault 2.0, 1st ed.; Morgan Kaufmann: Boston, MA, USA, 2016; ISBN 978-0-128-02648-9.
Vines, A.; Tănăsescu, L. Data Vault Modeling: Insights from Industry Interviews. In Proceedings of the International Conference on Business Excellence, Bucharest, Romania, 21–22 March 2024; Volume 18, pp. 3597–3605. [CrossRef]
El-Sappagh, S.; Hendawi, A.; El-Bastawissy, A. A proposed model for data warehouse ETL processes. J. King Saud Univ.—Comput. Inf. Sci. 2011, 23, 91–104. [CrossRef]
Koupaei, M. N., Mohammadi, M., & Naderi, B. (2016). An integrated enterprise resources planning (erp) framework for flexible manufacturing systems using business intelligence (bi) tools. International Journal of Supply and Operations Management, 3(1), 1112.
Chugh, R., & Grandhi, S. (2013). Why Business Intelligence?: Significance of Business Intelligence Tools and Integrating BI Governance with Corporate Governance. International Journal of E-Entrepreneurship and Innovation (IJEEI), 4(2), 1-14.
Dip Bharatbhai Patel. (2025). Leveraging BI for Competitive Advantage: Case Studies from Tech Giants. Frontiers in Emerging Engineering & Technologies, 2(04), 15–21. Retrieved from https://irjernet.com/index.php/feet/article/view/166
Golfarelli, M. (2009, August). Open source BI platforms: a functional and architectural comparison. In International Conference on Data Warehousing and Knowledge Discovery (pp. 287-297). Springer, Berlin, Heidelberg.
Bocevska, A., Savoska, S., & Milevski, I. (2017). BI Tools Analysis According to Business Criteria as Data Integration Possibilities, Hardware Specification, Tools for Data Visualization and Comparison of Used Technologies.
Carlisle, S. (2018). Software: Tableau and microsoft power bi. Technology| Architecture+ Design, 2(2), 256-259.
Jamaludin, I. A., & Mansor, Z. (2011). Review on Business Intelligence (BI) success determinants in project implementation. International Journal of Computer Applications, 33(8), 24-27.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Dr. A. Sharma
This work is licensed under a Creative Commons Attribution 4.0 International License.
Individual articles are published Open Access under the Creative Commons Licence: CC-BY 4.0.
