Link Search Menu Expand Document

A3—Tableau analysis

Due 2023-09-29, 11:59pm EST 16pts

Follow the instructions below and submit a single PDF for the assignment.

Please post any questions about this assignment on Slack.

Warning: This is an individual assignment.

Table of contents

Change log

  • N/A.

Aim of the assignment

You will practice using Tableau for visual exploratory data analysis and for communicating your insights, building upon what you learned during the in-class activity. You will also practice importing and reshaping a dataset.

Background info

For this assignment we are exploring Census data to understand who lives in the South End of Boston and how the population has changed over time.

The census tract for the South End begins just on the SE side of Columbus Avenue, as shown in this map:

Map of South End Image credit: Statistical Atlas

Here is a view from the top of the Prudential Tower. The south end begins just on the other side of Union Church in the center:

Aerial mage of the South End Image credit: Richard Schneider

Instructions

  1. Download this compiled Census Data for the South End: SouthEndCensusData.xls. All data is from the 2010 Census except the sheet called “decades” which is compiled over multiple Census datasets.

  2. Start writing a document in your favorite word processor / document preparation system.
    1. Write A3—Tableau analysis as the title.
  3. We will be conducting “hypothesis driven” exploration in this step of the assignment. Instead of just diving into the data with free-form exploration, we will have guiding questions to help us explore the data. Below are two hypotheses to answer with the dataset. Please generate two additional hypotheses to investigate (i.e. what other insights can you gain from this data?):
    1. The population in the South End has steadily declined over time.
    2. The dominant age group in the South End is aged 20–54.
    3. YOU CREATE
    4. YOU CREATE
  4. In your document, start each hypothesis on a separate page:
    1. Write the hypothesis as a section heading.
    2. Create a page break after it so that each hypothesis starts on its own page.
  5. With Tableau, generate at least one visualization for each of the above hypothesis to confirm or disprove them.

    Note: Feel free to reshape the Excel spreadsheet as necessary to answer these questions. In fact, you will have trouble doing this assignment without reshaping the data.

    See Tableau’s Tips for Working with Your Data if you need guidance with reshaping and formatting your data so you can analyze it effectively.

  6. Copy and paste the visualization for each hypothesis into the associated section of the document. You can do this in Tableau by right-clicking on the main part of the visualization and going to “Copy→Image”. Alternatively, you can just take a screenshot that includes any necessary legends and filters.

  7. For each visualization, write a few sentences to:
    1. Justify your choice of visual encoding and visualization design choices (i.e. marks, channels, perceptual ordering, data type, etc.)
    2. AND explain your data insights in support or contradiction of the associated hypotheses.

Submission instructions

All parts should be submitted as a single PDF and submitted to the assignment A3—Tableau analysis on Gradescope. Please use Gradescope’s “tagging” interface to associate each of your answers with the questions of the rubric.

Grading Rubric

Criteria Points
Hypothesis 1 has effective visualizations + text to justify and explain insights 4 pts
Hypothesis 2 … 4 pts
Hypothesis 3 … 4 pts
Hypothesis 4 … 4 pts
  16 pts

Like usual, the visualizations should follow our the best practices and everything you’ve learned in class up to this point. E.g., include axis labels, appropriate scales, titles, legends, annotations, be neat and clean (not cluttered). Points will be deducted for poor quality or confusing visualizations. Likewise, points will be deducted for spelling and grammar mistakes.


© 2023 Cody Dunne. Released under the CC BY-SA license.