Introduction

The Transit Corridor Analytics is a set of code-based processes that provide insightful visualisations and statistics on the usage and performance of the bus network at various levels of aggregation.

The Extract, Transform, and Load (ETL) process within the Transit Corridor Analytics takes raw input data—such as ticketing data (transactions and trip stop timings), details of scheduled services, and HASTUS1 inputs (converting bus routes to the underlying road network)—and converts them into curated datasets. These datasets are then used in Tableau dashboards to visualise key performance metrics. The two primary visualisation products that leverage these datasets are:

  • Corridor Explorer (CE) dashboards

    These dashboards allow users to explore bus performance at corridor, segment, and stop levels. They help identify constraints, low-performing sections, or areas of the network that may warrant further investigation. The dashboard data is highly filterable and dissectible, enabling users to create custom views and analyses.

  • Bus Corridor Action Plan (BCAP) dashboards

    While utilising the same ETL process, BCAP dashboards are designed to spatially identify and quantify bus network performance “hotspots” at the segment level across South East Queensland’s (SEQ) bus network. The dashboard ranks and compares performance at the segment level using five key metrics related to efficiency and reliability. Users can filter results by road type (e.g., state vs. local roads, busway vs. non-busway), TMR region, and Local Government Area (LGA). Additional data, such as the number of services and passengers, operator feedback 2, and bus stop utilisation, are included to provide further insights into the nature and magnitude of performance at the segment level.

The overall ETL process, illustrated in the figure below, outlines the high-level steps involved. The resulting outputs are not only used in Corridor Explorer and BCAP, but can also be adapted to support custom dashboards and analyses.

Alt text

  1. TransLink’s scheduling software developed by Giro Inc. HASTUS offers a range of modules that help with planning, scheduling, operations, and customer information management. ↩

  2. Bus operator feedback data was obtained through direct engagement by the TransLink service planning team with operators across the South East Queensland bus network in December 2020. The same data is used for all analysis periods. ↩