Team Members

Project Description

Although Canberra has launched its new public transport system not long ago, there seem to exist a gap between the new system’s real performance and passengers’ expectations. The ACT government has been swamped with passengers’ complaints including driver shortage, unpunctuality, late announcement of malfunction, missing bus stop alert, traffic congestion, etc. These existing problems not only degrade the travel experience of passengers but also pose a challenge to government transport administration. After the analysis of open data of ACT transport, we concluded that the underlying reason of this negative phenomenon is inefficient communication between passengers and transport operators, hence, in the short run, an app named EasyWay with a set of integrated functions is devised to streamline the entire transport service from departure to arrival while in the long run, we recommend to introduce self-driving electric vehicles to fulfill sustainability.
There are 3 entries for 2 kinds of users: passengers, authorized officers. For passengers, functions are displayed as follows
 daily announcement of
 recommendation for personalized route
 estimate expense of travel price and travel time
 real time bus/light rail tracker
 anonymous comment towards the degree of safety, punctuality and crowdedness after trip is finalized
 link to credit/debit card
 display bar code to pay for the trip
For authorized officers, functions are displayed as follows
 age of the buses in operation → guide maintenance service
 incident rate → guide driver management
 visualization of passengers’ real-time feedback → guide flexible route rearrangement

Data Story

Data related public transport from Open Data Portal dataACT that used, table names and link addresses are below.
Passenger Journeys By Week By Ticket Type retrieved from https://www.data.act.gov.au/Transport/Passenger-Journeys-By-Week-By-Ticket-Type/jia3-rxue
On Time Running By Week - First Stop Only retrieved from https://www.data.act.gov.au/Transport/On-Time-Running-By-Week-First-Stop-Only/diwx-p2be
Budget 2017-2018 - by category table retrieved from https://www.data.act.gov.au/Government-and-Transparency/Budget-2017-2018-by-category-table/dxuq-hc4u
Budget 2018-2019 - by category table retrieved from https://www.data.act.gov.au/Government-and-Transparency/Budget-2018-2019-by-category-table/dkp7-zmia
Budget 2019-2020 - by category table retrieved from https://www.data.act.gov.au/Government-and-Transparency/Budget-2019-2020-by-category-table/gtu5-8j7s
ACT Population Projections retrieved from https://www.data.act.gov.au/People-and-Society/ACT-Population-Projections/y438-27ka

Cleaning all data prepared and import these formalized data into models, which created in the Modeler to form diagrams.
Data Preprocessing
Using Excel to make data cleaning. Combine budget from recent years, list the sum number as an attribute. When data comes from week by week, choose the first week and the last one or choose the last one.
Data Analyzing and Result
Create a model in SPSS Modeler to display data by several clear diagrams.