Loading...
Publication
Implementação de uma plataforma móvel de apoio à decisão
| Name: | Description: | Size: | Format: | |
|---|---|---|---|---|
| 3.21 MB | Adobe PDF |
Authors
Advisor(s)
Abstract(s)
As organizações, como o Serviço de Estrangeiros e Fronteiras (SEF), necessitam, atualmente, de definir estratégias e políticas, em tempo útil, que permitam potenciar oportunidades e precaverem-se contra contrariedades. O principal objetivo do presente trabalho é desenhar uma prova de conceito que valide a exequibilidade da implementação de uma plataforma móvel de apoio à decisão para responder a esta necessidade, permitindo a criação de um sistema de apoio à decisão para o SEF.
O Sistema de Informação do Passaporte Eletrónico Português servirá como sistema fonte na prova de conceito pois, durante o período do seu funcionamento, reuniu um conjunto de dados significativo que possibilita entender a evolução de indicadores, e, assim, compreender comportamentos, medir desempenhos e prever a ocorrência de fenómenos.
A estratégia de abordagem utilizada na construção do sistema de BI, considerando o contexto de atuação, os requisitos de negócio e os objetivos definidos, foi a de Richard Kimball pelo que a metodologia empregue no trabalho foi a deste autor (Business Dimensional Lifecycle). O âmbito do trabalho realizado conteve-se na fase de planeamento e análise desta metodologia.
Na derivação do modelo dimensional foi testado e aplicado o método proposto por Moody e Kortink. O processo de desenvolvimento de software teve por base os princípios e normas do guia SWEBOK Guide e na elaboração das especificações recorreu-se ao UML 2.0. O plano do projeto foi concebido de acordo com a metodologia do PMBoK.
Os resultados obtidos permitiram a definição da arquitetura da plataforma móvel de apoio à decisão, constituída pela caracterização dos vários componentes que a compõem, desde, o sistema fonte até às especificações da aplicação, passando pela definição dos vários repositórios de dados (staging e metadados) e culminando na solução de datawarehouse, constituída por quatro Data Marts em Star schema. A partir dos Data Marts desenhados evidenciou-se a possibilidade de se obterem indicadores que, com recurso a ferramentas de BI, são capazes de contribuir para a melhoria da qualidade das opções de quem tem que decidir.
A solução concebida e desenhada para a implementação de uma plataforma móvel de apoio à decisão do SIPEP responde, aos objetivos e requisitos de negócio e, não obstante a necessidade de sua validação e implementação em fases e projetos subsequentes, os resultados obtidos no processo efetuado, de análise e desenho, apontam para exequibilidade da prova de conceito aqui descrita.
Organizations such as the Portuguese Border Control and Immigration Services (SEF) presently need to define useful time strategies and policies that will enable them to take the best advantage of opportunities and foresee future difficulties. The main object of this work is to define a proof of concept that will demonstrate the feasibility of implementing a mobile decision support, enabling us to create a Data Warehouse and Business Intelligence system for SEF based on the information of one of its core areas. The Information System for the Portuguese Electronic Passport (SIPEP) will serve as basis for this proof of concept, since it has enabled us to gather a significant amount of data since it was first launched. This data are capable of supporting mechanisms that allow understanding the evolution of indicators and therefore comprise behavior, measure performance and forecasting specific events. Given the context, the business requirements and the goals defined, the approach used in constructing the DW/BI was Richard Kimball’s, using the author’s methodology described in Business Dimensional Lifecycle. The scope of the current work was limited to planning and analysis phases of this methodology. When deriving the dimensional model it was tested by applying the method proposed by Moody and Kortink. The software development was based on the principles and norms in the SWEBOK Guide and resorted to UML for creating the specifications. The project plan was designed according to the Project Management Institute methodology. The results obtained allowed the definition of the architecture of the mobile decision support system by characterizing its various components, from the source system to the program specifications, including the definition of several data repositories (staging and metadata) and ending with the data warehouse solution which comprised four Data Marts on a star schema. From these Data Marts it was possible to obtain indicators which, using BI tools, will contribute towards better quality of choices of who have to decide. The solution conceived and designed to implement a mobile decision support system of SIPEP corresponds to the goals and business requirements and, even though it will require validation and implementation on later stages, the results obtained so far point towards the feasibility of the proof of concept here presented.
Organizations such as the Portuguese Border Control and Immigration Services (SEF) presently need to define useful time strategies and policies that will enable them to take the best advantage of opportunities and foresee future difficulties. The main object of this work is to define a proof of concept that will demonstrate the feasibility of implementing a mobile decision support, enabling us to create a Data Warehouse and Business Intelligence system for SEF based on the information of one of its core areas. The Information System for the Portuguese Electronic Passport (SIPEP) will serve as basis for this proof of concept, since it has enabled us to gather a significant amount of data since it was first launched. This data are capable of supporting mechanisms that allow understanding the evolution of indicators and therefore comprise behavior, measure performance and forecasting specific events. Given the context, the business requirements and the goals defined, the approach used in constructing the DW/BI was Richard Kimball’s, using the author’s methodology described in Business Dimensional Lifecycle. The scope of the current work was limited to planning and analysis phases of this methodology. When deriving the dimensional model it was tested by applying the method proposed by Moody and Kortink. The software development was based on the principles and norms in the SWEBOK Guide and resorted to UML for creating the specifications. The project plan was designed according to the Project Management Institute methodology. The results obtained allowed the definition of the architecture of the mobile decision support system by characterizing its various components, from the source system to the program specifications, including the definition of several data repositories (staging and metadata) and ending with the data warehouse solution which comprised four Data Marts on a star schema. From these Data Marts it was possible to obtain indicators which, using BI tools, will contribute towards better quality of choices of who have to decide. The solution conceived and designed to implement a mobile decision support system of SIPEP corresponds to the goals and business requirements and, even though it will require validation and implementation on later stages, the results obtained so far point towards the feasibility of the proof of concept here presented.
Description
Keywords
Passaporte português Sistemas de apoio à decisão Business intelligence Data Warehouse ETL Metodologia Kimball Smartphones