Assignment 1: Analyze a Data Set Using Tableau
Task:
Use Tableau to analyze and reveal various relationships within a data set.
Scenario:
Earlier in the course you worked with a data set containing fuel economy data for 2015 model year cars. Now you’re going to work with that same data set in Tableau to answer a series of questions.
Deliverable:
- Create a Tableau workbook based on the Excel data file “2015 Car Fuel Econ.xlsx.”
- Create eight data visualizations, one for each question listed on the next page. Each visualization should be on a separate worksheet within the workbook and it should provide the answer to the complete question. Label each worksheet in the Tableau workbook as “Question 1,” “Question 2,” and so on.
- Using the visualization you created in 2 above, answer each question using the Deliverable Worksheet at the end of this document.
- You should use the chart type specified by the question.
Tips:
- You should construct your visualizations so that they appropriately display the data.
- You should create a graphic for all questions EXCEPT question 2 – for that one create a text table.
- Keep in mind principles that we’ve discussed in class, such as good use of colors, legends, scale, and aspect ratio. Don’t be afraid to play around with fonts and colors. Also remember, simplicity is good.
- Make sure you are aware of when to use sums versus averages.
- Take the hints seriously – they will help you!
You should upload the Deliverable Worksheet and your Tableau Workbook to Canvas by the start of class on the due date.
Use these files for the Assignment:
Assignment 1 – Analyze a Data Set Using Tableau
In-Class Exercise 2.1 – 2015 Car Fuel Econ [Start]
Grading:
For each question, your work will be evaluated using the following criteria:
|
Criteria |
Weight |
Description |
|
Answer |
50% |
Is the answer to the question correct? |
|
Visualization Method |
20% |
Is the right visualization chosen as specified in the instructions? |
|
Visualization Design |
30% |
Are the axes and data points labeled properly and readable? |