Loading...
Publication
Data Warehouse & Business Intelligence SAPA: sistema de atribuição de produtos de apoio - SAPA
| Name: | Description: | Size: | Format: | |
|---|---|---|---|---|
| 886.39 KB | Adobe PDF |
Authors
Advisor(s)
Abstract(s)
A entidade gestora do sistema de atribuição de produtos de apoio, o Instituto
Nacional para Reabilitação, identificou a necessidade de possuir uma ferramenta que
permita efetuar análises e extrair diversa informação estatística sobre os processos de
atribuição de qualquer produto, instrumento, equipamento, tecnologia e software usado
por uma pessoa com deficiência, vulgo, produtos de apoio.
O presente projeto é a concretização do acima referenciado, desenvolvimento de
um Data Warehouse e de relatórios, como uma ferramenta de Business Intelligence.
Inicialmente foi efetuado um estudo aprofundado das regras do processo de
negócio e do modelo relacional, que suporta o sistema de gestão de base de dados
operacionais. Foram efetuadas várias reuniões com os representantes da entidade
gestora e um estudo dos requisitos do projeto, através da criação de queries ao sistema
fonte de dados.
Após refinamento dos requisitos da informação estatística e conclusão da fase de
análise, que inclui-o atividades como identificação de fontes, destino de dados e
modelização, foi desenvolvido o Data Warehouse. Trabalho envolvendo os inerentes
processos de extração, transformação e carregamento, seguido dos testes, automatização
de processos e colocação em produção.
O Data Warehouse, desenvolvido permitiu concretizar a implementação da
infraestrutura de análise, efetuado com a ferramenta de Business Intelligence e assim
atingir o objetivo final, possuir informação estatística, atualizada e precisa.
The managing body responsible for allocating disability equipment, the National Institute for Rehabilitation (Instituto Nacional para Reabilitação), has identified the need for a tool that allows the analysis and extraction of all the statistical information related to the process of granting disability equipment. In order to achieve this objective, the current project developed a Data Warehouse and reporting system using a Business Intelligence tool. The first step was to conduct an in-depth study focusing on the business process rules, and the relational model that supports the database management system. In order to determine the project’s requirements, various meetings were held with the representatives of the managing body, as well as data source queries. The Data Warehouse was created after refining the requirements of the statistical information and the completion of the analysis step, which included tasks such as source identification, data destination, and model-building. This involved the extraction, transformation and loading of the data, which was followed by testing, process automation, and the production stage. After loading the Data Warehouse, the data is organised in a way that allows the deployment of the analysis infrastructure, via the Business Intelligence tool, in order to achieve the final goal – to have updated and accurate statistical information.
The managing body responsible for allocating disability equipment, the National Institute for Rehabilitation (Instituto Nacional para Reabilitação), has identified the need for a tool that allows the analysis and extraction of all the statistical information related to the process of granting disability equipment. In order to achieve this objective, the current project developed a Data Warehouse and reporting system using a Business Intelligence tool. The first step was to conduct an in-depth study focusing on the business process rules, and the relational model that supports the database management system. In order to determine the project’s requirements, various meetings were held with the representatives of the managing body, as well as data source queries. The Data Warehouse was created after refining the requirements of the statistical information and the completion of the analysis step, which included tasks such as source identification, data destination, and model-building. This involved the extraction, transformation and loading of the data, which was followed by testing, process automation, and the production stage. After loading the Data Warehouse, the data is organised in a way that allows the deployment of the analysis infrastructure, via the Business Intelligence tool, in order to achieve the final goal – to have updated and accurate statistical information.
Description
Trabalho de Projeto, submetido como requisito
parcial para obtenção do grau de Mestre em
Informática de Gestão.
Keywords
Data Warehouse Business Intelligence Produtos de Apoio Disability Equipment
Citation
Publisher
Instituto Politécnico de Setúbal. Escola Superior de Tecnologia de Setúbal