Author
Listed:
- Gabriel Pereira da Silva
- Thiago Magalhães Amaral
- Kalliny Mirella Gonçalves Barbosa
- José Luiz Moreira de Carvalho
- Michelly Bezerra dos Santos Rabelo
- Deuzilane Muniz Nunes
- Pedro Vieira Souza Santos
Abstract
The increasing availability of health data creates opportunities to improve public health surveillance and evidence-based decision-making. However, data inconsistencies, lack of standardization, and time-consuming manual processing limit the effective use of epidemiological information. This study aimed to develop and implement an automated data-processing solution integrated with Business Intelligence (BI) dashboards to improve data quality, streamline information processing, and support decision-making at the VIII Regional Health Management Office (VIII GERES), Pernambuco, Brazil. An applied technological case study with a quantitative approach was conducted between July 21 and August 11, 2025. The solution was developed using Python, incorporating data manipulation, approximate string matching, and an iterative learning mechanism based on human validation and decisions stored in JSON files. The processed data were integrated into Microsoft Power BI to develop three dashboards covering Land Transport Accidents (ATT), epidemiological surveillance data from the Notifiable Diseases Information System (SINAN), and healthcare regulation. The consolidated databases comprised 100,300 records. The software identified and corrected more than 60% of inconsistencies in neighborhood names and processed approximately 10,000 records per minute. In the final test, a database containing more than 30,000 records was processed without human intervention, using previously validated information. Processing time decreased from more than 30 days under the previous manual workflow to approximately 10 minutes. The dashboards enabled historical, epidemiological, geographic, and healthcare regulation analyses previously constrained by data inconsistencies. The findings demonstrate the feasibility of integrating automation and BI to strengthen data quality, operational efficiency, and information management in regional health surveillance.
Suggested Citation
Gabriel Pereira da Silva & Thiago Magalhães Amaral & Kalliny Mirella Gonçalves Barbosa & José Luiz Moreira de Carvalho & Michelly Bezerra dos Santos Rabelo & Deuzilane Muniz Nunes & Pedro Vieira Souza, 2026.
"Process Automation and Business Intelligence Applied to Healthcare Management,"
International Journal of Scientific Research in Artificial Intelligence and Machine Learning, International Journal of Scientific Research in Artificial Intelligence and Machine Learning, vol. 2(6), pages 01-13, November.
Handle:
RePEc:jbo:ijsrml:v2:y2026:i6:id:119
DOI: 10.5281/zenodo.24042358
Note: Article URL: https://ijsraiml.com/home/article/view/IJSRAIML26261
Download full text from publisher
Corrections
All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:jbo:ijsrml:v2:y2026:i6:id:119. See general information about how to correct material in RePEc.
If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.
We have no bibliographic references for this item. You can help adding them by using this form .
If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.
For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Pankaj Sharma (email available below). General contact details of provider: https://ijsraiml.com/home .
Please note that corrections may take a couple of weeks to filter through
the various RePEc services.