Resumo:
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.