Intro to Visualization

A short workshop to get acquainted with data visualization

Learning objectives

By the end of this class you will be able to:

• Describe where visualization is used in the Analytics workflow
• Create a visualization using Tableau
• Create a dashboard from several visualizations

Agenda

• Introductions - 6:00
• Visualization overview - 6:15
• Code-along with the Pronto Bike Share data - 6:30
  • Get acquainted with the Tableau worksheet functions
  • Connect to a file in Tableau
  • Create a simple chart
• Exercise: Develop your first graph using Seattle Pet Licenses data - 7:00
• Code along - 7:15
  • Create simple calculated fields
  • Work with multiple measures
• Exercise with Elliot Bay Trail data - 7:30
  • Use calculated fields to look at pedestrians vs. bikes
• Code along - Create Dashboards - 7:50
• Exercise: Create dashboards with Pronto Bike share data - 8:00
• Closure - 8:30

Content

Visualization overview - 6:15

• A few slides

Code-along - 6:30

• Download the Pronto Bike Share dataset
  • In our workshop repository
    • Note this data set is sourced from Kaggle.com has some data quality issues that are eliminated in the class repository version
  • Kaggle.com Location
• Get acquainted with the Tableau worksheet editing areas and functions
• Connect to a file in Tableau
• Create a simple chart

Exercise: Create your first chart using the Seattle Pet License data - 7:00

• The Seattle Pet License dataset
  • In our workshop repository
  • Web link
• Create a line chart that will provide a view of number of licenses by day
  • Create a line chart with License Day on the x axis (horizontal axis) and count of License Numbers on the y axis (vertical access)
  • Duplicate worksheet and modify to be a line chart with Month on the x axis
• Modify to be a bar chart

Code along: Work with multiple measures - 7:15

• Freemont bridge data
  • In our workshop repository
  • Web link
• Create simple calculated fields
• Work with multiple measures
• Add filters

Exercise with Elliot Bay Trail data - 7:30

• Elliot Bay Trail data
  • In our class repository
  • Web link
• Use a calculated field to create a line chart of total pedestrians by month
• Use a calculated field to create a line chart of bikes by month
• Create a new chart using the "Measure Names" and filters to create a chart comparing total pedestrians and bikes over time
• Bonus: Create a new chart that compares all four bike and pedestrian counts over time

Code along - Create Dashboards - 7:50

• Create a dashboard from worksheet vizualizations
• Add text and blank areas for clarity and pleasant appearance

Exercise: Create dashboards with Pronto Bike share data - 8:00

• Create a chart with a count of Trips by day of the week (code along)
  • Add a color of Month of Starttime
  • Add a filter of Month of Starttime and select just December 2014 and July or 2015
• Create another chart (new worksheet) with the average trip duration vs day of the week
  • Add a color of Month of Starttime
  • Add a filter of Month of Starttime and select just December 2014 and July or 2015
• Combine these into a dashboard
• Bonus: Find something interesting in the data with a vizualization