Development of a Business Intelligence Solution for Performance Evaluation in Brazilian Courts of Auditors

In a context of raised demand for public services, shortage of resources and increasing complexity of controlling these public resources within a perspective that considers the evolution of public administration, with the incorporation of concepts of governance, planning and social engagement, it is imperative to pursuit improvement of ours institutions through the perception of their actions. Performance evaluations are essential management tools that allow us to monitor the achievement of goals, identify advances, correct problems and the need to make changes. Aiming at the optimization proposal in the indicators evaluation process that establishes the measurement of performance, quality and agility of Court of Auditors’ activities (established by ATRICON), applying a Business Intelligence tool that helps in the consolidation of the measurement of indicators and allows the registration and monitoring of the evolution of institution’s performance submitted to evaluation based on the framework Performance Measurement Milestone (MMD-QATC). To accomplish this task, the MySQL database management system was used in conjunction with HeidiSQL, the SQL Power Architect modeling tool, the Python programming language, the Pentaho Data Integration, part of the suite for BI solutions Pentaho in its Community Edition version, and the Microsoft Power BI Desktop. Thus, resulting in a more practical and scalable platform for consolidating the data

Analysis of the formulations of ceramic masses for the production of tiles and bricks: a bibliographic review

Directing attention to the production process of ceramic tiles and bricks, the importance of the ceramic sector is observed along with studies that seek improvements and positive interventions, in order to leverage the growth of the national pottery-ceramic sector. This work proposes to carry out a bibliographic review with a descriptive and informative approach, where the elaboration procedure took place through searches for scientific literature, having as descriptors: Analysis of the formulations of ceramic masses aiming at an improvement in the quality of the final product

Development of a Business Intelligence Solution for Performance Evaluation in Brazilian Courts of Auditors

In a context of raised demand for public services, shortage of resources and increasing complexity of controlling these public resources within a perspective that considers the evolution of public administration, with the incorporation of concepts of governance, planning and social engagement, it is imperative to pursuit improvement of ours institutions through the perception of their actions. Performance evaluations are essential management tools that allow us to monitor the achievement of goals, identify advances, correct problems and the need to make changes. Aiming at the optimization proposal in the indicators evaluation process that establishes the measurement of performance, quality and agility of Court of Auditors’ activities (established by ATRICON), applying a Business Intelligence tool that helps in the consolidation of the measurement of indicators and allows the registration and monitoring of the evolution of institution’s performance submitted to evaluation based on the framework Performance Measurement Milestone (MMD-QATC). To accomplish this task, the MySQL database management system was used in conjunction with HeidiSQL, the SQL Power Architect modeling tool, the Python programming language, the Pentaho Data Integration, part of the suite for BI solutions Pentaho in its Community Edition version, and the Microsoft Power BI Desktop. Thus, resulting in a more practical and scalable platform for consolidating the data

Sustainable Logistic Management Plan as an alternative to minimize budget difficulties of Higher Education Institutions

Brazil has increased its scientific production in the past four decades, with public universities playing a major role in scientific and technological research in the country. Recent cuts in governmental budgets to these institutions put them at risk of closing down, impacting not only education, but also research and development in the country, thus threatening the future of the national science and technology system. Sustainable actions may help universities to overcome this crisis. The aim of this study was to evaluate the results of the implementation, in 2008, of a Sustainable Logistic Management Plan (SLP) at the Federal University of Health Sciences of Porto Alegre (UFCSPA). Indicators were collected by UFCSPA Environmental Management Commission (EMC) and were publicly available. The study analyzed indicators such as water and energy consumption and special waste production to assess trends in environmental aspects and their respective impacts. The number of graduate and undergraduate courses at UFCSPA increased during the period, therefore most indicators showed an increase in resource consumption in absolute values. However, a decrease was observed when consumption was analyzed per capita. Accordingly, overall consumption of electricity increased 143% from 2008 to 2020, whereas a reduction per capita was observed. Special waste production increased 46% from 2013 to 2020, but per capita production remained stable and water consumption, despite having an average annual increase of 8%, also had a per capita reduction. This study shows how sustainable actions implemented by UFCSPA affected the use of resources, reducing the consumption of water, electricity, disposable materials, and waste per capita. Therefore, we can conclude that the actions implemented by the university in 2008 and monitored by the EMC in the SLP contributed significantly to achieving financial balance in the institution

Sustainable Logistic Management Plan as an alternative to minimize budget difficulties of Higher Education Institutions

Brazil has increased its scientific production in the past four decades, with public universities playing a major role in scientific and technological research in the country. Recent cuts in governmental budgets to these institutions put them at risk of closing down, impacting not only education, but also research and development in the country, thus threatening the future of the national science and technology system. Sustainable actions may help universities to overcome this crisis. The aim of this study was to evaluate the results of the implementation, in 2008, of a Sustainable Logistic Management Plan (SLP) at the Federal University of Health Sciences of Porto Alegre (UFCSPA). Indicators were collected by UFCSPA Environmental Management Commission (EMC) and were publicly available. The study analyzed indicators such as water and energy consumption and special waste production to assess trends in environmental aspects and their respective impacts. The number of graduate and undergraduate courses at UFCSPA increased during the period, therefore most indicators showed an increase in resource consumption in absolute values. However, a decrease was observed when consumption was analyzed per capita. Accordingly, overall consumption of electricity increased 143% from 2008 to 2020, whereas a reduction per capita was observed. Special waste production increased 46% from 2013 to 2020, but per capita production remained stable and water consumption, despite having an average annual increase of 8%, also had a per capita reduction. This study shows how sustainable actions implemented by UFCSPA affected the use of resources, reducing the consumption of water, electricity, disposable materials, and waste per capita. Therefore, we can conclude that the actions implemented by the university in 2008 and monitored by the EMC in the SLP contributed significantly to achieving financial balance in the institution