Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Information
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
Data Sources
All data is sourced from the NSW Transport Open Data website - links are below:
Ferry: https://opendata.transport.nsw.gov.au/dataset/opal-trips-ferry
Bus: https://opendata.transport.nsw.gov.au/dataset/opal-trips-bus
Train (Includes Metro): https://opendata.transport.nsw.gov.au/dataset/opal-trips-train
Light Rail: https://opendata.transport.nsw.gov.au/dataset/opal-trips-light-rail
Key Metrics
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
eyJrIjoiNzcxNTdlY2ItYjFhYS00YjkyLThkMmEtMTQwYjVlYzExNjA0IiwidCI6ImQyYWY4YjViLTlhN2UtNGM4NS1hM2ZkLWI2OWE2Njk4YjdkNiJ9
Hi. Can you please email the pbix file to ds_johndoe@dhiraagu.com.mv. Would love to learn how the visualizations are done.
great Report, could you please send me the PBX file? Jordan.Kilbourn@PlayPower.com
Great BI, Am into Passenger serivce analytics. could you please share the BI file to raj.chidambaram@kiwirail.co.nz
Very Fantastic and Insightful
Could you please share it with me
khadija.kord@gmail.com
Please provide the PBIX as the link didn't work for me. I love this visual! My email is Molly.Johannemann@53.com. Thank you so much.
Brilliant work, could you please share the PBX file?
The link I found scrolling down here is broken.
I would also love to have a copy of the PBIX file. Can you send to RKBNYC@yahoo.com
Fantastic!
Could you please share it with me? My email is robertty.denyllow@gmail.com
thanks
Fantastic!
Could you please share it with me? My email is fabrizio.ciciarelli@gmail.com
thanks!
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 bkg00@yahoo.com
thanks!
This is great. I am in learning phase. Can you share the PBIX file for me to understand it better.
ahmedgamal6866@gmail.com
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.
rkeshri123.rk@gmail.com
It is awesome product. Could you please share it with me? My email is tklikmar@gmail.com
thanks!
Hello,
It is very a dashboard very intereesing.
Can you send me to cecilia.abrami@bnpparibas-pf.com and cecilia.abrami@live.fr the dashboard in pbix format please ?
Thank you so much.
Cécilia
Amazing work. Very inuitive and easy to understand. I like how color highlights the time bounde differences.
Can anyone share the pbix file of the COVID-19 NSW Transport Impact?
Hi Mike,
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?
thanks for the pbix file, yes, will give rating for your page! Thanks