This assignment has two parts:
Part 1: You will create a parameterized chart that shows the number of Divvy trips by hour of day between two groups of stations. The chart should include only trips that last between X and Y minutes where X and Y will be supplied by the user/analyst.
· Create a union of all Divvy trips in 2017.
· Select the “Extract” Connection option. Note that Tableau will prompt you to save the
newly created extract as a new file with “hyper” extension.
· Create a chart that shows the number of Divvy trips by hour of day (0-23). You can use a
line chart or a column chart.
· Create a set of all from stations with names containing the string “State”.
· Create a set of all to stations with names containing the string “Michigan”.
· Add both sets as filters to the chart you already created.
· Create a filter or filters that implement the selection of trips lasting between X and Y
minutes. Note that X and Y should be parameters that can be selected by the viewer. Keep in mind that Tripduration is a measure expressed in seconds while X and Y are measured in minutes.
this chart “Trips By Hour”
Part 2: You will create a map chart that shows the number of Divvy trips that end at a certain set of stations (To Station Name).
· Open a new data source and connect live to Divvy_Trips_2017_Q3.csv.
· Add a connection to Divvy_Stations_2017_Q3Q4.csv.
· Join the two tables using To Station ID and Id
· Create a map using Latitude and Longitude from the Divvy Stations tables (not the
generated ones) as described in the lecture slides.
· Create a set of some of the Divvy Stations (To Station Name). You can create the set any way you want.
· Apply the set as a filter to the map chart you already created.
· Animate your chart using the Hour part of End Time in Pages.
· Name this chart “Hourly Map Chart”
• Tableau workbook named “Homework 7 <Your Name>.twb” that contains the charts “Trips By Hour” and “Hourly Map Chart”