01. Universidade Federal Rural de Pernambuco - UFRPE (Sede)
URI permanente desta comunidadehttps://arandu.ufrpe.br/handle/123456789/1
Navegar
3 resultados
Resultados da Pesquisa
Item Construção de pipelines de dados sobre obras públicas em Pernambuco: abordagem prática com o Apache Airflow(2023-09-21) Silva, Henrique César José da; Albuquerque Júnior, Gabriel Alves de; http://lattes.cnpq.br/1399502815770584This study presents a practical approach to building data pipelines focused on collecting, transforming, and storing information related to public works in the state of Pernambuco. The central objective is to develop efficient and automated workflows for extracting data from public transparency portals and subsequently consolidating this information. Based on Data Engineering technologies, the Apache Airflow framework was chosen to orchestrate the processes, enabling the scheduling and monitoring of these workflows.Item Geração de indicadores de desempenho de negócio utilizando o Data Warehouse de uma grande rede de varejo(2023-05-04) Tavares, Luís Felipe do Carmo Costa; Gouveia, Roberta Macêdo Marques; http://lattes.cnpq.br/2024317361355224The use of Key Performance Indicators (KPIs) is essential for companies as it allows them to evaluate the performance and outcome of processes, facilitate decision-making, identify patterns of sector performance, reduce unnecessary costs, and increase operational efficiency. However, it is important to take into account that the calculation of KPIs becomes more complex due to the company's growth and the arrival of new demands. This project was implemented in a large retail network that needed to reformulate the way it calculated its KPIs due to the emergence of new branches and an increase in employees. To improve performance, the centralization of calculations was performed through a Data Warehouse model (with Data Lakes), where calculations with changes are being performed in a single database instead of in each branch's individual database and later centralized. During the project's implementation, several challenges were faced, such as validating the result of each indicator, creating new features (such as cumulative calculation), and the need to create a specific procedure for each metric and indicator.Item Processo de ETL voltado para jurimetria(2021-12-20) Cristovam, Edson Fagner da Silva; Bocanegra, Silvana; http://lattes.cnpq.br/4596111202208863; http://lattes.cnpq.br/1519472768897299Large companies may have difficulty managing numerous court cases they are defendants in, as a team of the size needed to manage these cases can be very costly. With the digitization of judicial processes, a strategy that automates the adjustment of process information and is easy to consult can be very useful. Therefore, the data warehouse seems to be a very suitable technique for this, as it normalizes and standardizes information from different sources that are contained in it. But to load the data into a data warehouse, it’s necessary to prepare it with a method commonly known as ETL. With this method we can create data extraction, transformation and load flows that will be written in the data warehouse. With a data warehouse filled with legal data, we can use it to help decision-making in the legal sector of companies through jurimetry, which consists of applying statistical tools to Law, providing new points of view based on data.