Week 3 - Milligan Chapter 4

Welcome to your hands-on activity! This assignment invites you to work with Tableau using a mix of generated and real-world data. You will:

• Download the attached spreadsheet and upload those data sets into Tableau. If you need help loading your data sources, refer to Assignment A.2 for help.
• Go through this document and use Tableau to answer all the questions listed below. Where applicable, paste screenshots into the template below.
• When you are ready, complete the online quiz which verifies your homework.You are welcome to refer to this document when you complete the quiz.
• You are welcome to use the quiz results to update your homework file.
• When you have completed the online quiz, submit the Word document.
• Remember, you can always reach out for help to your instructor if needed.
• If you need to adjust the size of your visualizations to match the options in the questions, use the "Format"->"Cell size" options. For example, "Ctrl+Shift+B" on a Windows computer will make the visualization bigger and "Ctrl+Up" will make it taller.

The spreadsheet attached to this assignment contains two datasets, each within its own sheet on the Excel doc:

1. B.2 San Francisco Excel
2. B.2 Student grades

Hi,

I am now 100% how to create the right visualization in Tableau. I go the formulae SPLIT, but not sure how to filter the data. I know this may be a long shot.

Question 1: Calculated Field that Splits data

You work for the San Francisco energy audit and need to plan visits to the sites of the buildings that have upcoming energy audits. To plan your visits, you want to know how many are in each block of the city. Connect to the B.2 San Francisco Excel data and create a calculated field to create a new field from the parcel field so that you can get the block number which is the first set of digits in front of the slash.

Which of the following syntax would correctly create a field for just the block part of Parcel?

A: BREAK([Parcel(s)],"/")

B: SPLIT([Parcel(s)],"/",1)

C: DATEPARSE([Parcel(s)],1)

D: SPLIT([Parcel(s)],"-",1)