Publicação
Digitalisation in the portuguese banking system : a business intelligence solution to strengthen supervisory knowledge
| Resumo: | This report aims to provide an overview of the main accomplishments attained throughout my internship at the Prudential Supervision Department at Banco de Portugal. As Banco de Portugal’s representative in the joint team on Digitalisation and FinTech with the ECB, I was able to gather actionable insights on banks’ ability to outline adequate digital transformation strategies to face the structural changes stemming from digitalisation. More precisely, I developed and implemented a BI solution, which involved designing and building a data warehouse, developing an ETL process to populate it, and constructing an interactive dashboard in Power BI for bank-specific supervisory teams. The supervisory tool was shown to be extremely elucidatory to the end users. |
|---|---|
| Autores principais: | Branco, Maria Sofia Paredes Silva |
| Assunto: | Banking Supervision Digitalisation Data Warehousing Reporting Power BI Supervisão Bancária Digitalização Armazenamento de dados Relato regulatório |
| Ano: | 2023 |
| País: | Portugal |
| Tipo de documento: | dissertação de mestrado |
| Tipo de acesso: | acesso aberto |
| Instituição associada: | Universidade de Lisboa |
| Idioma: | inglês |
| Origem: | Repositório da Universidade de Lisboa |
| _version_ | 1866810300632662016 |
|---|---|
| author | Branco, Maria Sofia Paredes Silva |
| author_facet | Branco, Maria Sofia Paredes Silva |
| author_role | author |
| contributor_name_str_mv | Rodrigues, Eduardo Lencastre, Diogo Repositório Científico de Acesso Aberto da ULisboa |
| country_str | PT |
| creators_json_txt | [{\"Person.name\":\"Branco, Maria Sofia Paredes Silva\"}] |
| datacite.contributors.contributor.contributorName.fl_str_mv | Rodrigues, Eduardo Lencastre, Diogo Repositório Científico de Acesso Aberto da ULisboa |
| datacite.creators.creator.creatorName.fl_str_mv | Branco, Maria Sofia Paredes Silva |
| datacite.date.Accepted.fl_str_mv | 2023-03-01T00:00:00Z |
| datacite.date.available.fl_str_mv | 2024-03-06T01:30:40Z |
| datacite.date.embargoed.fl_str_mv | 2024-03-06T01:30:40Z |
| datacite.rights.fl_str_mv | http://purl.org/coar/access_right/c_abf2 |
| datacite.subjects.subject.fl_str_mv | Banking Supervision Digitalisation Data Warehousing Reporting Power BI Supervisão Bancária Digitalização Armazenamento de dados Relato regulatório |
| datacite.titles.title.fl_str_mv | Digitalisation in the portuguese banking system : a business intelligence solution to strengthen supervisory knowledge |
| dc.contributor.none.fl_str_mv | Rodrigues, Eduardo Lencastre, Diogo Repositório Científico de Acesso Aberto da ULisboa |
| dc.creator.none.fl_str_mv | Branco, Maria Sofia Paredes Silva |
| dc.date.Accepted.fl_str_mv | 2023-03-01T00:00:00Z |
| dc.date.available.fl_str_mv | 2024-03-06T01:30:40Z |
| dc.date.embargoed.fl_str_mv | 2024-03-06T01:30:40Z |
| dc.format.none.fl_str_mv | application/pdf |
| dc.identifier.none.fl_str_mv | http://hdl.handle.net/10400.5/28432 |
| dc.language.none.fl_str_mv | eng |
| dc.publisher.none.fl_str_mv | Instituto Superior de Economia e Gestão |
| dc.rights.none.fl_str_mv | http://purl.org/coar/access_right/c_abf2 |
| dc.subject.none.fl_str_mv | Banking Supervision Digitalisation Data Warehousing Reporting Power BI Supervisão Bancária Digitalização Armazenamento de dados Relato regulatório |
| dc.title.fl_str_mv | Digitalisation in the portuguese banking system : a business intelligence solution to strengthen supervisory knowledge |
| dc.type.none.fl_str_mv | http://purl.org/coar/resource_type/c_bdcc |
| description | This report aims to provide an overview of the main accomplishments attained throughout my internship at the Prudential Supervision Department at Banco de Portugal. As Banco de Portugal’s representative in the joint team on Digitalisation and FinTech with the ECB, I was able to gather actionable insights on banks’ ability to outline adequate digital transformation strategies to face the structural changes stemming from digitalisation. More precisely, I developed and implemented a BI solution, which involved designing and building a data warehouse, developing an ETL process to populate it, and constructing an interactive dashboard in Power BI for bank-specific supervisory teams. The supervisory tool was shown to be extremely elucidatory to the end users. |
| dirty | 0 |
| eu_rights_str_mv | openAccess |
| format | masterThesis |
| fulltext.url.fl_str_mv | https://repositorio.ulisboa.pt/bitstreams/298e1be8-3236-4f6b-a44a-7d1e425df62c/download |
| id | ul_1bded40ebbd3d22877ef29aeda0012fc |
| identifier.url.fl_str_mv | http://hdl.handle.net/10400.5/28432 |
| instacron_str | ul |
| institution | Universidade de Lisboa |
| instname_str | Universidade de Lisboa |
| language | eng |
| network_acronym_str | ul |
| network_name_str | Repositório da Universidade de Lisboa |
| oai_identifier_str | oai:repositorio.ulisboa.pt:10400.5/28432 |
| organization_str_mv | urn:organizationAcronym:ul |
| person_str_mv | Branco, Maria Sofia Paredes Silva |
| publishDate | 2023 |
| publisher.none.fl_str_mv | Instituto Superior de Economia e Gestão |
| reponame_str | Repositório da Universidade de Lisboa |
| repository_id_str | urn:repositoryAcronym:ul |
| service_str_mv | urn:repositoryAcronym:ul |
| spelling | engInstituto Superior de Economia e Gestãopt_PTThis report aims to provide an overview of the main accomplishments attained throughout my internship at the Prudential Supervision Department at Banco de Portugal. As Banco de Portugal’s representative in the joint team on Digitalisation and FinTech with the ECB, I was able to gather actionable insights on banks’ ability to outline adequate digital transformation strategies to face the structural changes stemming from digitalisation. More precisely, I developed and implemented a BI solution, which involved designing and building a data warehouse, developing an ETL process to populate it, and constructing an interactive dashboard in Power BI for bank-specific supervisory teams. The supervisory tool was shown to be extremely elucidatory to the end users.application/pdfpt_PTDigitalisation in the portuguese banking system : a business intelligence solution to strengthen supervisory knowledgeBranco, Maria Sofia Paredes SilvaRodrigues, EduardoLencastre, DiogoHostingInstitutionOrganizationalRepositório Científico de Acesso Aberto da ULisboae-mailmailto:repositorio@reitoria.ulisboa.ptrepositorio@reitoria.ulisboa.pt2024-03-06T01:30:40Z2023-032023-03-01T00:00:00ZHandlehttp://hdl.handle.net/10400.5/28432http://purl.org/coar/access_right/c_abf2open accessBanking SupervisionDigitalisationData WarehousingReportingPower BISupervisão BancáriaDigitalizaçãoArmazenamento de dadosRelato regulatório943986 bytesliteraturehttp://purl.org/coar/resource_type/c_bdccmaster thesishttp://purl.org/coar/access_right/c_abf2application/pdffulltexthttps://repositorio.ulisboa.pt/bitstreams/298e1be8-3236-4f6b-a44a-7d1e425df62c/download |
| spellingShingle | Digitalisation in the portuguese banking system : a business intelligence solution to strengthen supervisory knowledge Branco, Maria Sofia Paredes Silva Banking Supervision Digitalisation Data Warehousing Reporting Power BI Supervisão Bancária Digitalização Armazenamento de dados Relato regulatório |
| status | SINGLETON |
| subject.fl_str_mv | Banking Supervision Digitalisation Data Warehousing Reporting Power BI Supervisão Bancária Digitalização Armazenamento de dados Relato regulatório |
| title | Digitalisation in the portuguese banking system : a business intelligence solution to strengthen supervisory knowledge |
| title_full | Digitalisation in the portuguese banking system : a business intelligence solution to strengthen supervisory knowledge |
| title_fullStr | Digitalisation in the portuguese banking system : a business intelligence solution to strengthen supervisory knowledge |
| title_full_unstemmed | Digitalisation in the portuguese banking system : a business intelligence solution to strengthen supervisory knowledge |
| title_short | Digitalisation in the portuguese banking system : a business intelligence solution to strengthen supervisory knowledge |
| title_sort | Digitalisation in the portuguese banking system : a business intelligence solution to strengthen supervisory knowledge |
| topic | Banking Supervision Digitalisation Data Warehousing Reporting Power BI Supervisão Bancária Digitalização Armazenamento de dados Relato regulatório |
| topic_facet | Banking Supervision Digitalisation Data Warehousing Reporting Power BI Supervisão Bancária Digitalização Armazenamento de dados Relato regulatório |
| url | http://hdl.handle.net/10400.5/28432 |
| visible | 1 |