08-28-2020 06:03 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
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.
Hi Johnny - apologies for the delay!
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?
How did you guys create the "tab effect" for the top left quadrent's viz? (the Percentage Change by Month (2020 vs 2019)
Seams like tabs are buttons and then you used bookmarks and then action to hide or unhide the viz, correct?
you use Powerpoint and create backgrounds with tabs and darken the colour of the tab you are currently on, use that background image from powerpoint on Power Bi and just add buttons
Hi @mdbuzzer ,
It's a third party visual called "Scroller'". You can import it into your desktop file from the marketplace.
Hi! Really nice work!
I'd like to see the file to understand how you did many things I'm interested in, but I can't download it from the link above 😞
Can you please share it again?
Thank you so much!