In addition to Operational Reporting, the main objective was to ingest, store and process huge amounts of operational public transport data on NSW to empower innovation across Transport departments as non-technical analysts, business users, and data scientists now have a scalable, secure platform to test transport-related hypotheses and mine public transport data for additional insights.
On top of this, external users and the public can now download historical GTFS public transport data for use within their own services and products.
The solution uses services such as:
- Databricks Delta
- Databricks SQL Analytics
- Databricks Spark
- Microsoft Synapse
- Azure Machine Learning Service
- Power Platform