Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
06-30-2020 15:13 PM - last edited 08-24-2023 10:06 AM
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