Graduate Program in Information Technology and Healthcare Management, Federal University of Health Sciences of Porto Alegre, Porto Alegre, Rio Grande do Sul, Brazil.
BMC Med Inform Decis Mak. 2022 Mar 25;22(1):76. doi: 10.1186/s12911-022-01814-9.
The management of the use of iodinated contrast agents (ICA) in the computed tomography (CT) has clinical and financial impacts; however, the approaches in the current research setting have limitations with regard to their exploration of the theme. This work describes the application of the stages of a process of business intelligence (BI), from the formulation of business questions, the building of a research database, and the adaptation of a multidimensional model, to the creation of dashboards to give support to the decision-making process in a hospital. This research aims to apply and document a BI process that provides support to the decision making of managers, so the use of ICA can be better managed, allowing for the identification of situations in which the material was wasted using a study applied to the hospital field.
An applied exploratory research with a quantitative approach in a database made up by 24 variables and 35,388 records extracted from the RIS (Radiology Information System) that is used by the General Hospital of Porto Alegre-HCPA. The software used, supplied by AGFA Healthcare, were the Qdoc system (version 6.2.0) and the Impax BI (Version 11.1.1) for, respectively, data entry and data exploration. At the end of the process, a total of 48 variables was considered.
The BI process applied allowed for the identification of situations in which ICA was being wasted during the operationalization of the volume/mass ratio of the agent injected in the patient. It also offered the necessary substantiation for the managers to formulate plans, actions, and controls associated to the use of the material. This work made it possible to diminish in 15.65% the total consumption of ICA injected in the patients who underwent the CTAB1 exam (full CT scan of the abdomen), with a projected economy of US$ 10,039.95, for the performance of this exam from 2020 on. The measuring of the impact and the relevance of the process was 99.6% positive, according to the evaluation of the managers.
This research generated clinical and financial benefits for the HCPA, a positive evaluation by the managers and the generation of new knowledge, which can be shared with other public or private health organizations.
在计算机断层扫描（CT）中使用碘造影剂（ICA）的管理具有临床和财务影响；然而，当前研究环境中的方法在探索主题方面存在局限性。本工作描述了业务智能（BI）过程的各个阶段的应用，从制定业务问题、构建研究数据库以及适应多维模型，到创建仪表板，以支持医院的决策过程。本研究旨在应用和记录 BI 流程，为管理者的决策提供支持，以便更好地管理 ICA 的使用，从而通过应用于医院领域的研究来识别浪费材料的情况。
这是一项应用探索性研究，采用定量方法，基于从波尔图阿雷格里港总医院使用的 RIS（放射信息系统）中提取的 24 个变量和 35388 条记录组成的数据库。使用的软件由 AGFA Healthcare 提供，分别是 Qdoc 系统（版本 6.2.0）和 Impax BI（版本 11.1.1），用于数据输入和数据探索。在流程结束时，共考虑了 48 个变量。
应用 BI 流程可以识别在操作注入患者的 ICA 时浪费情况，并为管理者制定与材料使用相关的计划、行动和控制提供必要的依据。这项工作使 CTAB1 检查（腹部全面 CT 扫描）中患者接受的 ICA 总注射量减少了 15.65%，预计 2020 年以来，该检查的节省费用为 10039.95 美元。根据管理者的评估，该流程的影响和相关性的测量结果为 99.6%为正。
本研究为 HCPA 带来了临床和经济效益，得到了管理者的积极评价，并产生了新的知识，可以与其他公共或私人卫生组织共享。
