Why is it important to consider cognitive load when crafting a visualization?

A. Increasing cognitive load allows the brain to process more information

B. Reducing cognitive load allows us to determine whether the brain is using short-term or long-term memory

C. Reducing cognitive load allows the brain to process a visualization more quickly and efficiently

D. It is not important to consider cognitive load when crafting a visualization

Which of the following are pre-attentive visual properties?

A. Movement

B. Color

C. Spatial Positioning

D. Form

E. All of the above

When considering pre-attentive attributes, the color property includes which of the following?

A. Size, shape

B. Opacity, darkness

C. Color scheme, transparency

D. Intensity, hue

The term “chart junk”, coined by Edward Tufte, refers to:

A. A poorly designed chart

B. Non-data graphics that clutter a view

C. Unnecessary data labels

D. A chart that does not convey valuable information

A high data-ink ratio is desirable in data visualization because

A. The amount of ink dedicated to non-data information is minimized

B. It makes it easier to print a dashboard

C. It can help reduce cognitive load for the end user

D. Both A and C.

E. All of the above

Which of the following is an example of redundant data ink?

A. Axis tick marks every 5% from 0-100%

B. Using more than two colors

C. Titling the visualization

D. Including a color legend

Which of the following scenarios would best represent a psychological schema?

A. Using the color green to represent “good”

B. Removing lines and borders from your graph

C. Creating a parameter for user interactivity with the dashboard

D. Using a bar chart to compare parts to a whole

E. All the above

Which of the following is an example of double encoding?

A. Using two different colors on the same graph

B. Displaying the color legend

C. Placing a graph within a Tooltip

D. Separating different dimension members by both bars and colors

True or False: The existence of visualization best practices means there is a single correct way to build a visualization.

A. True

B. False

Which of the following terms describes what we are leveraging when we highlight the minimum and maximum values in a table?

A. Short-term memory

B. Long-term memory

C. Pre-attentive attributes

D. Cognitive load

Build a table that shows sales by month by category. Highlight the minimum and maximum sales values in the table. (Note: if Tableau does not recognize Order Date as a date type, right click on the Order Date pill in the Data pane, go to Change Data Type, and select Date.)

Hint: 3 Ways to Make Highlight Tables

Okay - I have built the view and am ready to continue.

What are the minimum and maximum values?

A. $6,866 and $49,919

B. $15,766 and $131,135

C. $6,027 and $37,057

D. $5,964 and $49,919

Which month and category combo saw the minimum sales?

A. January, Furniture

B. February, Technology

C. February, Furniture

D. None of the above

Which of the following visualizations would best display a correlation between sales and profit by sub-category?

A. Scatterplot

B. Line graph

C. Cumulative curve

D. Treemap

Build a scatter plot that shows the relationship between sales and profit by sub-category.

Hint: 3 Ways to Make a Scatterplot

Okay - I have built the view and am ready to continue.

Based on the scatterplot you just built, which sub-categories show a negative profit?

A. Bookcases, Machines and Fasteners

B. Supplies, Bookcases, Machines and Tables

C. Fasteners, Supplies, Bookcases and Labels

D. Supplies, Tables and Bookcases

Based on the scatterplot you just built, which two sub-categories have above average profit, but below average sales?

A. Furnishings and Appliances

B. Chairs and Phones

C. Appliances and Paper

D. Fasteners and Envelopes

Which of the following visualizations would best display the 80/20 rule?

A. Pie chart

B. Cumulative curve

C. Scatterplot

D. Pareto chart

Build a Pareto chart that highlights the 80/20 rule using the variables profit and order ID. Include reference lines at 80% on the profit axis and 20% on the orders axis. Exclude order IDs with profit less than 0. (Hint: for your table calculations, compute using order ID)

Hint: How to Make a Pareto Chart

Okay - I have built the view and am ready to continue.

For all subcategories, 20% of orders contributed ___% of profit.

A. 78%

B. 20%

C. 81%

D. 123%

Which subcategory’s orders and profit most closely follow the 80/20 rule?

A. Binders

B. Art

C. Phones

D. Storage

For the subcategory that most closely follows the 80/20 rule,

A. 20.4% of orders contributed 71.3% of profit

B. 20.4% of orders contributed 77.6% of profit

C. 80.1% of orders contributed 20.5% of profit

D. 20.5% of orders contributed 88.7% of profit

Your manager asks you to recommend a method to further highlight the 80/20 rule on your Pareto chart. What do you recommend?

A. Show each subcategory individually

B. A caption that explains how to read the chart

C. Remove all the gridlines and simplify axis labels

D. Color the top 20% of orders

Build a stacked bar chart that shows sales broken down by region, by category. Add a label that shows the total sales for each category, formatted in the thousands (K). Finally, use your data visualization best practices knowledge to format the visualization in order to reduce cognitive load.

Hint: How to Make Stacked Bar Charts

Okay - I have built the view and am ready to continue.

Which sort order for the region dimension would you recommend in order to improve the readability of this chart?

A. The default sort order

B. Alphabetic by sales

C. Ascending order by sales

D. Descending order by sales

Which region contributed the most sales in all three categories?

A. East

B. West

C. South

D. Central

Which of the following can be a drawback to using a stacked bar chart?

A. They have too many colors

B. They cannot convey part-to-whole relationships

C. It is difficult to compare segments that don’t share a common baseline

D. The segments cannot be labeled

Duplicate the sheet for your stacked bar chart. Convert the chart to a 100% stacked bar chart.

Hint: How to Make Stacked Bar Charts

Okay - I have built the view and am ready to continue.

What percentage of total sales did the East region contribute to the Furniture category?

A. 8.3%

B. 28.3%

C. 26.5%

D. 29.7%

What was the lowest percentage of total sales?

A. 16.12%

B. 16.5%

C. 5.2%

D. 5.4%

Which region had the lowest percentage of total sales for two of the three categories?

A. East

B. West

C. South

D. Central

Which of the following chart types would best display deviation from a fixed reference point of zero?

A. Circle timeline

B. Diverging bar chart

C. Bullet graph

D. Slope graph

Build a diverging bar chart that shows profit by subcategory for each region.

Hint: How to Make Diverging Bar Charts

Okay - I have built the view and am ready to continue.

Which region had the most subcategories with negative profit?

A. East

B. West

C. South

D. Central

Which subcategories had negative profit for the east region?

A. Tables, Machines

B. Machines, Supplies, Bookcases

C. Appliances, Binders, Bookcases, Furnishings, Supplies

D. Supplies, Tables

What color palette do you recommend to highlight negative and positive profit values?

A. Red-Green diverging

B. Red-Green sequential

C. Orange-Blue diverging

D. Blue sequential

Line graphs are ideal for showing which of the following:

A. Correlation

B. Change over time

C. Part to whole

D. Deviation

The term “spaghetti graph” is used to describe a line graph that:

A. Appears cluttered and difficult to read because there are multiple lines

B. Features a maximum of 5 lines in the view

C. Features lines that cross over each other in the view

D. Both B and C

Create a line graph that shows profit ratio by month by region. Hint: The formula for profit ratio is SUM([Profit])/SUM([Sales])

Hint: How to Make Line Graphs

Okay - I have built the view and am ready to continue.

What was the median profit ratio overall for the year?

A. 0.1000

B. 0.1143

C. 0.1352

D. 0.4166

Which of the following pre-attentive attributes could be used to draw attention to the East region?

A. Movement

B. Color

C. Spatial Positioning

D. Form

Let us know who is taking the test:

First Name(Required)

Last Name(Required)

Playfair+ Email(Required)

Phone

Company Name

Visual Analytics Practitioner Exam

What to know:

Build a table that shows sales by month by category. Highlight the minimum and maximum sales values in the table. (Note: if Tableau does not recognize Order Date as a date type, right click on the Order Date pill in the Data pane, go to Change Data Type, and select Date.)

Build a scatter plot that shows the relationship between sales and profit by sub-category.

Build a Pareto chart that highlights the 80/20 rule using the variables profit and order ID. Include reference lines at 80% on the profit axis and 20% on the orders axis. Exclude order IDs with profit less than 0. (Hint: for your table calculations, compute using order ID)

Build a stacked bar chart that shows sales broken down by region, by category. Add a label that shows the total sales for each category, formatted in the thousands (K). Finally, use your data visualization best practices knowledge to format the visualization in order to reduce cognitive load.

Duplicate the sheet for your stacked bar chart. Convert the chart to a 100% stacked bar chart.

Build a diverging bar chart that shows profit by subcategory for each region.

Create a line graph that shows profit ratio by month by region. Hint: The formula for profit ratio is SUM([Profit])/SUM([Sales])

Let us know who is taking the test: