Success Story: NSW Active Transport
Data-Driven Approach for NSW Active Transport
Encouraging Walking & Cycling
The NSW Active Transport portfolio faced challenges in enhancing existing infrastructure and promoting walking and cycling. Key hurdles included the lack of a centralised data management system, manual data collection and analysis processes, and complex calculations for converting kilometres travelled into benefits.
Additionally, the reporting system had limited ability to analyse data across time periods and locations. To overcome this, we used automation, AI, and IoT with Microsoft tech to streamline data management, automate reporting, and empower data-driven decisions.
Active Transport faced a variety of challenges and were relying on manual data collection and complex benefit calculations. Decentralised reporting added to their struggles, making it difficult to monitor the success of their initiatives and promote sustainable transport.
They needed a comprehensive and automated reporting solution and recognised the importance of a secure data source that would inform their investment decisions and drive positive outcomes.
We engaged stakeholders to understand their processes and data needs. Our solution involved gathering sustainable data from IOT devices placed throughout the city. These data points were connected using user-friendly tools like Azure IOT Hub and Azure Synapse for data management. The insights were then presented through easy-to-use and automated PowerApps and Power BI reports, making operations smoother and providing valuable information to the general public.
Active Transport now benefit from an automated reporting system that centralises data, provides actionable insights, and enables easy tracking of their initiatives. The implementation has led to substantial cost savings and increased efficiencies through automation, streamlining data collection and real-time updates. In addition, the solution includes dashboards available to the general public, promoting transparency and encouraging the use of sustainable transportation.
Fully Built on Azure
Azure Data Lake
Azure Data Warehouse
Azure Analysis Services
Azure SQL DB
Azure Data Factory