You will create a parameterized chart that shows the number of Divvy trips by hour of day between two groups of stations.
computer science
Description
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.
·
Name
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”
Deliverables:
• Tableau workbook named “Homework 7 <Your
Name>.twb” that contains the charts “Trips By Hour” and “Hourly Map
Chart”
