BI Solution to Monitoring the Expenses and Profile of the Elected Federal Deputies
Autor(a) principal: | |
---|---|
Data de Publicação: | 2021 |
Outros Autores: | , |
Tipo de documento: | Artigo |
Idioma: | por |
Título da fonte: | Revista de Engenharia e Pesquisa Aplicada |
Texto Completo: | http://revistas.poli.br/index.php/repa/article/view/1749 |
Resumo: | Despite the advances achieved by the transparency laws, the way this data is presented does not stimulate interest and does not contribute to the monitoring by society. This paper proposes a BI solution to monitoring the expenses of the federal deputies and also the profile of the parliamentarians who have occupied and who occupy the Chamber of Deputies. The visualizations designed allow to know how the distribution of gender, age and education of the deputies and also to understand how the parliamentary expenses are, providing a tool to assist monitoring by the population. The data used in the construction of the BI are made available by the Chamber of Deputies [1], subsequently, the ETL was made using Pentaho and, finally, the visualizations were developed using Tableau. |
id |
UFPE-2_abe677890dcc9a372f201e83612baab1 |
---|---|
oai_identifier_str |
oai:ojs.poli.br:article/1749 |
network_acronym_str |
UFPE-2 |
network_name_str |
Revista de Engenharia e Pesquisa Aplicada |
repository_id_str |
|
spelling |
BI Solution to Monitoring the Expenses and Profile of the Elected Federal DeputiesBI para Acompanhamento de Gastos e Perfil de Candidatos Eleitos para a Câmara dos Deputados FederalDespite the advances achieved by the transparency laws, the way this data is presented does not stimulate interest and does not contribute to the monitoring by society. This paper proposes a BI solution to monitoring the expenses of the federal deputies and also the profile of the parliamentarians who have occupied and who occupy the Chamber of Deputies. The visualizations designed allow to know how the distribution of gender, age and education of the deputies and also to understand how the parliamentary expenses are, providing a tool to assist monitoring by the population. The data used in the construction of the BI are made available by the Chamber of Deputies [1], subsequently, the ETL was made using Pentaho and, finally, the visualizations were developed using Tableau. Apesar dos avanços alcançados com as leis de transparência, a maneira como esses dados são apresentados não estimulam o interesse e não contribuem com a fiscalização por parte da sociedade. No presente trabalho, é proposto um BI dos gastos dos deputados federais com as cotas parlamentares e ainda o perfil dos parlamentares que ocuparam e ocupam a Câmara dos Deputados. As visualizações construídas permitem conhecer como se dá a distribuição de gênero, faixa etária e nível de escolaridade dos deputados e ainda compreender como as cotas parlamentares estão sendo usadas oferecendo assim uma ferramenta de auxílio à fiscalização por parte da população. Os dados utilizados na construção do BI são disponibilizados pela Câmara dos Deputados [1], em seguida, o ETL foi realizado com o auxílio do software Pentaho e, finalmente, as visualizações foram desenvolvidas com o software Tableau.Escola Politécnica de Pernambuco2021-11-18info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionapplication/pdftext/htmlhttp://revistas.poli.br/index.php/repa/article/view/1749Journal of Engineering and Applied Research; Vol 6 No 5 (2021): Edição Especial em Ciência de Dados e Analytics; 11-17Revista de Engenharia e Pesquisa Aplicada; v. 6 n. 5 (2021): Edição Especial em Ciência de Dados e Analytics; 11-172525-425110.25286/repa.v6i5reponame:Revista de Engenharia e Pesquisa Aplicadainstname:Universidade Federal de Pernambuco (UFPE)instacron:UFPEporhttp://revistas.poli.br/index.php/repa/article/view/1749/771http://revistas.poli.br/index.php/repa/article/view/1749/773Copyright (c) 2021 Diogo Farkatt Kabbaz, Elizabeth Lopes Silva, Paulo Henrique Oliveirahttp://creativecommons.org/licenses/by-nc/4.0info:eu-repo/semantics/openAccessKabbaz, Diogo FarkattSilva, Elizabeth LopesOliveira, Paulo Henrique2021-11-25T12:22:35Zoai:ojs.poli.br:article/1749Revistahttp://revistas.poli.br/index.php/repaONGhttp://revistas.poli.br/index.php/repa/oai||repa@poli.br2525-42512525-4251opendoar:2021-11-25T12:22:35Revista de Engenharia e Pesquisa Aplicada - Universidade Federal de Pernambuco (UFPE)false |
dc.title.none.fl_str_mv |
BI Solution to Monitoring the Expenses and Profile of the Elected Federal Deputies BI para Acompanhamento de Gastos e Perfil de Candidatos Eleitos para a Câmara dos Deputados Federal |
title |
BI Solution to Monitoring the Expenses and Profile of the Elected Federal Deputies |
spellingShingle |
BI Solution to Monitoring the Expenses and Profile of the Elected Federal Deputies Kabbaz, Diogo Farkatt |
title_short |
BI Solution to Monitoring the Expenses and Profile of the Elected Federal Deputies |
title_full |
BI Solution to Monitoring the Expenses and Profile of the Elected Federal Deputies |
title_fullStr |
BI Solution to Monitoring the Expenses and Profile of the Elected Federal Deputies |
title_full_unstemmed |
BI Solution to Monitoring the Expenses and Profile of the Elected Federal Deputies |
title_sort |
BI Solution to Monitoring the Expenses and Profile of the Elected Federal Deputies |
author |
Kabbaz, Diogo Farkatt |
author_facet |
Kabbaz, Diogo Farkatt Silva, Elizabeth Lopes Oliveira, Paulo Henrique |
author_role |
author |
author2 |
Silva, Elizabeth Lopes Oliveira, Paulo Henrique |
author2_role |
author author |
dc.contributor.author.fl_str_mv |
Kabbaz, Diogo Farkatt Silva, Elizabeth Lopes Oliveira, Paulo Henrique |
description |
Despite the advances achieved by the transparency laws, the way this data is presented does not stimulate interest and does not contribute to the monitoring by society. This paper proposes a BI solution to monitoring the expenses of the federal deputies and also the profile of the parliamentarians who have occupied and who occupy the Chamber of Deputies. The visualizations designed allow to know how the distribution of gender, age and education of the deputies and also to understand how the parliamentary expenses are, providing a tool to assist monitoring by the population. The data used in the construction of the BI are made available by the Chamber of Deputies [1], subsequently, the ETL was made using Pentaho and, finally, the visualizations were developed using Tableau. |
publishDate |
2021 |
dc.date.none.fl_str_mv |
2021-11-18 |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion |
format |
article |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
http://revistas.poli.br/index.php/repa/article/view/1749 |
url |
http://revistas.poli.br/index.php/repa/article/view/1749 |
dc.language.iso.fl_str_mv |
por |
language |
por |
dc.relation.none.fl_str_mv |
http://revistas.poli.br/index.php/repa/article/view/1749/771 http://revistas.poli.br/index.php/repa/article/view/1749/773 |
dc.rights.driver.fl_str_mv |
Copyright (c) 2021 Diogo Farkatt Kabbaz, Elizabeth Lopes Silva, Paulo Henrique Oliveira http://creativecommons.org/licenses/by-nc/4.0 info:eu-repo/semantics/openAccess |
rights_invalid_str_mv |
Copyright (c) 2021 Diogo Farkatt Kabbaz, Elizabeth Lopes Silva, Paulo Henrique Oliveira http://creativecommons.org/licenses/by-nc/4.0 |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
application/pdf text/html |
dc.publisher.none.fl_str_mv |
Escola Politécnica de Pernambuco |
publisher.none.fl_str_mv |
Escola Politécnica de Pernambuco |
dc.source.none.fl_str_mv |
Journal of Engineering and Applied Research; Vol 6 No 5 (2021): Edição Especial em Ciência de Dados e Analytics; 11-17 Revista de Engenharia e Pesquisa Aplicada; v. 6 n. 5 (2021): Edição Especial em Ciência de Dados e Analytics; 11-17 2525-4251 10.25286/repa.v6i5 reponame:Revista de Engenharia e Pesquisa Aplicada instname:Universidade Federal de Pernambuco (UFPE) instacron:UFPE |
instname_str |
Universidade Federal de Pernambuco (UFPE) |
instacron_str |
UFPE |
institution |
UFPE |
reponame_str |
Revista de Engenharia e Pesquisa Aplicada |
collection |
Revista de Engenharia e Pesquisa Aplicada |
repository.name.fl_str_mv |
Revista de Engenharia e Pesquisa Aplicada - Universidade Federal de Pernambuco (UFPE) |
repository.mail.fl_str_mv |
||repa@poli.br |
_version_ |
1798036000394444800 |