OBJECTIVES

This lab assignment shows you how to connect with an excel file using Tableau and introduces you to

some of the tasks and benefits of analyzing real data on a dashboard for NC Retail Order Data.

INSTRUCTIONS

Download the Excel workbook called “VandelaySales2015.xlsx”.

• Install Tableau as we showed you in the class as a free trial.

• Review the data and come up with your own ANY FOUR business questions and create different

visualizations to answer them. For each question, create a Tableau sheet that includes

A. The question,

B. The answer, and

C. Your visualization supports your answer.

• Try to find the best (concise, clear) visualization for each question (use Show Me to help). There

is no single, right or wrong answer. Write your question and answer on each sheet using the text tool

on the Dashboard or any annotations in worksheets.

• Creating for each visualization on a separate Tableau sheet and renaming your sheet with a short

key description related to your findings, for examples, Sales2015, Region7Sales, WalmartProducts,

etc.

• Each chart needs to be different visualization type and for a different question. For example, you

cannot use Pie Chart twice for two different questions, etc.

RUBRIC:

FOUR different charts with different business analytics questions and answers are worth 25 points.

1. -1 point if missing sheet name.

2. -15 points if the same question is used twice.

3. -15 points if the same chart type is used twice.

4. -10 points if the chart, question, and answer is not clear.

5. -5 points for each chart if formatting is not complete, for example to $ for sales numbers, etc.

SUBMISSION

Take a snapshot for each graph from Tableau and past it into your word document then same as PDF.