Plataforma multidimensional online para canais de pesquisa, desenvolvimento tecnológico e serviços em instituições científicas e tecnológicas baseada em business intelligence.

Abstract

Given the growing importance of addressing institutional, productive, and governmental demands in the Science, Technology, and Innovation ecosystem, this thesis sought to solve a critical problem: how to organize and enhance the management of research, technological development, and service provision (RD&S) data in Science and Technology Institutions (STIs) in order to respond in a timely and reliable manner to these demands. To this end, the work presented a developed online technological solution aimed at integrating and systematizing public data from this ecosystem. This was registered at the INPI (BR5120230010197), based on theories of innovation, business analysis and data visualization. It used the incorporation of Business Intelligence techniques, data warehouse and interactive dashboards as a quantitative approach. To validate this thesis, data from the Federal Network of Professional, Scientific, and Technological Education was used as a case study. The challenge was to overcome the barriers to integrating data related to innovation management, which has hindered decision-making by the general public, STI managers, researchers, and the productive sectors. By designing and implementing such technological solutions, anchored in the theories of Business Analysis, Data Visualization, and the Triple Helix Theory of Innovation, it was possible to present and better understand the problems from the availability of data to society in a timely and reliable manner. The methodology used was a quantitative and empirical-deductive approach that included literature review, consultation with users, identification data sources, and validation of the system by nine experts. The results showed that the tool was essential to consolidate information from multiple sources, helping society in general to respond quickly and reliably to the demands presented. The proposed solution also presented a user-friendly interface with market potential, adaptable to different institutions of the National Innovation System, based on expert assessments. In addition, the implementation of the technological solution allowed for the observation of specific characteristics of the Federal Network, such as the diversity of disciplines and the geographical concentration of research, as well as the need to strengthen collaboration between researchers and the private sector. The scientific contribution resided in the proposal of requalifying data through the process of extraction, treatment, and loading (ETL), data warehouse, classifiers such as hierarchical and non-hierarchical analysis, identification of factors and indicators of innovation, even allowing for the addition of more complex statistical analyses in the future. As an illustration, after a decade, institutions from the Northeast and North of Brazil began to gain prominence. The conclusions reinforced the need for practical technological solutions for the sectors involved and the importance of continued research, suggesting theoretical deepening and methodological expansion, such as the adoption of data lakes or lakehouse. Limitations of the study included the difficulty of accessing public data in Brazil and the need for constant system updates to maintain data quality and accessibility.