skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Re: COVID-19 NSW Transport Impact

    Re: COVID-19 NSW Transport Impact

    09-11-2020 00:55 AM - last edited 09-11-2020 00:58 AM

    Tings
    Advocate IV
    86510 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Tings
    Tings Advocate IV
    Advocate IV
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    COVID-19 NSW Transport Impact

    ‎06-30-2020 03:13 PM

    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

    Labels:
    • Labels:
    • COVID-19
    • Featured
    Message 1 of 34
    109,990 Views
    76
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    Tings
    Tings Advocate IV
    Advocate IV
    In response to Johnnny3
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-30-2021 01:15 AM

    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?

    Message 15 of 34
    69,469 Views
    1
    Reply
    rTAHERI
    rTAHERI
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎02-01-2021 10:16 AM

    nice

    Message 13 of 34
    86,630 Views
    0
    Reply
    Chacos
    Chacos Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-17-2020 11:47 AM

    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!

    Message 12 of 34
    88,353 Views
    2
    Reply
    Chacos
    Chacos Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-28-2020 10:13 AM

    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?

    Message 10 of 34
    95,495 Views
    0
    Reply
    mdbuzzer
    mdbuzzer Helper I
    Helper I
    In response to Chacos
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-29-2020 01:29 AM

    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

     

    Page 1 Tab.jpg

    Message 11 of 34
    92,734 Views
    1
    Reply
    mdbuzzer
    mdbuzzer Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎09-08-2020 01:20 AM

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

    Message 8 of 34
    90,173 Views
    2
    Reply
    Tings
    Tings Advocate IV
    Advocate IV
    In response to mdbuzzer
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎09-11-2020 12:57 AM

    Hi @mdbuzzer ,

     

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

     

    Cheers,

    Tom

    Message 9 of 34
    89,748 Views
    0
    Reply
    Aamir_khan
    Aamir_khan Advocate V
    Advocate V
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎08-28-2020 06:03 AM

    nice work. possible to share the pbix file

    Message 2 of 34
    90,235 Views
    5
    Reply
    Tings
    Tings Advocate IV
    Advocate IV
    In response to Aamir_khan
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎09-11-2020 12:55 AM

    Hi @Aamir_khan ,

     

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

    Message 3 of 34
    86,510 Views
    1
    Reply
    Johnnny3
    Johnnny3
    Frequent Visitor
    In response to Tings
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎03-20-2021 10:52 AM

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

    Message 7 of 34
    54,654 Views
    0
    Reply
    Chiara-Miani
    Chiara-Miani
    New Member
    In response to Tings
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-10-2020 09:49 AM

    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!

    Message 6 of 34
    54,720 Views
    1
    Reply
    Chacos
    Chacos Helper I
    Helper I
    In response to Tings
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-05-2020 02:05 PM

    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.

    Message 5 of 34
    35,003 Views
    1
    Reply
    Aamir_khan
    Aamir_khan Advocate V
    Advocate V
    In response to Tings
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎09-13-2020 03:18 AM

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

    Message 4 of 34
    37,083 Views
    1
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices