Portfolio

Tableau Storyboard

Description

This is a Tableau Storyboard showing the U.S. Citizen Travel Trend in 2017 and 2018. The storyboard contains 4 Tableau Worksheets explaining the following topics:

  • U.S. Citizen Annual Travel Map

  • Market Share of Travel Destination

  • U.S. Citizen Monthly Travel Counts

  • Year to Date Travel Percentage Change


  • Data

    Data Collected from: National Travel & Tourism Office (NTTO)
    Link to website: click here

    Dataset: Monthly U.S. Outbound Air Travel to International Regions
    Link to original dataset: click here


    Data Processing

    The original data structure is not suitable for Tableau, so I pivot the travel dataset for 2017 and 2018, and regenerated the following attributes:

  • Year

  • Month

  • Regions

  • Counts

  • Annual: Annual traveler counts

  • YTD: Year to date percentag change

  • Share: Market Share

  • Link to processed dataset: click here