221|TABLEAU – CT EV Volume

Challenges
, ,
1

BYU Student Author: @Marta_Ellsworth
Reviewers: @Jacob_Dutton, @Kyle_Nilsen
Estimated Time to Solve: 20 Minutes

We provide the solution to this challenge using:

  • Tableau

Need a program? Click here.

Overview
Your company has recently acquired a fleet of electric vehicles for use in on-site visits from your headquarters. While these vehicles contribute to reducing your carbon footprint, tracking their charging locations has become a challenge. Your task is to create a dashboard in Tableau that displays all charging stations, their availability, and the number of charging options available.

Instructions

  1. Data Connection: Import the data file into Tableau as a data source.
  2. Mapping Charging Stations:
    a. Utilize the latitude and longitude data to plot each vehicle charging station on a map.
    b. This map should use color coding to represent the “Access Days Time”.
    c. Implement filters for the “Access Days Time” and the “Customers Only?” These filters must apply across all worksheets using this data source.
    d. Configure the tooltip to display only “Street Address” and “City”.
  3. Charger Count Bar Chart: Construct a bar chart that visualizes the total count of chargers available.
  4. Dashboard Creation: Integrate the map and bar chart into a single dashboard. Ensure the filters affect both worksheets simultaneously.

Data Files

Suggestions and Hints
  • If your map isn’t displaying correctly, ensure you’ve set the latitude and longitude fields as dimensions.
  • To display only ‘Street Address’ and ‘City’ in tooltips, drag these fields to the Tooltip section under Marks and set their type to ‘Attribute’.
  • To apply filters universally across all worksheets using the same data source, right-click on the filter in the Filters shelf, then choose ‘Apply to Worksheets’ > ‘All Using This Data Source.’ This ensures consistent filtering across your dashboard components.
  • When configuring your filters, ensure all relevant boxes are checked to reflect the data you want to display.
  • Use the count of the “Street Address” to count the number of chargers.

Solution

Challenge221_Solution.twb
Solution Video: Challenge 221|TABLEAU – CT EV Volume

Challenge221_Solution_Image
Challenge221_Solution_Image994×790 320 KB

2

Time to complete 15 minutes
Level of difficulty: Easy
Solution: Here is my tableau public link to what I have made
https://public.tableau.com/views/EVChargers_17337777592460/ConneticutChargers?:language=en-US&publish=yes&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link

3

Time to complete 30 minutes
Level of difficulty: intermediate
Solution:
Tableau extra credit.twbx (86.1 KB)

4

Time to complete: 45
Level of difficulty: Intermediate
Solution: Tableau Challenge.twbx (84.9 KB)

5

Time to complete: 25
Rating: easy
I enjoyed this challenge. It is a good refresher of my skills.
Tableau extra credit.twbx (86.1 KB)