Mobility analytics: plan and improve public transportation services though a business intelligence model and dashboards

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.

Original document

The different versions of the original document can be found in:

• http://hdl.handle.net/10362/104278