BI dashboard to empower PAC with near real-time decision support

Detalhes bibliográficos
Autor(a) principal: Soares, Ricardo Jorge Bento
Data de Publicação: 2023
Tipo de documento: Dissertação
Idioma: eng
Título da fonte: Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
Texto Completo: http://hdl.handle.net/10362/159740
Resumo: Project Work presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Information Systems and Technologies Management
id RCAP_6108c954d003d9e258e19b5dabf82820
oai_identifier_str oai:run.unl.pt:10362/159740
network_acronym_str RCAP
network_name_str Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
repository_id_str 7160
spelling BI dashboard to empower PAC with near real-time decision supportBusiness IntelligenceDecision SupportReal-time DataAviationData WarehouseData ModelDashboardOperations PerformanceAgileScrumSDG 8 - Decent work and economic growthSDG 9 - Industry, innovation and infrastructureDomínio/Área Científica::Ciências Naturais::Ciências da Computação e da InformaçãoProject Work presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Information Systems and Technologies ManagementThis master's thesis focuses on the development and implementation of a Business Intelligence (BI) dashboard for an airline company. The objective is to provide a comprehensive data visualization solution that enables real-time monitoring and analysis of key performance indicators (KPIs) in the aviation industry. The research design combines qualitative and quantitative methods. The qualitative approach involves gathering requirements from stakeholders through the Agile methodology and iterative user feedback. The quantitative approach includes data analysis and the construction of a data model and dashboard using MicroStrategy. The data model follows the star schema model, facilitating efficient data integration and optimized query performance. The requirement-gathering process involved capturing relevant KPIs and dimensions from existing reports and functional requirements from stakeholders. These requirements were categorized into topics such as general requirements, on-time performance (OTP), crew requirements, cancelled legs, aircraft on the ground (AOGs), maintenance, and spares. The results section showcases the developed BI dashboard, emphasizing the dashboard design, selected KPIs, and visualizations. The user interface offers intuitive navigation and interactive features to facilitate data exploration and decision-making. User testing and feedback were incorporated to improve the dashboard's usability and effectiveness. Furthermore, the physical data model based on the star schema model contributes to query performance optimization, meeting the requirement of response times below 5 seconds for live dashboard usage. The use of best practices and methodologies, particularly those advocated by Kimball and Caserta, enhances the data modelling process. In conclusion, this master's thesis project presents a business intelligence dashboard tailored for the airline industry. By leveraging the power of data visualization and analytics, the dashboard empowers stakeholders to make informed decisions and gain valuable insights into various aspects of airline operations. The research contributes to the field of information management by showcasing the application of agile development, star schema modelling, and user-centric design in developing a robust BI solution for aviation.Naranjo-Zolotov, Mijail JuanovichRUNSoares, Ricardo Jorge Bento2023-11-09T17:44:22Z2023-10-232023-10-23T00:00:00Zinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisapplication/pdfhttp://hdl.handle.net/10362/159740TID:203383419enginfo:eu-repo/semantics/openAccessreponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãoinstacron:RCAAP2024-03-11T05:42:12Zoai:run.unl.pt:10362/159740Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireopendoar:71602024-03-20T03:57:41.325791Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãofalse
dc.title.none.fl_str_mv BI dashboard to empower PAC with near real-time decision support
title BI dashboard to empower PAC with near real-time decision support
spellingShingle BI dashboard to empower PAC with near real-time decision support
Soares, Ricardo Jorge Bento
Business Intelligence
Decision Support
Real-time Data
Aviation
Data Warehouse
Data Model
Dashboard
Operations Performance
Agile
Scrum
SDG 8 - Decent work and economic growth
SDG 9 - Industry, innovation and infrastructure
Domínio/Área Científica::Ciências Naturais::Ciências da Computação e da Informação
title_short BI dashboard to empower PAC with near real-time decision support
title_full BI dashboard to empower PAC with near real-time decision support
title_fullStr BI dashboard to empower PAC with near real-time decision support
title_full_unstemmed BI dashboard to empower PAC with near real-time decision support
title_sort BI dashboard to empower PAC with near real-time decision support
author Soares, Ricardo Jorge Bento
author_facet Soares, Ricardo Jorge Bento
author_role author
dc.contributor.none.fl_str_mv Naranjo-Zolotov, Mijail Juanovich
RUN
dc.contributor.author.fl_str_mv Soares, Ricardo Jorge Bento
dc.subject.por.fl_str_mv Business Intelligence
Decision Support
Real-time Data
Aviation
Data Warehouse
Data Model
Dashboard
Operations Performance
Agile
Scrum
SDG 8 - Decent work and economic growth
SDG 9 - Industry, innovation and infrastructure
Domínio/Área Científica::Ciências Naturais::Ciências da Computação e da Informação
topic Business Intelligence
Decision Support
Real-time Data
Aviation
Data Warehouse
Data Model
Dashboard
Operations Performance
Agile
Scrum
SDG 8 - Decent work and economic growth
SDG 9 - Industry, innovation and infrastructure
Domínio/Área Científica::Ciências Naturais::Ciências da Computação e da Informação
description Project Work presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Information Systems and Technologies Management
publishDate 2023
dc.date.none.fl_str_mv 2023-11-09T17:44:22Z
2023-10-23
2023-10-23T00:00:00Z
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
dc.type.driver.fl_str_mv info:eu-repo/semantics/masterThesis
format masterThesis
status_str publishedVersion
dc.identifier.uri.fl_str_mv http://hdl.handle.net/10362/159740
TID:203383419
url http://hdl.handle.net/10362/159740
identifier_str_mv TID:203383419
dc.language.iso.fl_str_mv eng
language eng
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.source.none.fl_str_mv reponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
instacron:RCAAP
instname_str Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
instacron_str RCAAP
institution RCAAP
reponame_str Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
collection Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
repository.name.fl_str_mv Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
repository.mail.fl_str_mv
_version_ 1799138158877605888

Registros relacionados