04-28-2023 06:04 AM
This report combines OPAL tap-on/tap-off data from NSW Trains, Ferries, Buses, Light Rail & Metro. We use these data to compare public transport utilisation year over year (2020 vs 2019). The aim is to understand the impact of COVID-19 on passenger levels across all modes of public transport, using 2019 as our baseline.
The common dimensions available in the report include Service, Fare Type and Transport Mode. A definition of these can be found below:
Service: Refers to the service where the tap-on/tap-off occurred e.g. Manly Ferry
Fare Type: Refers to the type of fare for which the tap-on/tap-off occurred e.g. Adult
Transport Mode: Refers to the mode of transport where the tap-on/tap-off occured e.g. Train
All data is sourced from the NSW Transport Open Data website - links are below:
Train (Includes Metro): https://opendata.transport.nsw.gov.au/dataset/opal-trips-train
Passengers 2019: Sum of Passengers for 2019 (Excluding months that are yet to occur in 2020 e.g. September).
Passengers 2020 Sum of Passengers for 2020
Absolute Change Year over Year: Passengers 2020 - Passengers 2019
Percentage Change Year over Year: (Passengers 2020 - Passengers 2019) / Passengers 2019
Passengers Current Reporting Period: Sum of Passengers for the latest reporting month
Passengers Current Reporting Period Previous Year: Sum of Passengers for the
This is fantastic! Intuitive, clean and informative I love the transportation method color coding, the over-sized letters at the tops for navigation and the conditional formatted table.
It is awesome, ther is a lot to learn. As I'm in learning phase, it would be really helpful if you please share it with me 🙂 My email is firstname.lastname@example.org
Covid has greatly affected all aspects of our lives, including the transport systems of cities around the world. This visualization was able to demonstrate this in a concrete way. Thank you
This is great. I am in learning phase. Can you share the PBIX file for me to understand it better.
Also if you provide training on power bi then I am happy to take it from you.
Please download the dashboard here: https://sparkbicomau.sharepoint.com/:u:/s/SparkBI/EZrTyyzA5tpKqf492KaftBAB6Ym_g8gqQgRmF2SJEJJwKQ?e=a...
Can I please get you to support my business by rating our page on Google?