A carregar...
Publicação
Design of an Independent Data Mart for the Asset Management Area in the Airport Industry
| Nome: | Descrição: | Tamanho: | Formato: | |
|---|---|---|---|---|
| 2.19 MB | Adobe PDF |
Autores
Orientador(es)
Resumo(s)
Airport infrastructure and assets in the aviation industry require meticulous control and analysis due
to their continuous operations, with the Asset Management department being responsible for this
task. Robust asset management strategies are essential to maintain efficient operations. This study
aims to enhance the Asset Management department's capabilities by delivering pivotal information to
the team to support data-driven decision-making through the development of a structured data
repository, or Data Mart. Currently, the Asset Management area uses an EAM system that provides
asset maintenance and operation information in a slow and static manner. To address this, establishing
a Business Intelligence or Decision support system environment is proposed, beginning with the
creation of a Data Mart. This Data Mart will aggregate and structure data extracted from the EAM
system into an OLAP database, enabling comprehensive analysis and presenting actionable insights
through interactive dashboards. The primary objectives are to design an efficient data flow, integrate
the OLTP system into the Data Mart, establish ETL processes, and deliver the solution to internal clients
for enhanced data analysis. This approach aims to optimize decision-making processes, which
ultimately will impact the improvement of the performance and lifecycle of airport assets.
Descrição
Dissertation presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business Intelligence
Palavras-chave
Asset management Data Mart OLAP data base ETL processes Structured data SDG 8 - Decent work and economic growth SDG 9 - Industry, innovation and infrastructure