Publicação
Solar boats in the amazon: a cloud data warehouse solution
| Resumo: | Electric transportation has risen due to concerns about global warming and recent changes toward sustainable transportation. However, it is not easy to measure the actual sustainability of electric vehicle transportation. Kara Solar is a non-profit organization that builds solar-powered boats in the Amazon rainforest, providing clean transportation for Indigenous communities. These solarpowered boats contribute to sustainable transportation in the Amazon rainforest and might prevent deforestation. Typically, sustainability is represented by social, environmental, and economic. It is important for Kara Solar to be able to measure its impact on these three pillars. Therefore, there is an intrinsic need to make sense of its data by collecting, storing, and analyzing it. The main objective of this project is to develop an artifact for the collection, storage, and analysis of Kara Solar’s data to measure its impact via proxy variables to at least one of these sustainability pillars. The artifact provides a cloud-native data warehousing solution that is scalable to process big data generated by IoT devices. The artifact features a Data Warehouse architecture based on the Kimball approach with modern components such as a Data Lake, ELT process, and transformations with a data build tool. The artifact proved useful for collecting, storing, transforming, and analyzing Kara Solar’s data from multiple sources, showcasing to stakeholders the impact within the Social Impact of Sustainability. |
|---|---|
| Autores principais: | Eguiguren, Daniel Esteban Enriquez |
| Assunto: | Data Lakehouse Data Warehouse Business Intelligence Cloud Computing |
| Ano: | 2025 |
| 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_ | 1865920800420265984 |
|---|---|
| author | Eguiguren, Daniel Esteban Enriquez |
| author_facet | Eguiguren, Daniel Esteban Enriquez Eguiguren, Daniel Esteban Enriquez |
| author_role | author |
| contributor_name_str_mv | Costa, Carlos Manuel Jorge da Caldeira, Mário Fernando Maciel Romão, Flávio Alexandre Costa Repositório Científico de Acesso Aberto da ULisboa |
| country_str | PT |
| creators_json_str | [{\"Person.name\":\"Eguiguren, Daniel Esteban Enriquez\"}] |
| datacite.contributors.contributor.contributorName.fl_str_mv | Costa, Carlos Manuel Jorge da Caldeira, Mário Fernando Maciel Romão, Flávio Alexandre Costa Repositório Científico de Acesso Aberto da ULisboa |
| datacite.creators.creator.creatorName.fl_str_mv | Eguiguren, Daniel Esteban Enriquez |
| datacite.date.Accepted.fl_str_mv | 2025-01-01T00:00:00Z |
| datacite.date.available.fl_str_mv | 2025-06-11T10:37:31Z |
| datacite.date.embargoed.fl_str_mv | 2025-06-11T10:37:31Z |
| datacite.rights.fl_str_mv | http://purl.org/coar/access_right/c_abf2 |
| datacite.subjects.subject.fl_str_mv | Data Lakehouse Data Warehouse Business Intelligence Cloud Computing |
| datacite.titles.title.fl_str_mv | Solar boats in the amazon: a cloud data warehouse solution |
| dc.contributor.none.fl_str_mv | Costa, Carlos Manuel Jorge da Caldeira, Mário Fernando Maciel Romão, Flávio Alexandre Costa Repositório Científico de Acesso Aberto da ULisboa |
| dc.creator.none.fl_str_mv | Eguiguren, Daniel Esteban Enriquez |
| dc.date.Accepted.fl_str_mv | 2025-01-01T00:00:00Z |
| dc.date.available.fl_str_mv | 2025-06-11T10:37:31Z |
| dc.date.embargoed.fl_str_mv | 2025-06-11T10:37:31Z |
| dc.format.none.fl_str_mv | application/pdf |
| dc.identifier.none.fl_str_mv | http://hdl.handle.net/10400.5/101479 |
| 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 | Data Lakehouse Data Warehouse Business Intelligence Cloud Computing |
| dc.title.fl_str_mv | Solar boats in the amazon: a cloud data warehouse solution |
| dc.type.none.fl_str_mv | http://purl.org/coar/resource_type/c_bdcc |
| description | Electric transportation has risen due to concerns about global warming and recent changes toward sustainable transportation. However, it is not easy to measure the actual sustainability of electric vehicle transportation. Kara Solar is a non-profit organization that builds solar-powered boats in the Amazon rainforest, providing clean transportation for Indigenous communities. These solarpowered boats contribute to sustainable transportation in the Amazon rainforest and might prevent deforestation. Typically, sustainability is represented by social, environmental, and economic. It is important for Kara Solar to be able to measure its impact on these three pillars. Therefore, there is an intrinsic need to make sense of its data by collecting, storing, and analyzing it. The main objective of this project is to develop an artifact for the collection, storage, and analysis of Kara Solar’s data to measure its impact via proxy variables to at least one of these sustainability pillars. The artifact provides a cloud-native data warehousing solution that is scalable to process big data generated by IoT devices. The artifact features a Data Warehouse architecture based on the Kimball approach with modern components such as a Data Lake, ELT process, and transformations with a data build tool. The artifact proved useful for collecting, storing, transforming, and analyzing Kara Solar’s data from multiple sources, showcasing to stakeholders the impact within the Social Impact of Sustainability. |
| dirty | 0 |
| eu_rights_str_mv | openAccess |
| format | masterThesis |
| fulltext.url.fl_str_mv | https://repositorio.ulisboa.pt/bitstreams/70704aaf-4724-4664-8e8f-5ab2e1a537ff/download |
| id | ul_61337d4b7fa0e9ea7ef443decd6cd764 |
| identifier.url.fl_str_mv | http://hdl.handle.net/10400.5/101479 |
| 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/101479 |
| organization_str_mv | urn:organizationAcronym:ul |
| person_str_mv | Eguiguren, Daniel Esteban Enriquez |
| publishDate | 2025 |
| 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_PTElectric transportation has risen due to concerns about global warming and recent changes toward sustainable transportation. However, it is not easy to measure the actual sustainability of electric vehicle transportation. Kara Solar is a non-profit organization that builds solar-powered boats in the Amazon rainforest, providing clean transportation for Indigenous communities. These solarpowered boats contribute to sustainable transportation in the Amazon rainforest and might prevent deforestation. Typically, sustainability is represented by social, environmental, and economic. It is important for Kara Solar to be able to measure its impact on these three pillars. Therefore, there is an intrinsic need to make sense of its data by collecting, storing, and analyzing it. The main objective of this project is to develop an artifact for the collection, storage, and analysis of Kara Solar’s data to measure its impact via proxy variables to at least one of these sustainability pillars. The artifact provides a cloud-native data warehousing solution that is scalable to process big data generated by IoT devices. The artifact features a Data Warehouse architecture based on the Kimball approach with modern components such as a Data Lake, ELT process, and transformations with a data build tool. The artifact proved useful for collecting, storing, transforming, and analyzing Kara Solar’s data from multiple sources, showcasing to stakeholders the impact within the Social Impact of Sustainability.application/pdfpt_PTSolar boats in the amazon: a cloud data warehouse solutionEguiguren, Daniel Esteban EnriquezCosta, Carlos Manuel Jorge daCaldeira, Mário Fernando MacielRomão, Flávio Alexandre CostaHostingInstitutionOrganizationalRepositório Científico de Acesso Aberto da ULisboae-mailmailto:repositorio@reitoria.ulisboa.ptrepositorio@reitoria.ulisboa.pt2025-06-11T10:37:31Z2025-012025-01-01T00:00:00ZHandlehttp://hdl.handle.net/10400.5/101479http://purl.org/coar/access_right/c_abf2open accessData LakehouseData WarehouseBusiness IntelligenceCloud Computing1947015 bytesliteraturehttp://purl.org/coar/resource_type/c_bdccmaster thesishttp://purl.org/coar/access_right/c_abf2application/pdffulltexthttps://repositorio.ulisboa.pt/bitstreams/70704aaf-4724-4664-8e8f-5ab2e1a537ff/download |
| spellingShingle | Solar boats in the amazon: a cloud data warehouse solution Solar boats in the amazon: a cloud data warehouse solution Eguiguren, Daniel Esteban Enriquez Data Lakehouse Data Warehouse Business Intelligence Cloud Computing Eguiguren, Daniel Esteban Enriquez Data Lakehouse Data Warehouse Business Intelligence Cloud Computing |
| status | SINGLETON |
| subject.fl_str_mv | Data Lakehouse Data Warehouse Business Intelligence Cloud Computing |
| title | Solar boats in the amazon: a cloud data warehouse solution |
| title_full | Solar boats in the amazon: a cloud data warehouse solution |
| title_fullStr | Solar boats in the amazon: a cloud data warehouse solution Solar boats in the amazon: a cloud data warehouse solution |
| title_full_unstemmed | Solar boats in the amazon: a cloud data warehouse solution Solar boats in the amazon: a cloud data warehouse solution |
| title_short | Solar boats in the amazon: a cloud data warehouse solution |
| title_sort | Solar boats in the amazon: a cloud data warehouse solution |
| topic | Data Lakehouse Data Warehouse Business Intelligence Cloud Computing |
| topic_facet | Data Lakehouse Data Warehouse Business Intelligence Cloud Computing |
| url | http://hdl.handle.net/10400.5/101479 |
| visible | 1 |