Predicting Emergency Attendance at a Tertiary Hospital: An Emergency Department Data Warehouse Project

Detalhes bibliográficos
Autor(a) principal: Gonçalves, Catarina Sousa
Data de Publicação: 2023
Tipo de documento: Dissertação
Idioma: eng
Título da fonte: Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
Texto Completo: http://hdl.handle.net/10362/160473
Resumo: Project Work presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business Intelligence
id RCAP_4160e2a649944d7f2e85d6c5ba09be78
oai_identifier_str oai:run.unl.pt:10362/160473
network_acronym_str RCAP
network_name_str Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
repository_id_str 7160
spelling Predicting Emergency Attendance at a Tertiary Hospital: An Emergency Department Data Warehouse ProjectBusiness IntelligenceHealthcareSustentabilityData WarehouseSDG 3 - Good health and well-beingSDG 9 - Industry, innovation and infrastructureSDG 12 - Responsible production and consumptionDomínio/Área Científica::Ciências Naturais::Ciências da Computação e da InformaçãoProject Work presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business IntelligenceThe overcrowding of emergency departments (ED) has been a well-known problem worldwide. Over the years, many solutions have been proposed, demonstrating that improving task processes and management through business intelligence (BI) applications results in better outcomes. C.H.U.L.N. is the largest Portuguese hospital, providing third-level services, and its unique characteristics present a management challenge. Consequently, the excessive influx of patients to the emergency room is a more pronounced issue compared to other institutions. Therefore, the purpose of this thesis is to create a data warehouse for the C.H.U.L.N.'s Emergency department. This will facilitate the future development of a patient influx prediction algorithm, ultimately improving departmental management. To determine which information should be included in the data warehouse for the future algorithm, it was necessary to understand, based on existing projects and algorithms, what relevant information should be considered. As a result of the Data Warehouse Project, a constellation schema composed of two star schemas was designed. The relevant patient information identified in the literature includes the patient's age, gender, date and time of admission to the ED, diagnosis, Manchester Triage System (MTS) priority color, patient checkout condition, and other selected information. These factors were considered in the Data Warehouse. The project focuses on two main fact tables - Emergency Assistance and Outpatients - which enable access to selected information about ED patients. This information can be compared with the selected information about patients receiving treatment in service wards and during medical appointments. Analyzing the C.H.U.L.N.’s ED flowchart from the moment the patient enters the department, it seemed important to consider other factors such as waiting times in minutes. This thesis intends to serve as an intermediary step, creating a suitable data warehouse that permits the future development of a influx prediction algorithm, along with other potential projects. The application of BI is an important step in the development, improvement and sustainability of healthcare, which is the primary focus of this entire thesis.Neto, Miguel de Castro Simões FerreiraBatista, Luis Pedro LopesRUNGonçalves, Catarina Sousa2023-11-24T20:34:41Z2023-10-242023-10-24T00:00:00Zinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisapplication/pdfhttp://hdl.handle.net/10362/160473TID:203390598enginfo:eu-repo/semantics/openAccessreponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãoinstacron:RCAAP2024-03-11T05:43:13Zoai:run.unl.pt:10362/160473Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireopendoar:71602024-03-20T03:58:04.573893Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãofalse
dc.title.none.fl_str_mv Predicting Emergency Attendance at a Tertiary Hospital: An Emergency Department Data Warehouse Project
title Predicting Emergency Attendance at a Tertiary Hospital: An Emergency Department Data Warehouse Project
spellingShingle Predicting Emergency Attendance at a Tertiary Hospital: An Emergency Department Data Warehouse Project
Gonçalves, Catarina Sousa
Business Intelligence
Healthcare
Sustentability
Data Warehouse
SDG 3 - Good health and well-being
SDG 9 - Industry, innovation and infrastructure
SDG 12 - Responsible production and consumption
Domínio/Área Científica::Ciências Naturais::Ciências da Computação e da Informação
title_short Predicting Emergency Attendance at a Tertiary Hospital: An Emergency Department Data Warehouse Project
title_full Predicting Emergency Attendance at a Tertiary Hospital: An Emergency Department Data Warehouse Project
title_fullStr Predicting Emergency Attendance at a Tertiary Hospital: An Emergency Department Data Warehouse Project
title_full_unstemmed Predicting Emergency Attendance at a Tertiary Hospital: An Emergency Department Data Warehouse Project
title_sort Predicting Emergency Attendance at a Tertiary Hospital: An Emergency Department Data Warehouse Project
author Gonçalves, Catarina Sousa
author_facet Gonçalves, Catarina Sousa
author_role author
dc.contributor.none.fl_str_mv Neto, Miguel de Castro Simões Ferreira
Batista, Luis Pedro Lopes
RUN
dc.contributor.author.fl_str_mv Gonçalves, Catarina Sousa
dc.subject.por.fl_str_mv Business Intelligence
Healthcare
Sustentability
Data Warehouse
SDG 3 - Good health and well-being
SDG 9 - Industry, innovation and infrastructure
SDG 12 - Responsible production and consumption
Domínio/Área Científica::Ciências Naturais::Ciências da Computação e da Informação
topic Business Intelligence
Healthcare
Sustentability
Data Warehouse
SDG 3 - Good health and well-being
SDG 9 - Industry, innovation and infrastructure
SDG 12 - Responsible production and consumption
Domínio/Área Científica::Ciências Naturais::Ciências da Computação e da Informação
description Project Work presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business Intelligence
publishDate 2023
dc.date.none.fl_str_mv 2023-11-24T20:34:41Z
2023-10-24
2023-10-24T00:00:00Z
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
dc.type.driver.fl_str_mv info:eu-repo/semantics/masterThesis
format masterThesis
status_str publishedVersion
dc.identifier.uri.fl_str_mv http://hdl.handle.net/10362/160473
TID:203390598
url http://hdl.handle.net/10362/160473
identifier_str_mv TID:203390598
dc.language.iso.fl_str_mv eng
language eng
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.source.none.fl_str_mv reponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
instacron:RCAAP
instname_str Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
instacron_str RCAAP
institution RCAAP
reponame_str Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
collection Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
repository.name.fl_str_mv Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
repository.mail.fl_str_mv
_version_ 1799138162369363968

Registros relacionados