Proposta de um ambiente de business intelligence para acompanhamento dos egressos dos programas de iniciação científica do IFSULDEMINAS

Abstract

The Institutional Scientific Initiation Scholarship Program has the following main objectives: to contribute to the formation of human resources for research, to qualify students for graduate programs and to contribute to reducing the average length of stay in graduate school. Therefore, a system to follow up Scientific Initiation (CI) graduates should be part of the management of the HEIs, as it makes it possible, through information, to keep track of the academic and professional trajectory, the absorption of these graduates in master's and doctoral courses and the impact on society, in addition to providing subsidies for the planning of institutional actions. For this type of follow-up, the use of data analysis tools is fundamental, among which Business Intelligence (BI) stands out. The main component of a BI is the Data Warehouse (DW), which is a data repository whose purpose is to feed the BI, reports and analytical functions generating information. Therefore, this study had as main objective to propose a Data Warehouse environment for the monitoring of graduates of the scientific initiation of the Federal Institute of Education, Science and Technology of the South of Minas (IFSULDEMINAS) with managerial information that can help managers in taking decision in the scope of scientific initiation, research and graduate studies. To achieve this objective, the study was conducted using the action-research method, describing the steps from identifying the problem and informational requirements to proposing a solution, which is the proposition of a DW (dimensional model) for the Management of Graduates of IC, and the visualization of information through Dashboards. To identify the requirements, semi-structured interviews, documentary and bibliographical research and direct observation were carried out. Data analysis was qualitative and descriptive. The development of the BI DW was based on Ralph Kimball's methodology, and Power BI software was used to present data in the form of dashboards. The tool was evaluated and validated by CI Managers at IFSULDEMINAS. The results reached achieved the proposed objectives, presenting relevant information for the follow-up of IC graduates. The developed DW dimensional model was able to transform the data into important information, and the developed dashboard report allowed the analysis of the results, demonstrating the impact of CI graduates in the training of human resources for research (masters and doctors), as well as their trajectory professional and academic and social impact. The final database built, in view of its magnitude of dimensions and data, enables new analyzes with the present dimensions, allowing to establish intersections not provided by the direction of the study. As a contribution, in addition to the social/economic (training of human resources for research), practical/personal (development of a BI tool as a solution to the contextualized problem), this research also contributes at the academic/scientific level, as the result will in addition to a new study on BI, it contributes to filling the gap in the literature on BI tools in Graduate Management and studies on BI in public institutions, which contributes to the evolution of the theory.