Uma Proposta de Business Intelligence com Dados Abertos para o Mar Português

Daniela Ferreira; Joana Leite; Sara Sousa

doi:10.31637/epsir-2024-507

Authors

Daniela Ferreira Polytechnic Institute of Coimbra https://orcid.org/0000-0002-7094-4969
Joana Leite Polytechnic Institute of Coimbra https://orcid.org/0000-0001-6828-9486
Sara Sousa Polytechnic Institute of Coimbra https://orcid.org/0000-0002-7489-7792

DOI:

https://doi.org/10.31637/epsir-2024-507

Keywords:

sustainability, maritime resources, European Union, Portugal, digitalization, Portuguese Sea, Business Intelligence, open data

Abstract

Introduction: Initiatives aimed at the sustainable development of maritime resources have emerged throughout the European Union. However, Portugal, with its privileged geostrategic position and deep historical connection to the Sea, can assume a more prominent position. In this context, this article proposes the digitalization of information about the Portuguese Sea, on an interactive and accessible platform. Methodology: To achieve this, in addition to a detailed literature review, the methodology of a Business Intelligence project is followed, with six phases, from the identification of information needs to the analysis and dissemination of the designed solution. Results: The Business Intelligence solution presented compiles and structures maritime data covering the economic, social, cultural, environmental and geopolitical spheres. Discussion: This solution constitutes a valuable resource for policymakers, allowing the adoption of efficient policies for the more sustainable development of the maritime economy. Conclusions: The innovative and pioneering nature of this proposal in Portugal stands out, which aggregates and structures open maritime data in several dimensions on a platform, promoting a comprehensive understanding of the Sea, crucial for sustainable and informed decisions, maritime scientific advancement and the importance of the ocean in Portuguese society.

Downloads

Download data is not yet available.

Author Biographies

Daniela Ferreira, Polytechnic Institute of Coimbra

Daniela Ferreira has a degree in Accounting and Auditing and a master's degree in Data Analysis and Decision Support Systems from Coimbra Business School | ISCAC, CPI.

Joana Leite, Polytechnic Institute of Coimbra

Joana Leite is an adjunct professor at Coimbra Business School | ISCAC, CPI. She has a PhD in Applied Mathematics, specializing in Statistics, from the University of Coimbra. She is a collaborating member of the Center for Polytechnic and Social Studies of the Center for Organizational and Social Studies of the Polytechnic Institute of Coimbra (CEOS.PP Coimbra) and the Center for Natural Resources, Environment and Society Studies (CERNAS). His areas of interest include time series analysis and forecasting, econometrics and statistics applied to management and sustainability. He is the author of articles in national and international refereed journals.

Sara Sousa, Polytechnic Institute of Coimbra

Sara Sousa is an adjunct professor at Coimbra Business School | ISCAC, CPI. She has a PhD in Economics from the University of Minho and a Master's in Economics from the University of Coimbra. She is a member of the Center for Natural Resources, Environment and Society Studies (CERNAS). His areas of interest include environmental economics, sustainability, consumer behavior, renewable energies and the economic value of environmental impacts. Author of articles in national and international refereed journals.

References

Allam, Z., Bibri, S. E., & Sharpe, S. A. (2022). The Rising Impacts of the COVID-19 Pandemic and the Russia–Ukraine War: Energy Transition, Climate Justice, Global Inequality, and Supply Chain Disruption. Resources, 11(11), 99. https://doi.org/10.3390/resources11110099 DOI: https://doi.org/10.3390/resources11110099

Cheng, C., Zhong, H., & Cao, L. (2020). Facilitating speed of internationalization: The roles of business intelligence and organizational agility. Journal of Business Research, 110, 95-103. https://doi.org/10.1016/j.jbusres.2020.01.003 DOI: https://doi.org/10.1016/j.jbusres.2020.01.003

Coughlan, T. (2020). The use of open data as a material for learning. Educational Technology Research and Development, 68, 383-411. https://doi.org/10.1007/s11423-019-09706-y DOI: https://doi.org/10.1007/s11423-019-09706-y

Cunha, T. P. (2011). Portugal e o mar - À redescoberta da Geografia. Relógio.

Delen, D., Moscato, G., & Toma, I. L. (2018). The impact of real-time business intelligence and advanced analytics on the behaviour of business decision makers. In 2018 International Conference on Information Management and Processing (ICIMP) (pp. 49-53). IEEE, 2018. https://doi.org/10.1109/ICIMP1.2018.8325840 DOI: https://doi.org/10.1109/ICIMP1.2018.8325840

DGPM. (2021). Estratégia Nacional para o Mar 2021-2030. https://bit.ly/3LoJNl9

Elena, C. (2011). Business intelligence. Journal of Knowledge Management, Economics and Information Technology, 1(2), 1-12. https://www.scientificpapers.org/economics/business-intelligence/

Ertör, I. & Hadjimichael, M. (2020). Editorial: Blue degrowth and the politics of the sea: rethinking the blue economy. Sustainability Science, 15, 1-10. https://doi.org/10.1007/s11625-019-00772-y DOI: https://doi.org/10.1007/s11625-019-00772-y

European Commission. (2019). Pacto Ecológico Europeu. https://bit.ly/3xYXGn0

European Commission. (2020). Uma Nova Abordagem da Estratégia Marítima para a Região Atlântica - Plano de Ação para o Atlântico 2.0.

https://eur-lex.europa.eu/legal-content/PT/ALL/?uri=CELEX:52011DC0782

European Commission. (2021). Communication from The Commission to The European Parliament, The Council, The European Economic and Social Committee and The Committee of The Regions on a new approach for a sustainable blue economy in the EU Transforming the EU’s Blue Economy for a Sustainable Future.

https://eur-lex.europa.eu//legal-content/EN/TXT/?uri=COM:2021:240:FIN

European Commission. (2022). Energy Emergency: preparing, purchasing and protecting the EU together. https://ec.europa.eu/commission/presscorner/detail/en/fs_22_6227

Frédéric-Gouardères. (2023). Regiões ultraperiféricas (RUP). Parlamento Europeu. https://www.europarl.europa.eu/factsheets/pt/sheet/100/outermost-regions-ors-

Galanakis, C. M. (2023). The “vertigo” of the food sector within the triangle of climate change, the post-pandemic world, and the Russian-Ukrainian war. Foods, 12(4), 721. https://doi.org/10.3390/foods12040721 DOI: https://doi.org/10.3390/foods12040721

Hariharan, N. K. (2018). Data Sources for Business Intelligence. International Journal of Innovations in Engineering Research and Technology, 5(11), 75-80. https://www.neliti.com/publications/429382/data-sources-for-business-intelligence

Hasnain, A. & Rebholz-Schuhmann, D. (2018). Assessing FAIR data principles against the 5-star open data principles. In The Semantic Web: ESWC 2018 Satellite Events: ESWC 2018 Satellite Events, Heraklion, Crete, Greece, June 3-7, 2018, Revised Selected Papers 15 (pp. 469-477). https://doi.org/10.1007/978-3-319-98192-5_60 DOI: https://doi.org/10.1007/978-3-319-98192-5_60

Huston, P., Edge, V. L., & Bernier, E. (2019). Reaping the benefits of open data in public health. Canada Communicable Disease Report, 45(11), 252. https://doi.org/10.14745/ccdr.v45i10a01 DOI: https://doi.org/10.14745/ccdr.v45i10a01

Inkinen, T., Helminen, R. & Saarikoski, J. (2019). Port digitalization with open data: Challenges, opportunities, and integrations. Journal of Open Innovation: Technology, Market, and Complexity, 5(2), 30. https://doi.org/10.3390/joitmc5020030 DOI: https://doi.org/10.3390/joitmc5020030

Izvorski, I., Lokshin, M., Norfleet, J. R. R., Singer, D. & Torre, I. (2023). Europe and Central Asia Economic Update, Spring 2023: Weak Growth, High Inflation, and a Cost-of-Living Crisis. The World Bank. https://bit.ly/4d131co DOI: https://doi.org/10.1596/978-1-4648-1982-7

Jati, P. H. P., Lin, Y., Nodehi, S., Cahyono, D. B. & van Reisen, M. (2022). FAIR versus open data: A comparison of objectives and principles. Data Intelligence, 4(4), 867-881. https://doi.org/10.1162/dint_a_00176 DOI: https://doi.org/10.1162/dint_a_00176

Jiang, Q., Xu, Z., Ye, G., Pahlow, M., Hu, M., & Qu, S. (2022). A systematic scoping review of environmental and socio-economic effects of COVID-19 on the global ocean-human system. Science of The Total Environment, 849, 157925. https://doi.org/10.1016/j.scitotenv.2022.157925 DOI: https://doi.org/10.1016/j.scitotenv.2022.157925

Khatuwal, V. S., & Puri, D. (2022). Business Intelligence Tools for Dashboard Development. In 2022 3rd International Conference on Intelligent Engineering and Management (ICIEM), (pp. 128-131). IEEE. https://doi.org/10.1109/ICIEM54221.2022.9853086 DOI: https://doi.org/10.1109/ICIEM54221.2022.9853086

Kitsios, F., & Kamariotou, M. (2023). Digital innovation and entrepreneurship transformation through open data hackathons: Design strategies for successful start-up settings. International Journal of Information Management, 69, 102472. https://doi.org/10.1016/j.ijinfomgt.2022.102472 DOI: https://doi.org/10.1016/j.ijinfomgt.2022.102472

Klein, T., Nilsson, M., Persson, A., & Håkansson, B. (2017). From open data to open analyses—New opportunities for environmental applications? Environments, 4(2), 32. https://www.mdpi.com/2076-3298/4/2/32 DOI: https://doi.org/10.3390/environments4020032

Lee, C., & Lim, C. (2021). From technological development to social advance: A review of Industry 4.0 through machine learning. Technological Forecasting and Social Change, 167, 120653. https://doi.org/10.1016/j.techfore.2021.120653 DOI: https://doi.org/10.1016/j.techfore.2021.120653

Molloy, J. C. (2011). The open knowledge foundation: open data means better science. PLoS Biology, 9(12), e1001195. https://doi.org/10.1371/journal.pbio.1001195 DOI: https://doi.org/10.1371/journal.pbio.1001195

Munawar. (2021). Extract Transform Loading (ETL) Based Data Quality for Data Warehouse Development. In 2021 1st International Conference on Computer Science and Artificial frIntelligence (ICCSAI), (pp. 373-378). IEEE. https://doi.org/10.1109/ICCSAI53272.2021.9609770 DOI: https://doi.org/10.1109/ICCSAI53272.2021.9609770

Nikiforova, A. (2021). Smarter open government data for society 5.0: are your open data smart enough? Sensors, 21(15), 5204. https://doi.org/10.3390/s21155204 DOI: https://doi.org/10.3390/s21155204

Okhrimenko, I., Sovik, I., Pyankova, S., & Lukyanova, A. (2019). Digital transformation of the socio-economic system: prospects for digitalization in society. Revista Espacios, 40(38). http://www.ifac.portafolio.revistaespacios.com/a19v40n38/a19v40n38p26.pdf

Open Knowledge Foundation. (2015). Open Definition 2.1. https://opendefinition.org/od/2.1/en/

Parlamento Europeu. (2022). Política marítima integrada da união europeia. https://bit.ly/4f5Tl2b

Pavia, J. F. (2019). A Unidade Estratégica do Atlântico: Importante para Portugal, Nem Tanto para o Brasil? Nação e Defesa, 154, 55-68. https://bit.ly/4f044el

Pereira, S. J. (2022). A economia do mar na triangulação Portugal - Brasil - África: o Mar Lusófono enquanto espaço de afirmação estratégica. Negócios Estrangeiros, 22, 122-138. https://bit.ly/3zHhewK

Prakash, S. S. (2020). Evolution of Data Warehouses to Data Lakes for Enterprise Business Intelligence. International Journal of Innovative Research in Computerand Communication Engineering, 8(4), 1038-1042. https://bit.ly/3y0plnx

Rayner, R., Jolly, C. y Gouldman, C. (2019). Ocean observing and the blue economy. Frontiers in Marine Science, 6, 1-6. https://doi.org/10.3389/fmars.2019.00330 DOI: https://doi.org/10.3389/fmars.2019.00330

Romero, C. A. T., Ortiz, J. H., Khalaf, O. I., & Prado, A. R. (2021). Business Intelligence: Business Evolution after Industry 4.0. Sustainability, 13(18), 1-12. https://doi.org/10.3390/su131810026 DOI: https://doi.org/10.3390/su131810026

Silva, A. S. (2018). Como abordar a identidade nacional portuguesa? Todas as Artes: Revista Luso-Brasileira de Artes e Cultura, 1(1), 9-20. https://doi.org/10.21747/21843805/tav1n1a1 DOI: https://doi.org/10.21747/21843805/tav1n1a1

Steven, A. D. L., Vanderklift, M. A. & Bohler-Muller, N. (2019). A new narrative for the Blue Economy and Blue Carbon. Journal of the Indian Ocean Region, 15(2), 123-128. https://doi.org/10.1080/19480881.2019.1625215 DOI: https://doi.org/10.1080/19480881.2019.1625215

Tanhua, T., Pouliquen, S., Hausman, J., O’brien, K., Bricher, P., De Bruin, T., Buck, J. J. H., Burger, E. F., Carval, T. & Casey, K. S. (2019). Ocean FAIR data services. Frontiers in Marine Science, 6, 440. https://doi.org/10.3389/fmars.2019.00440 DOI: https://doi.org/10.3389/fmars.2019.00440

Trigunayat, A. (2024). Indian Ocean Region Problems Further Compounded by West Asian Conflicts and Crisis. Journal of Indian Ocean Studies, 32(1), 39-46. https://doi.org/10.32381/JIOS.2024.32.01.4

Turschwell, M. P., Hayes, M. A., Lacharité, M., Abundo, M., Adams, J., Blanchard, J., Brain, E., Buelow, C. A., Bulman, C., Condie, S. A., Connolly, R. M., Dutton, I., Fulton, E. A., Gallagher, S., Maynard, D., Pethybridge, H., Plagányi, E., Porobic, J., Taelman, S. E., Trebilco, R., Woods, G., & Brown, C. J. (2022). A review of support tools to assess multi-sector interactions in the emerging offshore Blue Economy. Environmental Science and Policy, 133, 203-214. https://doi.org/10.1016/j.envsci.2022.03.016 DOI: https://doi.org/10.1016/j.envsci.2022.03.016

United Nations. (2015). Transforming our world: the 2030 Agenda for Sustainable Development. United Nations: New York, NY, USA. https://sdgs.un.org/2030agenda

Vedder, R. G., Vanecek, M. T., Guynes, C. S., & Cappel, J. J. (1999). CEO and CIO perspectives on competitive intelligence. Communications of the ACM, 42(8), 108-116. https://dl.acm.org/doi/pdf/10.1145/310930.310982 DOI: https://doi.org/10.1145/310930.310982

Wenhai, L., Cusack, C., Baker, M., Tao, W., Mingbao, C., Paige, K., Xiaofan, Z., Levin, L., Escobar, E., Amon, D., Yue, Y., Reitz, A., Sepp Neves, A. A., O’Rourke, E., Mannarini, G., Pearlman, J., Tinker, J., Horsburgh, K. J., Lehodey, P., Pouliquen, S., & Yufeng, Y. (2019). Successful blue economy examples with an emphasis on international perspectives. Frontiers in Marine Science, 6, 1-14. https://doi.org/10.3389/fmars.2019.00261 DOI: https://doi.org/10.3389/fmars.2019.00261

Wilkinson, M. D., Dumontier, M., Aalbersberg, Ij. J., Appleton, G., Axton, M., Baak, A., Blomberg, N., Boiten, J.-W., da Silva Santos, L. B., & Bourne, P. E. (2016). The FAIR Guiding Principles for scientific data management and stewardship. Scientific Data, 3(1), 1-9. https://doi.org/10.1038/sdata.2016.18 DOI: https://doi.org/10.1038/sdata.2016.18

Winther, J.-G., Dai, M., Rist, T., Hoel, A. H., Li, Y., Trice, A., Morrissey, K., Juinio-Meñez, M. A., Fernandes, L., & Unger, S. (2020). Integrated ocean management for a sustainable ocean economy. Nature Ecology & Evolution, 4(11), 1451-1458. https://doi.org/10.1038/s41559-020-1259-6 DOI: https://doi.org/10.1038/s41559-020-1259-6