Analysis of the NASH Efficiency Indicators in Brazilian Federal University Hospitals via Business Intelligence
Abstract
The hospital area is constantly in need of care and attention. Because of its urgencies, it has vulnerabilities and risks that hinder the quality of hospital management. Technological management tools are effective in improving processes and strategic administration because they provide information reliability. The aim of this work is to propose to the Brazilian’s Federal University Hospitals (BFUHs) and to the Brazilian Hospital Services Company (BHSC) the use of an open source Business Intelligence (BI) tool, Pentaho, to analyze the efficiency of Hospital Indicators (HIs) and to support the clinical decision-making. This paper describes BI and Pentaho, as well as the main points of the efficiency documentations established by the National Agency of Supplementary Health (NASH), with emphasis on the HIs: Hospital Occupancy Rates (HORs) and Averages Length of Stay (ALSs). The Pentaho does the data extraction and the transformation, as well as loading them into the Data Warehouse (DW), all based on a relational database from BHSC. After that, dimensional cubes are created for the generation of graphic panels in dashboards. Most BHSC hospitals are not yet adequately using their operational beds and neither managing correctly the average length of hospitals patients stay, being outside the goals established by NASH. Several steps are taken to achieve efficient hospital administration. However, the joint working of Information and Communication Technologies (ICTs) solutions with the health area and its standards provides a major step towards efficient hospital management.
The (A) Assignor declares that (s) text (s) concerned is (are) of his personal authorship, being responsible, therefore, for the originality of the (s) even (s) and gives the organizers, full rights to choice of publisher, publication means, means of reproduction, dissemination of media, drawing, shape, everything that is needed for that publication be effected.
PUBLISHER undertakes to ensure the editorial quality of the publication, ensuring that the concepts and the thought of (a) ASSIGNOR remain faithful to the original. This assignment will be valid throughout the period of legal protection WORK, may hold the PUBLISHER will be shown how many issues it deems appropriate.
All rights are reserved. Any reproduction, even if part of the publication should include the reference credit, according to the current copyright law of Brazil. Still, the article submission process, the author agrees to the terms of an exclusive statement, originality and agreement to the final version. It is justified in the field "; COMMENTS TO THE EDITOR" ;, when the participation of more than one author.