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
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
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?
nice
mdbuzzer,
This is an awesome dash!
Did you ever think to create a youtube video? Even with high level tips, how to create similar tabbed vizuals.
Thanks!
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
How did you manage to get that header/announcement bar to be dynamic like that ? Is there a specific visual to use ?
Hi @mdbuzzer ,
It's a third party visual called "Scroller'". You can import it into your desktop file from the marketplace.
Cheers,
Tom
nice work. possible to share the pbix file
Hi, tried to download it, however received just an error message... would be possible to add another way to download it?
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!
COVID-19 NSW Transport Impact - can you please allow download for this one?
On the SparkBI site it's not available, it's not in the SharePoint.
Thanks, how you refresh the data can you please share the details.