COVID-19 NSW Transport Impact 02-01-2021 10:16 AM

[Tings]

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

[sweetstar]

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/

[Johnnny3]

Is there a way to download this fancy dashboard? Would be very useful

[rTAHERI]

nice

[Chacos]

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!

[Chacos]

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?

[mdbuzzer]

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

[mdbuzzer]

How did you manage to get that header/announcement bar to be dynamic like that ? Is there a specific visual to use ?

[Tings]

Hi @mdbuzzer ,

It's a third party visual called "Scroller'". You can import it into your desktop file from the marketplace.

Cheers,

Tom

[Aamir_khan]

nice work. possible to share the pbix file

[Tings]

Hi @Aamir_khan ,

You can download the file at: www.sparkbi.com.au

[Johnnny3]

Hi, tried to download it, however received just an error message... would be possible to add another way to download it?

[Chiara-Miani]

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!

[Chacos]

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.

[Aamir_khan]

Thanks, how you refresh the data can you please share the details.