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
Brilliant work, could you please share the PBX file?
The link I found scrolling down here is broken.
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
I really like this a great dashboard, could you please share the PBIX file @ francisco.abreu@bcb.gov.br
Really really nice, well done. Love it.
This really a great dashboard, could you please share the PBIX file @ balachandra.srinevasalu@gmail.com
I have developed one similar, only with trains, but others are very similar.
Attached the BPIX here.
I don't have an account to publish it. If someone can please do it and kindly provide me the link.
Welcome to connect me via Linkedin, https://www.linkedin.com/in/steve-nding/
Thank you sweetstar for being sweet enough to share your work.
Is there a way to download this fancy dashboard? Would be very useful