Ferramentas para análise de dados das perícias de Engenharia Legal da Polícia Federal no Estado da Paraíba

Abstract

The Legal Engineering Group of the Federal Police in the State of Paraíba analyzes several types of construction works from a forensic perspective. During the period from 2007 to 2021, the group produced a large database related to this activity. From this data, dynamic panels were developed with the help of Qlik Sense software, which is the main product of this work. The dashboards allow the visualization and exploration, in a quick way, of essential information to the study of the works investigated, allowing the Experts to analyze connections between data and better understand the casuistry of expert examinations in the State, especially those involving the investigation of detour of federal public resources in engineering works. As a complement to the database of application, the data origin form (FOPP) was updated by developing macros in Visual Basic for Applications (VBA), in order to optimize its filling time. Although the database of the State of Paraíba was used in this study, the application can be applied to any unit of the Federation that has analogous data.