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” 


Related Questions in computer science category