Finding .... Theme

Unit 2 Assignment: Finding themes using a Page 1

dashboard Milligan Chapters 7, 8, and 11

Unit 2 Assignment: Finding themes using a dashboard Milligan Chapters 7, 8, and 11

In this assignment, you will learn how to combine individual visualizations to find and present a theme

using a dashboard. You will use a mixture of previously created visualizations from Chapter 1 (Unit 1). In

addition, we will ask you to make another visualization. We will also ask you to make a few formatting changes to the visualizations, and Milligan Chapter 7 will help you with that.

You will build a dashboard after you finish formatting your visualizations. Milligan Chapter 8 will explain how you build a dashboard. You will use a guided analysis approach since you have completed the

analysis and made the discoveries. Your goal will be to guide your readers through your analysis so that

they agree and understand the insights you found. You need to convince your readers of your

conclusions based on the data insights on the dashboard.

Next, you will build dynamic elements to your dashboard that allow the reader to interact with the dashboard. You will use filter actions, show/hide features, and sheet swapping to reduce clutter and

focus your reader’s attention on the most critical insights. Milligan Chapters 8 and 11 will help you to

create these elements in your dashboard. You will record a video presentation explaining the dashboard

and demonstrating the use of dynamic elements.

There are four steps in this assignment:

1) Review, create, and format the data visualizations

2) Develop your dashboard

3) Focus attention using dynamic elements

4) Record a video presenting the dashboard

Data set:

1) US State data

Step 1 Review, create, and format the data visualizations

1. Start by finding your file Chapter 1 Tableau Workbook you created in Unit 1 and open the file on your computer. Note: if you can’t find your file, you can recreate the visualizations from Unit 1,

Chapter 1 Assignment questions 3 and 4 only.

2. Go to File->Save as “Unit 2 Dashboard”.

3. Delete the worksheets from the 2022 NYC Restaurant Inspection data since we won’t use them

(Questions 4-7). If the worksheets are used on a Dashboard in this workbook, you may have to

delete the dashboard first before it will allow you to delete the worksheets.

4. You should have two visualizations, Question 3 and Question 4, remaining. To confirm, Question

3 should be a bar chart by region, and Question 4 should be a geospatial map of the United States with states of differing colors.

Unit 2 Assignment: Finding themes using a Page 2

dashboard Milligan Chapters 7, 8, and 11

5. Create an additional tree map of the population of each state on a new worksheet within this

workbook. Add Population (2022) as a label. (Forgot how to make a treemap? See Milligan Chapter 3. For this one, you want to put the Population 2022 on a blank canvas as a color, a size,

and a label, and then the State Dimension also as a label.)

6. Rename your worksheets as something significant to the analysis. For example, the question 3

visualization from Chapter 1 analyzed the 2020 presidential election outcome by region.

7. Look at the color palette for each visualization. If you used the default colors, they might likely be the same but represent different variables. For example, on the density map, the darker the

colors, the more counties, but on the population treemap, the darker the color, the more

people. Read Milligan Chapter 7 to learn how to change the color palettes on the three visualizations so they are all different.

8. Change the color palettes so the color on each visualization is different.

Step 2 Develop your dashboard

1. Using a guided analysis approach, you will create a dashboard following the guidance in Milligan Chapter 8.

2. Create your first dashboard (a tiled approach is recommended because you will add sheet

swapping later in the assignment). Mix the horizontal and vertical containers to fit your visualizations best. You will probably have to rearrange multiple times.

3. Add at least one text box to include instructions to your reader. You can add a simple title, but

you will add some instructions later.

4. Click on “Presentation Mode” and experiment with your dashboard. What do you notice when

you:

a. Click on a state in the tree map?

b. Click on a state shape in the geographical map?

c. Click on the 2020 presidential election results for a region?

5. You should have seen no link between the visualizations. In other words, clicking on California in the treemap does not affect the other two visualizations. In the next step, we will add a way to do this.

6. You can remove the legends from the dashboards since we have included labels in our

visualizations.

Step 3 Focus attention using dynamic elements

Filter Actions

1. This is a guided analysis, so we want our readers to have the ability to interact with the dashboard dynamically.

2. Set the action filter on the geographical map. Click on the icon on the filter to make it solid on

the visualization in the dashboard. Here’s one example where we have clicked on the Question 4 visualization, and we can see the action filter (note your dashboard may look a little different

from this one.)

Unit 2 Assignment: Finding themes using a Page 3

dashboard Milligan Chapters 7, 8, and 11

3. After you set the action filter, let’s see what changed.

4. Now, click on a state on the geographical map and take note that the other two visualizations

changed.

5. Set an action filter on the treemap as well. You should see the other visualizations update when

you select a box in the treemap.

6. Lastly, set an action filter on the stacked bar chart showing the result of the 2020 presidential election by region. Again, when you click on an area, it should change the other two

visualizations change.

7. Click outside of the visualization to reset the filter.

Show/hide and sheet swapping

1. Chapter 11 explains how to add a show/hide button to a floating container.

2. This allows your reader to hide visualizations if needed. This could be beneficial if you want to

focus on just one or two visualizations and possibly make one bigger.

Unit 2 Assignment: Finding themes using a Page 4

dashboard Milligan Chapters 7, 8, and 11

3. Another feature covered in Chapter 11 is sheet swapping. When you set up sheet swapping, you

can have one visualization show, such as the map, and then have another one hide, such as the treemap. Then you can switch back.

4. Experiment with either of these methods and add at least one to your dashboard.

Step 4 Record a video presenting the dashboard

1. Your deliverable will be a three-minute video explaining your dashboard.

2. In your video, you need to explain your three visualizations, demonstrate how the filters work,

and demonstrate either the show/hide or sheet-swapping feature you added.

3. A suggested narrative outline with suggested time frames is here.

a. Greeting to the audience, your name, this class, and this assignment

b. (30 seconds) Assume the audience has no idea what you are going to talk about. Give an overview. If this were pet food marketing, we might say, “There are millions of pet

owners in the United States. This dashboard is going to investigate where we might

want to market particular brands of pet food in different regions over the time period 2015-2020.” You need to come up with a similar sentence outlining this election, state,

and county data.

c. (60 seconds total) One Visualization at a time:

i. (20 seconds) Walk the audience through your first visualization. If this were pet food

marketing, this might sound something like, “In this first chart, we use a bar chart to show the different rates of ownership of domestic pets. We can see dogs are the

most popular pet, at 45% of households, and cats are a close second, with 30% of

households having cats.” Note this not only gives the audience the ‘what’ (45% of

households have dogs) but the ‘so what’ (dogs are the most popular). Full credit

answers here will give the audience not only the raw numbers, but also the

takeaway.

ii. Repeat for your second (20 seconds) and your third (20 seconds) visualizations. d.

(60 seconds total) Filters

i. (30 seconds) Go to one of your visualizations and click somewhere on it to filter for a

variable. Again, for the pet food marketing, it might sound something like, “Here, we

click on the state of Minnesota, and we can see that there are approximately 1.5 million

dogs as pets here. If we instead select North Dakota, we see it is about 200,000 dogs,

reflecting a much smaller population in North Dakota.” Again, it’s the ‘what’ (MN has

this many dogs) and the ‘so what’ (dog ownership is tied to population size.)

ii. (30 seconds) Now demonstrate the filter across more than one visualization.

Here is where you filter in one visualization and look at the results in another.

For the pet food marketing, it might sound something like, “Let’s filter on the

reptile category only in this first graph. Now, if we look at this other graph, we

can see that Arizona and New Mexico, despite relatively modest population, have very large numbers of these sorts of pets. This may be because the hot dry

climate in that region makes it much easier to have a pet reptile.” You want to

Unit 2 Assignment: Finding themes using a Page 5

dashboard Milligan Chapters 7, 8, and 11

choose items which have some sort of relationship to each other. You can do

this for several graphs if you have time.

e. (30 seconds) wrap-up. Pull your entire story together. What should the audience take

away from your presentation? For the pet food marketing, it might be something like

“We can see that the largest pet food market will be in states with high populations for

dogs, but there may be some niche opportunity for less popular pets in smaller states if

we can get the messaging right.” What message do you have for your audience with the state and election data?

f. Thank your audience for their time and attention.