Book a Call
Agile Insights Helps Improve the Quality of the Bus Service in NSW
Transforming data from NSW buses into actionable insights with cutting-edge analytics.
The Opportunity
Transport for NSW needed to convert vast amounts of real-time bus data into actionable insights – enabling the Bus Contract Management team to improve service performance, diagnose delays, and lift customer satisfaction through advanced analytics.
The Delivery
Agile Insights implemented a fully automated, cloud-based analytics solution integrating Azure Data Lake, Data Warehouse, SQL DB and Analysis Services – with an in-memory analytical model refreshed every few minutes and Power BI dashboards for real-time monitoring.
The Outcome
A fully integrated live data model eliminating cross-system data access, Bus Contract Management teams empowered with shareable interactive insights, meaningful performance conversations enabled through real-time benchmarking, and enhanced ability to diagnose and address service delays.
Book a free consultation
About Transport for NSW
Transport for NSW is responsible for delivering safe, efficient, and sustainable transport services across New South Wales. Managing data from buses, ferries, light and heavy rail, and metro systems in real-time, the organisation is committed to leveraging innovation to improve service quality and meet community needs.
The Challenge

Before partnering with Agile Insights, the Bus Contract Management team faced significant challenges:

  • Difficulty processing and synthesising massive amounts of bus data in real-time.
  • Inefficient and time-consuming reporting systems.
  • Limited ability to identify specific issues affecting bus performance.
  • Fragmented data sources preventing a unified view of performance metrics.
Client Testimonial
"We get data from every bus every 5 seconds - that's a lot of data which initially the Contract Management team was not able to process, synthesise, and get real value from. What we have done is to actually give them that value so that they can get some real insights."
Sandeep Mathur
Program Manager, TfNSW

Our Solution

Agile Insights implemented a fully automated, cloud-based analytics solution designed to integrate and process real-time data from buses across NSW. Key components included:

Data Aggregation and Integration
Data from bus tracking devices was aggregated into an Azure Data Lake, cleaned, and organised into a Data Warehouse.
Automated Processes
Developed an in-memory analytical data model refreshed every few minutes.
Real-Time Dashboards
Built Power BI dashboards to monitor trips, schedule adherence, and reasons for delays.
Targeted Insights
Provided tools to analyse specific locations and routes causing delays, helping managers take corrective action.
Why It Worked

Our solution to resolve the challenge was executed over a period of three months. To deliver a best-of-breed solution, we kept to a meticulous project timeline.

Agile Insights followed a structured approach to deliver the solution:

  • Discovery Phase: Analysed the maturity of existing data systems and processes.
  • Solution Design: Collaborated with TfNSW to define project goals, focusing on improving bus performance and customer experience.
  • Implementation: Built an automated cloud-based system integrating Azure Data Lake, Data Warehouse, SQL DB, and Analysis Services.
  • Dashboard Development: Created interactive Power BI dashboards for real-time insights.
  • Training & Enablement: Ensured TfNSW teams could fully utilise the new tools.

The Impact

  • Fully integrated data model with live connections, eliminating the need to cross systems for data access.
  • Empowered Bus Contract Management team and operators with shareable, interactive data insights.
  • Enabled meaningful performance conversations with real-time benchmarking and analytics.
  • Enhanced ability to diagnose and address service delays, improving overall quality of service.
  • Delivered user-friendly dashboards accessible to all stakeholders, from operators to managers.

Get in touch