A carregar...
Publicação
Optimizing statistical production at a central bank
| Nome: | Descrição: | Tamanho: | Formato: | |
|---|---|---|---|---|
| 1.14 MB | Adobe PDF |
Orientador(es)
Resumo(s)
The quick evolution of data analysis and manipulation tools over the recent decades has transformed how organizations manage and process information. However, many organizations, particularly those with more years of experience, continue to rely on systems built with the tools and knowledge available at the time. While innovative when introduced, these systems have become inefficient as technology advances, business needs evolve, and data volume grows. As a result, updating and improving these processes is now essential to meet current demands. At Banco de Portugal, particularly in the Central Balance-Sheet Division of the Statistics Department, these challenges are evident. Although still operational, the annual statistical production process requires reformulation, as it was developed incrementally over time to address specific needs, with now outdated methodologies and tools. These processes currently present inefficiencies such as excessive manual tasks and redundant code. Therefore, to address these issues and align with the department’s goal of integrating the systems within the Data Warehouse, the Central Balance-Sheet Division initiated several optimization efforts, including this project. This project involved five optimization actions to address inefficiencies and modernize the statistical production process. Initially, efforts were directed towards developing an automated drill-down tool, and analyzing the current production workflow while documenting programs developed using SAS software. These insights led to a proposed redesign of the production process, which addressed inefficiencies and facilitated integration with the Data Warehouse. Building on this new process design, subsequent tasks included creating an alert analysis program and migrating the programs used to define the universe of active companies to SQL. Although the full optimization is projected to take two years, this project represents a vital first step, delivering tangible improvements and establishing the foundation for a more efficient and integrated statistical production system at Banco de Portugal.
Descrição
Palavras-chave
Data Analysis and Manipulation Tools Data Warehouse Process Automation Process Optimization
Contexto Educativo
Citação
Madeira, Sara Alexandra da Cunha e Silva Pena .(2025). “Optimizing statistical production at a central bank”. Dissertação de Mestrado.Universidade de Lisboa. Instituto Superior de Economia e Gestão
Editora
Instituto Superior de Economia e Gestão