Why Tableau is the leader in visual analytics - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a basic bar chart in Tableau.

Tableau

Drag the [1] field to Columns and the Sales field to Rows.

Drag options to blanks, or click blank then click option'

ACategory

BProfit

CDate

DRegion

Attempts:

3 left

💡 Hint

Common Mistakes

Using a measure like Profit instead of a dimension for Columns.

Choosing Date which is usually on Rows or Filters.

Category is commonly used on Columns to create bar charts showing sales by category.

2fill in blank

medium

Complete the code to filter data for the year 2023 in Tableau.

Tableau

Drag the [1] field to Filters and select 2023.

Drag options to blanks, or click blank then click option'

ARegion

BOrder Date

CCategory

DCustomer Name

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dimension like Region which is not a date.

Trying to filter on Customer Name which is not related to date.

Order Date is the date field used to filter data by year.

3fill in blank

hard

Fix the error in the calculated field to compute profit ratio.

Tableau

Profit Ratio = SUM([Profit]) / SUM([1])

Drag options to blanks, or click blank then click option'

ACategory

BQuantity

CDiscount

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using Quantity or Discount which do not represent total sales.

Using Category which is a dimension, not a measure.

Profit ratio is profit divided by sales, so SUM([Sales]) is correct.

4fill in blank

hard

Fill both blanks to create a calculated field that shows sales growth percentage.

Tableau

Sales Growth % = (SUM([Sales]) - SUM([1])) / SUM([2]) * 100

Drag options to blanks, or click blank then click option'

A[Previous Year Sales]

B[Sales]

D[Profit]

Attempts:

3 left

💡 Hint

Common Mistakes

Using Profit instead of previous sales.

Using current Sales in denominator instead of previous sales.

Sales growth compares current sales to previous year sales, so both blanks use Previous Year Sales.

5fill in blank

hard

Fill the blanks to create a Level of Detail (LOD) expression that calculates average sales per customer.

Tableau

{ FIXED [1] : AVG([2]) }

Drag options to blanks, or click blank then click option'

A[Customer ID]

B[Sales]

C[Order Date]

D[Profit]

Attempts:

3 left

💡 Hint

Common Mistakes

Fixing on Order Date instead of Customer ID.

Averaging Profit instead of Sales.

The LOD fixes on Customer ID to calculate average Sales per customer: { FIXED [Customer ID] : AVG([Sales]) }.

Practice

1. Why is Tableau considered a leader in visual analytics?
Choose the best reason.

easy

A. It requires advanced programming knowledge to use.

B. It creates clear visuals quickly without needing coding skills.

C. It only works with small datasets.

D. It focuses mainly on text reports rather than visuals.

Solution

1. Step 1: Understand Tableau's main feature

   Tableau is known for turning complex data into clear visuals fast.

2. Step 2: Compare options to this feature

   It creates clear visuals quickly without needing coding skills. matches this feature; others describe limitations or incorrect facts.

3. Final Answer:

   It creates clear visuals quickly without needing coding skills. -> Option B

4. Quick Check:

   Tableau = fast, clear visuals, no coding [OK]

Hint: Remember: Tableau = fast visuals + no coding needed [OK]

Common Mistakes:

• Thinking Tableau needs coding skills
• Believing Tableau only works with small data
• Confusing Tableau with text-based tools

2. Which of the following is the correct way to describe Tableau's interactive features?

easy

A. Tableau's interactive features require complex coding.

B. Tableau only shows static images without interaction.

C. Tableau's interactivity is limited to changing colors.

D. Tableau allows users to explore data by clicking and filtering easily.

Solution

1. Step 1: Identify Tableau's interactivity

   Tableau lets users click, filter, and drill down into data easily.

2. Step 2: Match options to this fact

   Tableau allows users to explore data by clicking and filtering easily. correctly describes this; others are false or too limited.

3. Final Answer:

   Tableau allows users to explore data by clicking and filtering easily. -> Option D

4. Quick Check:

   Interactivity = clicking + filtering [OK]

Hint: Interactivity means easy clicking and filtering [OK]

Common Mistakes:

• Assuming interactivity needs coding
• Thinking Tableau only shows static visuals
• Believing interactivity is just color changes

3. Given Tableau's ability to connect to multiple data sources, what happens when you drag a field to the Rows shelf?

medium

A. Tableau creates a visual showing data grouped by that field.

B. Tableau deletes the data source.

C. Tableau exports the data to Excel.

D. Tableau runs a script to clean the data automatically.

Solution

1. Step 1: Understand Tableau's drag-and-drop feature

   Dragging a field to Rows creates a grouped visual by that field.

2. Step 2: Evaluate options

   Only Tableau creates a visual showing data grouped by that field. describes this correct behavior; others describe unrelated actions.

3. Final Answer:

   Tableau creates a visual showing data grouped by that field. -> Option A

4. Quick Check:

   Drag field to Rows = grouped visual [OK]

Hint: Dragging fields creates grouped visuals [OK]

Common Mistakes:

• Thinking dragging deletes data
• Confusing Tableau with export tools
• Assuming automatic data cleaning happens

4. You created a dashboard in Tableau but the filters are not affecting the charts as expected. What is the most likely issue?

medium

A. Filters are not applied to all relevant worksheets in the dashboard.

B. Tableau does not support filters on dashboards.

C. The data source is corrupted and cannot be filtered.

D. Filters only work if you write custom code.

Solution

1. Step 1: Identify common filter issue in Tableau dashboards

   Filters must be set to apply to all relevant worksheets to affect all charts.

2. Step 2: Check options for this issue

   Filters are not applied to all relevant worksheets in the dashboard. correctly identifies this; others are incorrect or false.

3. Final Answer:

   Filters are not applied to all relevant worksheets in the dashboard. -> Option A

4. Quick Check:

   Filters must target all sheets [OK]

Hint: Ensure filters apply to all dashboard sheets [OK]

Common Mistakes:

• Believing Tableau dashboards don't support filters
• Assuming data corruption causes filter issues
• Thinking filters need coding

5. You want to create a Tableau dashboard that updates automatically when new data arrives and allows users to explore trends interactively. Which combination of Tableau features best achieves this?

hard

A. Create calculated fields only without any filters.

B. Export data daily and manually update static images.

C. Use live data connections with interactive filters and dashboard actions.

D. Use Tableau only for static reports without interactivity.

Solution

1. Step 1: Identify features for automatic updates

   Live data connections allow dashboards to refresh automatically with new data.

2. Step 2: Identify features for interactivity

   Interactive filters and dashboard actions let users explore trends easily.

3. Step 3: Combine features for the goal

   Use live data connections with interactive filters and dashboard actions. combines live updates and interactivity, matching the requirement.

4. Final Answer:

   Use live data connections with interactive filters and dashboard actions. -> Option C

5. Quick Check:

   Live data + interactivity = dynamic dashboard [OK]

Hint: Combine live data and filters for dynamic dashboards [OK]

Common Mistakes:

• Relying on manual updates
• Ignoring interactivity features
• Using static reports only