Modelling Data Warehousing and Business Intelligence Architecture for Non-profit Organization Based on Data Governances Framework

Adi Suryaputra Paramita, Harjanto Prabowo, Arief Ramadhan, Dana Indra Sensuse
Pages 276-288
Abstract Views 930
PDF Downloads 475
Crossref Citations -
DOI https://doi.org/10.47738/jads.v4i3.117

Abstract


Information systems research for non-profit organizations is an opportunity to make a contribution to the field of information systems, the adoption of information systems in this field is relatively tedious and there are few studies that examine this area; consequently, there are several research gaps in the domain of non-profit organizations that need to be solved. This research will focus on the development of data warehouse architecture and business intelligence for non-profit organizations. In this study, the Soft Systems Methodology (SSM) technique will be employed to develop a data warehouse architecture and business intelligence. This research will interview twenty individuals to collect primary data, review organizational policy documents, and conduct an open-ended survey. The obtained data will then be qualitatively analyzed, resulting in the formation of rich picture diagrams, CATWOE analysis, and conceptual models, which will ultimately form a data warehouse architecture and business intelligence. This research has produced a microservices-enhanced data warehouse architecture and business intelligence for non-profit organizations.

Keywords


Data Warehouse; Business Intelligence; SSM; Non-Profit; Information Systems

Full Text:

PDF

References


M. Q. Miranda, J. S. Farias, C. de Araújo Schwartz, and J. P. L. de Almeida, “Technology adoption in diffusion of innovations perspective: introduction of an ERP system in a non-profit organization,” RAI Rev. Adm. e Inovação, vol. 13, no. 1, pp. 48–57, 2016, doi: 10.1016/j.rai.2016.02.002.

A. Ramadhan et al., “Factors affecting the continuation to use and e-WOM intention of online library resources by university students: A study in Indonesia,” J. Acad. Librariansh., vol. 48, no. 6, p. 102592, 2022, doi: https://doi.org/10.1016/j.acalib.2022.102592.

Y. Lin, “Government management model of non-profit

organizations based on E-government,” ACM Int. Conf. Proceeding Ser., pp. 164–168, 2019, doi: 10.1145/3348445.3348464.

K. Jaskyte, “Exploring Potential for Information Technology Innovation in Nonprofit Organizations,” J. Technol. Hum. Serv., vol. 30, no. 2, pp. 118–127, 2012, doi: 10.1080/15228835.2012.695564.

A. J. Connolly and A. J. Connolly, “Data Analytics as a Conduit for Progressing Information Systems Research in Nonprofit Organizations,” South. Assoc. Inf. Syst. Proceeding, 2017.

T. R. Imboden, “How Are Nonprofit Organizations Influenced To Create and Adopt Information Security Policies?,” Issues Inf. Syst., vol. 14, no. 2, pp. 166–173, 2013, doi: 10.48009/2_iis_2013_166-173.

A. Gregory, “Data governance Protecting and unleashing the value of your customer data assets: Stage 1: Understanding data governance and your current data management capability,” J. Direct, Data Digit. Mark. Pract., vol. 12, no. 3, pp. 230–248, 2011, doi: 10.1057/dddmp.2010.41.

M. Rifaie, R. Alhajj, and M. Ridley, “Data governance strategy: A key issue in building enterprise data warehouse,” iiWAS2009 - 11th Int. Conf. Inf. Integr. Web-based Appl. Serv., pp. 587–591, 2009, doi: 10.1145/1806338.1806449.

A. H. Mousa and N. Shiratuddin, “Data Warehouse and Data Virtualization Comparative Study,” Proc. - 2015 Int. Conf. Dev. eSystems Eng. DeSE 2015, pp. 369–372, 2016, doi: 10.1109/DeSE.2015.26.

A. L. Antunes, E. Cardoso, and J. Barateiro, “Incorporation of Ontologies in Data Warehouse/Business Intelligence Systems - A Systematic Literature Review,” Int. J. Inf. Manag. Data Insights, vol. 2, no. 2, 2022, doi: 10.1016/j.jjimei.2022.100131.

G. Garani, A. V. Chernov, I. K. Savvas, and M. A. Butakova, “A Data Warehouse Approach for Business Intelligence,” Proc. - 2019 IEEE 28th Int. Conf. Enabling Technol. Infrastruct. Collab. Enterp. WETICE 2019, pp. 70–75, 2019, doi: 10.1109/WETICE.2019.00022.

R. D. Thantilage, N.-A. Le-Khac, and M. Kechadi, “Healthcare data security and privacy in Data Warehouse architectures,” Informatics Med. Unlocked, vol. 39, no. May, p. 101270, 2023, doi: 10.1016/j.imu.2023.101270.

Zahabia, T. F. Kusumasari, and R. Fauzi, “Analysis and Design of Data Warehousing and Business Intelligence Guidelines Using DAMA-DMBOKv2,” Proc. - IEIT 2022 2022 Int. Conf. Electr. Inf. Technol., no. 2012, pp. 109–114, 2022, doi: 10.1109/IEIT56384.2022.9967862.

R. L. Lee and M. C. Blouin, “Factors Affecting Web Disclosure Adoption in the Nonprofit Sector,” J. Comput. Inf. Syst., vol. 59, no. 4, pp. 363–372, 2019, doi: 10.1080/08874417.2017.1370988.

R. Heeks, Implementing and Managing eGovernment: An International Text, vol. 24, no. 3. 1 Oliver’s Yard, 55 City Road, London EC1Y 1SP United Kingdom: SAGE Publications Ltd, 2006. doi: 10.4135/9781446220191.

A. G. Ramírez-Gutiérrez, P. P. Cardoso-Castro, and R. Tejeida-Padilla, “A Methodological Proposal for the Complementarity of the SSM and the VSM for the Analysis of Viability in Organizations,” Syst. Pract. Action Res., vol. 34, no. 3, pp. 331–357, Jun. 2021, doi: 10.1007/s11213-020-09536-7.

M. C. Winter, D. H. Brown, and P. B. Checkland, “A role for soft systems methodology in information systems development,” Eur. J. Inf. Syst., vol. 4, no. 3, pp. 130–142, 1995, doi: 10.1057/ejis.1995.17.

A. Ramadhan, A. M. Arymurthy, D. I. Sensuse, and Muladno, “Modeling e-Livestock Indonesia,” Heliyon, vol. 7, no. 8, p. e07754, 2021, doi: 10.1016/j.heliyon.2021.e07754.

R. Françozo, A. Paucar-Caceres, and M. C. N. Belderrain, “Combining Value-Focused thinking and soft systems methodology: A systemic framework to structure the planning process at a special educational needs school in Brazil,” J. Oper. Res. Soc., vol. 0, no. 0, pp. 1–20, 2021, doi: 10.1080/01605682.2021.1880298.

R. Armstrong, “Elaborating a Critical Realist Approach to Soft Systems Methodology,” Syst. Pract. Action Res., vol. 32, no. 4, pp. 463–480, 2019, doi: 10.1007/s11213-018-9466-7.

A. Small and D. Wainwright, “SSM and technology management: Developing multimethodology through practice,” Eur. J. Oper. Res., vol. 233, no. 3, pp. 660–673, 2014, doi: 10.1016/j.ejor.2013.08.049.

H. Augustsson, K. Churruca, and J. Braithwaite, “Change and improvement 50 years in the making: a scoping review of the use of soft systems methodology in healthcare,” BMC Health Serv. Res., vol. 20, no. 1, pp. 1–13, 2020, doi: 10.1186/s12913-020-05929-5.

A. Ramadhan, Muladno, D. I. Sensuse, and A. M. Arymurthy, “e-Livestock in Indonesia: Definition adjustment, expected benefits, and challenges,” 2012 Int. Conf. Adv. Comput. Sci. Inf. Syst. ICACSIS 2012 - Proc., pp. 131–136, 2012.

I. Georgiou, “Unravelling soft systems methodology,” Int. J. Econ. Bus. Res., vol. 9, no. 4, pp. 415–436, 2015, doi: 10.1504/IJEBR.2015.069680.

F. P. Wheeler and P. Checkland, “Systems Thinking, Systems Practice: Includes a 30-Year Retrospective,” J. Oper. Res. Soc., vol. 51, no. 5, p. 647, 2000, doi: 10.2307/254200.

W. Ulrich and M. Reynolds, Critical Systems Heuristics: The Idea and Practice of Boundary Critique. 2020. doi: 10.1007/978-1-4471-7472-1_6.

M. C. Jackson, “Systems Thinking – Creative Holism for Managers,” John wiley Sons, Sep. 2004, doi: 10.1108/k.2004.06733hae.001.

M. Krämer, S. Frese, and A. Kuijper, “Implementing secure applications in smart city clouds using microservices,” Futur. Gener. Comput. Syst., vol. 99, pp. 308–320, 2019, doi: 10.1016/j.future.2019.04.042.

C. Pinheiro, A. Vasconcelos, and S. Guerreiro, “Microservice Architecture from Enterprise Architecture Management Perspective,” Lect. Notes Bus. Inf. Process., vol. 356, pp. 236–245, 2019, doi: 10.1007/978-3-030-24854-3_17.

P. D. S. S. Prof. Dr. Frederik Ahlemann Prof. Dr. Reinhard Schütte, Innovation Through Information Systems, vol. III. 2021. [Online]. Available: http://link.springer.com/book/10.1007/978-3-030-86800-0




DOI: https://doi.org/10.47738/jads.v4i3.117

Refbacks

  • There are currently no refbacks.


Barcode

Journal of Applied Data Sciences

ISSN:2723-6471 (Online)
Publisher:Bright Publisher
Website:http://bright-journal.org/JADS
Email:taqwa@amikompurwokerto.ac.id (principal contact)
  support@bright-journal.org (technical issues)

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0