Publicação
Leveraging business intelligence through ETL processes and Power BI dashboard development
| Resumo: | This report aims to outline the tasks accomplished during the internship at LGG Advisors as part of the Master’s in Data Analytics for Business program at ISEG. The main goal of the internship was to enhance the intern's skills in data analytics, with a particular emphasis on refining methods related to data acquisition, processing, and integration within a database framework, as well as improve the ability to create dynamic and informative dashboards. During the internship, the intern was placed with the Data Transformation team at LGG Advisors, where their primary duties involved ETL processes and generating Power BI reports for LGG clients. The acquired skills in ETL processes streamlined data acquisition and preparation and laid the foundation for developing robust and insightful dashboards. The developed dashboards allowed store directors and executives to effectively compare performance across different locations, identify areas for improvement, and implement data-driven decisions that boosted profitability. The internship reinforced the invaluable role of data analytics and business intelligence principles, actionable insights that drive business success. |
|---|---|
| Autores principais: | Santos, Leonor Barbosa Leal Simões dos |
| Assunto: | Business Intelligence Power BI Data Visualisation ETL Processes |
| Ano: | 2024 |
| 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_ | 1865920802874982400 |
|---|---|
| author | Santos, Leonor Barbosa Leal Simões dos |
| author_facet | Santos, Leonor Barbosa Leal Simões dos Santos, Leonor Barbosa Leal Simões dos |
| author_role | author |
| contributor_name_str_mv | Fernandes, Jesualdo Repositório Científico de Acesso Aberto da ULisboa |
| country_str | PT |
| creators_json_str | [{\"Person.name\":\"Santos, Leonor Barbosa Leal Simões dos\"}] |
| datacite.contributors.contributor.contributorName.fl_str_mv | Fernandes, Jesualdo Repositório Científico de Acesso Aberto da ULisboa |
| datacite.creators.creator.creatorName.fl_str_mv | Santos, Leonor Barbosa Leal Simões dos |
| datacite.date.Accepted.fl_str_mv | 2024-03-01T00:00:00Z |
| datacite.date.available.fl_str_mv | 2024-06-14T14:05:44Z |
| datacite.date.embargoed.fl_str_mv | 2024-06-14T14:05:44Z |
| datacite.rights.fl_str_mv | http://purl.org/coar/access_right/c_abf2 |
| datacite.subjects.subject.fl_str_mv | Business Intelligence Power BI Data Visualisation ETL Processes |
| datacite.titles.title.fl_str_mv | Leveraging business intelligence through ETL processes and Power BI dashboard development |
| dc.contributor.none.fl_str_mv | Fernandes, Jesualdo Repositório Científico de Acesso Aberto da ULisboa |
| dc.creator.none.fl_str_mv | Santos, Leonor Barbosa Leal Simões dos |
| dc.date.Accepted.fl_str_mv | 2024-03-01T00:00:00Z |
| dc.date.available.fl_str_mv | 2024-06-14T14:05:44Z |
| dc.date.embargoed.fl_str_mv | 2024-06-14T14:05:44Z |
| dc.format.none.fl_str_mv | application/pdf |
| dc.identifier.none.fl_str_mv | http://hdl.handle.net/10400.5/31161 |
| 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 | Business Intelligence Power BI Data Visualisation ETL Processes |
| dc.title.fl_str_mv | Leveraging business intelligence through ETL processes and Power BI dashboard development |
| dc.type.none.fl_str_mv | http://purl.org/coar/resource_type/c_bdcc |
| description | This report aims to outline the tasks accomplished during the internship at LGG Advisors as part of the Master’s in Data Analytics for Business program at ISEG. The main goal of the internship was to enhance the intern's skills in data analytics, with a particular emphasis on refining methods related to data acquisition, processing, and integration within a database framework, as well as improve the ability to create dynamic and informative dashboards. During the internship, the intern was placed with the Data Transformation team at LGG Advisors, where their primary duties involved ETL processes and generating Power BI reports for LGG clients. The acquired skills in ETL processes streamlined data acquisition and preparation and laid the foundation for developing robust and insightful dashboards. The developed dashboards allowed store directors and executives to effectively compare performance across different locations, identify areas for improvement, and implement data-driven decisions that boosted profitability. The internship reinforced the invaluable role of data analytics and business intelligence principles, actionable insights that drive business success. |
| dirty | 0 |
| eu_rights_str_mv | openAccess |
| format | masterThesis |
| fulltext.url.fl_str_mv | https://repositorio.ulisboa.pt/bitstreams/7ff2be70-b8f5-434f-b5a0-40c76711924d/download |
| id | ul_68d9e71aaa847b3c208f0c387d73c19c |
| identifier.url.fl_str_mv | http://hdl.handle.net/10400.5/31161 |
| 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/31161 |
| organization_str_mv | urn:organizationAcronym:ul |
| person_str_mv | Santos, Leonor Barbosa Leal Simões dos |
| publishDate | 2024 |
| 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 outline the tasks accomplished during the internship at LGG Advisors as part of the Master’s in Data Analytics for Business program at ISEG. The main goal of the internship was to enhance the intern's skills in data analytics, with a particular emphasis on refining methods related to data acquisition, processing, and integration within a database framework, as well as improve the ability to create dynamic and informative dashboards. During the internship, the intern was placed with the Data Transformation team at LGG Advisors, where their primary duties involved ETL processes and generating Power BI reports for LGG clients. The acquired skills in ETL processes streamlined data acquisition and preparation and laid the foundation for developing robust and insightful dashboards. The developed dashboards allowed store directors and executives to effectively compare performance across different locations, identify areas for improvement, and implement data-driven decisions that boosted profitability. The internship reinforced the invaluable role of data analytics and business intelligence principles, actionable insights that drive business success.application/pdfpt_PTLeveraging business intelligence through ETL processes and Power BI dashboard developmentSantos, Leonor Barbosa Leal Simões dosFernandes, JesualdoHostingInstitutionOrganizationalRepositório Científico de Acesso Aberto da ULisboae-mailmailto:repositorio@reitoria.ulisboa.ptrepositorio@reitoria.ulisboa.pt2024-06-14T14:05:44Z2024-032024-03-01T00:00:00ZHandlehttp://hdl.handle.net/10400.5/31161http://purl.org/coar/access_right/c_abf2open accessBusiness IntelligencePower BIData VisualisationETL Processes4731089 bytesliteraturehttp://purl.org/coar/resource_type/c_bdccmaster thesishttp://purl.org/coar/access_right/c_abf2application/pdffulltexthttps://repositorio.ulisboa.pt/bitstreams/7ff2be70-b8f5-434f-b5a0-40c76711924d/download |
| spellingShingle | Leveraging business intelligence through ETL processes and Power BI dashboard development Leveraging business intelligence through ETL processes and Power BI dashboard development Santos, Leonor Barbosa Leal Simões dos Business Intelligence Power BI Data Visualisation ETL Processes Santos, Leonor Barbosa Leal Simões dos Business Intelligence Power BI Data Visualisation ETL Processes |
| status | SINGLETON |
| subject.fl_str_mv | Business Intelligence Power BI Data Visualisation ETL Processes |
| title | Leveraging business intelligence through ETL processes and Power BI dashboard development |
| title_full | Leveraging business intelligence through ETL processes and Power BI dashboard development |
| title_fullStr | Leveraging business intelligence through ETL processes and Power BI dashboard development Leveraging business intelligence through ETL processes and Power BI dashboard development |
| title_full_unstemmed | Leveraging business intelligence through ETL processes and Power BI dashboard development Leveraging business intelligence through ETL processes and Power BI dashboard development |
| title_short | Leveraging business intelligence through ETL processes and Power BI dashboard development |
| title_sort | Leveraging business intelligence through ETL processes and Power BI dashboard development |
| topic | Business Intelligence Power BI Data Visualisation ETL Processes |
| topic_facet | Business Intelligence Power BI Data Visualisation ETL Processes |
| url | http://hdl.handle.net/10400.5/31161 |
| visible | 1 |