Analytical enrichment: A target to source approach for missing requirements in decision support systems

• Autor(a) principal: Neto, João Maria Sousa Gomes
• Data de Publicação: 2022
• 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/10071/27553
• topic: Data warehouse; Business intelligence; Missing requirements; Sistemas de apoio à decisão -- Decision support systems; Operational system; Requisitos em falta; Sistemas operacionais

Operational Systems collect transactional data and support the execution of business processes in an organization. These systems are often the data source for Decision Support Systems (DSS), i.e. analytical systems designed to aid business users in the decision-making process. For this reason, several problems in Operational Systems, such as missing data requirements or data quality issues, can lead to unfulfilled analytical needs of the DSS and, consequently, have a negative effect on the Decision Making Process since relevant business queries may not be answered. The objective of this study is to understand the impact of the integration of DSS requirements in the design of operational systems. To achieve this objective, this dissertation uses a real use case DSS to identify the missing requirements and develop a DSS prototype to demonstrate the positive impact on the Decision-Making process when these requirements are fulfilled. Throughout this development, ways of dealing with the various types of missing requirements are going to be addressed. Additionally, a methodology to evaluate the missing requirements is suggested, along with a proposal to classify and understand the missing requirements and how they can be dealt with. Also, the evaluation method is applied, and the developed prototype is compared to the baseline system in order to measure the impact. Finally, the benefits of this integration are shown, as well as other factors that can also constrain the DSS requirements.