Abstract

Project Work presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business Intelligence Intelligent traffic planning, the promotion of public transport and the improved interconnectedness of all road users in a city-wide communication infrastructure comprise the mobility characteristics of a smart city. Living in an era of Smart Cities emerging, we can make use of all the data available nowadays to better serve our lives with the best services. All the data generated every day by the Vehicles can be used to get a better insights to improve the quality of the available service as the creation of new routes, increase supervision on problematic areas, among others. This document intends to detail the project carried out at Carris, a public transportation company which operates Lisbon's buses, trams, and funiculars. The master thesis project aims to create a Business Intelligence solution to support planning decisions though the use of a Dashboard by presenting information about all relevant data collected on a bus daily route by the driver in order to get a better understating of a public transportation service and how can the organization improve them to rebuild schedules, create or eliminate routes, do some inspection on tickets validations inside the vehicles, etc. This project is supported by a Microsoft tool called Power BI that enables all the extraction, transformation and loading of data processes, based on an Azure SQL Data Warehouse based on Cloud services. The Business Dashboards are divided in 4 main areas inside the organization and will support Onboard Sales, Ticket validations, Route Planning and Onboard issues reported by the driver.

Abstract

Electric Vehicles (EV) are being introduced in the market, however the reduced energy storage capacity of their batteries and the lack of a high density charging infrastructure, limits their autonomy range. In order to overcome this limitation, we propose the development of a new solution for EV drivers that enables to travel longer distances. This is achieved by integrating some components of the cooperative transport infrastructure, as EV battery charging systems and public transports systems, and by increasing the driving autonomy through energy consumption reduction, achieved by driving efficiency increase. The integration with the charging infrastructure allows planning the journey of the driver, considering the position of charging points, and booking a charging point for a specific time period in order to perform the battery charging. Therefore, the distance that the driver can drive comfortably, without fearing running out of battery, is increased. The integration of the EV with public transports systems allows extending the travel distance beyond the EV drive autonomy, given by the storing capacity of vehicle’s battery. The supplying of information on availability, schedule and price of public transports allows planning the journey of the driver, using the EV and public transportation in a complementary way, through functions like car parking booking (and charging) and ticket buying. Fundação para a Ciência e a Tecnologia (FCT)