Utilização do business intelligence para apoio em tomada de decisões em farmácia pública no Sul de Minas Gerais

Abstract

An efficient management of the pharmaceutical assistance service contributes to the promotion of the rational use of medicines, bringing countless benefits to users of the Unified Health System. In pursuit of this efficiency, it is necessary to access reliable information in a timely manner, so that decision-making takes place based on knowledge, with speed and quality. The purpose of this research was the use of Business Intelligence, through one of its analysis tool, OLAP, to enable the contextualization of data and the presentation of cause and effect relationships through the development of a computational tool, allowing the improvement of operational, tactical and strategic decision-making in the pharmaceutical assistance service in a municipality in the south of Minas Gerais. The action research methodology was used with data collected from documental research instruments, interview, questionnaire and observation. The analyzes performed were related to the selected health units, the medication under study dispensed, the profile of the patients and the main prescribers. Finally, an action plan was carried out for each analysis performed and a dashboard was created, with the objective of facilitating the generation of knowledge in an intuitive way. As a result, a tool was obtained, which can be replicated to other lists of drugs, areas and periods to provide cause-and-effect relationships, allowing the targeting of actions to groups of patients, professionals and population areas in order to maintain regularity supply of medicines and promote their rational use.