Desenvolvimento de um Módulo de Business Intelligence para o XTraN Passenger Produto para - Gestão de Frotas de Transportes de Passageiros

Catarina da Conceição Filipe

Key information

Authors:

Catarina da Conceição Filipe (Catarina Da Conceição Filipe)

Supervisors:

Alberto Manuel Ramos da Cunha (Alberto Manuel Ramos da Cunha)

Published in

11/23/2021

Abstract

As companies face an ever-increasing flow of raw data, it is a challenge to deconstruct and gain detailed insight into that information. With a Business Intelligence process, it is possible to get a comprehensive view of the data and translate it into new insights about the activity, enabling informed business decisions. The aim of this project is to develop a Business Intelligence system for XTraN Passenger, Tecmic's fleet and passenger management product. For this process to be supported, a technological infrastructure is required. This document presents the development of the Data Warehouse and Business Intelligence modules of the system. The DW module involves a model that transforms the data extracted from the existing operating aid system in passenger transports, and its insertion into a SQL Server DW. The BI module allows the analysis of the stored data, through reports created by Microsoft’s Power BI, which are integrated in the XTraN Passenger's web platform. The solution was evaluated in usability tests, which concluded that the refreshing of the graphics as the reports are manipulated, is within reasonable latency parameters, until at least, 10 million travel records stored in the DW, 2 years, in an average of 15 thousand daily trips. With this, passenger transport companies, who purchase the product from Tecmic, will be able to monitor key indicators of the activity, and with this make decisions regarding the business model.