topic Re: COVID-19 NSW Transport Impact in Data Stories Gallery

COVID-19 NSW Transport Impact

Tings — Thu, 24 Aug 2023 17:06:49 GMT

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

Re: COVID-19 NSW Transport Impact

Aamir_khan — Fri, 28 Aug 2020 13:03:17 GMT

nice work. possible to share the pbix file

Re: COVID-19 NSW Transport Impact

mdbuzzer — Tue, 08 Sep 2020 08:20:53 GMT

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

Re: COVID-19 NSW Transport Impact

Tings — Fri, 11 Sep 2020 07:58:25 GMT

Hi Aamir_khan ,

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

Re: COVID-19 NSW Transport Impact

Tings — Fri, 11 Sep 2020 07:57:52 GMT

Hi mdbuzzer ,

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

Cheers,

Tom

Re: COVID-19 NSW Transport Impact

Aamir_khan — Sun, 13 Sep 2020 10:18:11 GMT

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

Re: COVID-19 NSW Transport Impact

Chacos — Mon, 05 Oct 2020 21:05:06 GMT

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.

Re: COVID-19 NSW Transport Impact

Chacos — Wed, 28 Oct 2020 17:13:30 GMT

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?

Re: COVID-19 NSW Transport Impact

mdbuzzer — Thu, 29 Oct 2020 08:29:08 GMT

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

Re: COVID-19 NSW Transport Impact

Anonymous — Thu, 10 Dec 2020 17:49:56 GMT

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!

Re: COVID-19 NSW Transport Impact

Chacos — Thu, 17 Dec 2020 19:47:57 GMT

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!

Re: COVID-19 NSW Transport Impact

rTAHERI — Mon, 01 Feb 2021 18:16:12 GMT

nice

Re: COVID-19 NSW Transport Impact

Anonymous — Fri, 19 Mar 2021 17:50:57 GMT

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

Re: COVID-19 NSW Transport Impact

Anonymous — Sat, 20 Mar 2021 17:52:05 GMT

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

Re: COVID-19 NSW Transport Impact

sweetstar — Tue, 20 Apr 2021 15:26:01 GMT

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/

Re: COVID-19 NSW Transport Impact

Chandrra — Fri, 07 May 2021 04:49:23 GMT

This really a great dashboard, could you please share the PBIX file @ balachandra.srinevasalu@gmail.com

Re: COVID-19 NSW Transport Impact

Anonymous — Wed, 02 Jun 2021 14:17:56 GMT

Really really nice, well done. Love it.

Re: COVID-19 NSW Transport Impact

Wharuna — Sun, 20 Jun 2021 19:25:20 GMT

Thank you sweetstar for being sweet enough to share your work.

Re: COVID-19 NSW Transport Impact

fabreu1285 — Thu, 24 Jun 2021 13:54:03 GMT

I really like this a great dashboard, could you please share the PBIX file @ francisco.abreu@bcb.gov.br

Re: COVID-19 NSW Transport Impact

Anonymous — Wed, 30 Jun 2021 07:35:19 GMT

Can anyone share the pbix file of the COVID-19 NSW Transport Impact?