Abstract
Data analysis is considered as a process of review, debugging, and finally data modeling to obtain additional information, establish conclusions, and make effective decisions. In Ecuador, public health institutions are held responsible for providing appropriate quality care to the public, therefore, timely decisions based on an adequate interpretation of the available massive data are required. Through an experimental and quantitative process developed in the Zonal Health Coordination 3, located in Chimborazo, Ecuador, this article presents a proposal for a data warehouse model supported by ETL processes and in the Hefesto methodology in order to enable an analysis of adequate data that provides the required clean and organized information for a pertinent and timely decision-making in health institutions located in Ecuador. As a result, a data warehouse with organized, clean, and adequate information will allow a refined and efficient analysis of the data to fulfill the objective of this investigation.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Balajee R, Mohapatra H, Deepak V (2021) Requirements identification on automated medical care with appropriate machine learning techniques. In: 2021 6th international conference on inventive computation technologies (ICICT), pp 836–840
Benke K, Benke G (2018) Artificial intelligence and big data in public health. Int J Environ Res Public Health 15(12):2796
Chen Z (2003) Data warehousing and data marts. Encycloped Inf Syst 521–533
Dearborn J, Swanson D (2017) The data driven leader: a powerful approach to delivering measurable bussiness impact through people analytics. Wiley, New York
Djiroun R, Boukhalfa K, Alimazighi Z (2019) Designing data cubes in OLAP systems: a decision makers’ requirements-based approach. Cluster Comput 783–803
Hauger W, Olivier M (2018) Revista de investigación de África SAIEE. From NoSQL databases: forensic attribution implications: http://www.scielo.org.za/scielo.php?script=sci_arttext&pid=S1991-16962018000200003&nrm=iso
Jensen MR, Moller TH, Pedersen TB (2001) Specifying OLAP cubes on XML data. J Intell Inf Syst 255–280
Lakshmi J, Sheshasaayee A (2015) Machine learning approaches on map reduce for big data analytics. In: International conference on green computing and internet of things (ICGCIoT), pp 480–484
López CP (2007) Minería de datos: técnicas y herramientas. Editorial Paraninfo
Mashrur A, Luo W, Zaidi N, Robles K (2020) Machine learning for financial risk management: a survey. IEEE Access 03203–203223
Ministerio de Salud de Colombia (2018, 11 28) Análisis de Situación de Salud (ASIS). From https://www.minsalud.gov.co/: https://www.minsalud.gov.co/salud/publica/epidemiologia/Paginas/analisis-de-situacion-de-salud-.aspx
Molina-Granja F, Rodriguez G (2017) Model for digital evidence preservation in criminal research institutions-PREDECI. Int J Electron Secur Digit Forensics 9(2):150–166
Molina-Granja F, Yánez R, Cabezas E (2016) IT governance—models and application. New Adv Inf Syst Technol 467–480. From https://doi.org/10.1007/978-3-319-31232-3_44
Murray A, Rhymer J, Sirmon D (2020) Humans and technology: forms of conjoined agency in organizations. Acad Manag Rev 43(3):552–571
Nisbet R, Miner G, Yale K (2018) Theoretical considerations for data mining. In: Handbook of statistical analysis and data mining applications, 2nd edn. Academic Press, pp 21–37. ISBN: 9780124166325
Pääkkönen P, Pakkala D (2015) Reference architecture and classification of technologies. Prod Serv Big Data Syst Big Data Res 166–186
Quelch JA, Rodríguez ML (2015) Carolinas healthcare system: consumer analytics. Caso. de Harvard Business School, pp 515–060
Tretter MJ (2003) Data mining. In: Elsevier Encyclopedia of information systems. Hossein Bidgoli, pp 477–488
Weiss S, Indurkhya N (1998) Predictive data mining: a practical guide. Morgan Kaufmann Publishers, San Francisco
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2023 The Author(s), under exclusive license to Springer Nature Singapore Pte Ltd.
About this paper
Cite this paper
Granda, W.X.B., Molina-Granja, F., Altamirano, J.D., Lopez, M.P., Sureshkumar, S., Swaminathan, J.N. (2023). Data Analytics for Healthcare Institutions: A Data Warehouse Model Proposal. In: Ranganathan, G., Fernando, X., Rocha, Á. (eds) Inventive Communication and Computational Technologies. Lecture Notes in Networks and Systems, vol 383. Springer, Singapore. https://doi.org/10.1007/978-981-19-4960-9_13
Download citation
DOI: https://doi.org/10.1007/978-981-19-4960-9_13
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-19-4959-3
Online ISBN: 978-981-19-4960-9
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)