Implementação de ferramentas analíticas para o sistema open social care: relatórios estruturados e dashboards

Abstract

Data management in social assistance often faces challenges due to manual and decentralized processes, hindering the extraction of insights for informed decision-making. This work is justified by the need for tools that transform operational data into strategic information, aiming to optimize resource allocation and the monitoring of public policies. The main objective was to develop an analytical module integrated into the Open Social Care system. The adopted methodology involved extending the existing form system to support multiple-choice questions, creating default templates (CCG and Albergue) via Laravel Seeders to standardize data collection, and implementing a data population script (Populate) to generate demonstration data. On the backend, an SQL view (analytics_view) was created to unify responses, and a controller (AnalyticsController) was implemented to process the data, generating categorized analyses specific to each template. On the frontend (Next.js), an interface with interactive dashboards was developed, using ApexCharts for graphs and custom components for KPIs, along with dynamic filters for template and period. The report export functionality was implemented, generating CSV files on the server (with league/csv) and PDF files on the client-side (with jsPDF and jspdf-autotable). As results, the implemented analytical module allows for the dynamic visualization of demographic, socioeconomic, and operational indicators, adapting the data presentation to the context of each form (CCG or Albergue), and offers filtered data export. It is concluded that the project achieved its technical objectives, delivering a functional tool that contributes to the modernization of management in social assistance, although formal usability tests are recommended as future work to refine the interface.