ANALYTICS-ARCH-201 practice question 5 of 30

A Tableau workbook with multiple complex dashboards is experiencing slow loading times. What is the first step in troubleshooting this workbook performance issue?

Full set: 200 questions
Answer options
A: Increasing the server's hardware resources, such as RAM and CPU capacity
B: Simplifying the calculated fields and reducing the number of filters and parameters in the workbook Correct answer
C: Splitting the workbook into several smaller workbooks to distribute the load
D: Checking the network speed between the Tableau Server and the client machines
Correct Answer:
B. Simplifying the calculated fields and reducing the number of filters and parameters in the workbook
Explanation

The most logical and recommended first step in troubleshooting a slow, complex workbook is to analyze and optimize its internal components. The complexity of dashboards, calculated fields, and the number of filters are primary drivers of performance degradation. Using tools like Tableau's Performance Recorder allows an analyst to identify the specific worksheets, queries, or calculations that are causing delays. Addressing these internal inefficiencies is a direct, targeted, and cost-effective initial action before considering external factors like server hardware, network latency, or significant architectural changes such as splitting the workbook.

Why Incorrect

A. Increasing server hardware is a costly solution that should only be considered after confirming that the workbook is fully optimized and the bottleneck is indeed server-side resource contention.
C. Splitting the workbook is a significant redesign effort. It is a valid optimization technique but should be attempted after simpler, internal optimizations have failed to yield sufficient improvement.
D. While network speed can be a factor, the problem description points to "complex dashboards," which strongly implies a processing and rendering bottleneck, making workbook analysis the more probable starting point.

References

1. Tableau Official Documentation

"Optimize Workbook Performance": This guide outlines a clear hierarchy of optimization techniques. It emphasizes simplifying the workbook as a primary strategy

stating

"Any of these factors can affect performance: the number and complexity of marks in the view... the number of filters... complex calculations." This directly supports analyzing and simplifying calculations and filters first.

Source: Tableau Help

"Optimize Workbook Performance

" Section: "Simplify your workbook."

2. Tableau Official Documentation

"Record and Analyze Workbook Performance": The existence and purpose of the Performance Recorder tool underscore that the first step is to analyze the workbook's internal operations. The tool is designed to "help you understand where time is being spent... The main events that are tracked are: Query execution... Geocoding... Connections to data sources... Layout computations... [and] Rendering."

Source: Tableau Help

"Record and Analyze Workbook Performance

" Introduction.

3. Tableau Whitepaper

"Designing Efficient Workbooks": This foundational document details best practices for performance. It consistently prioritizes workbook design choices over infrastructure changes. For instance

it advises

"Filters are a very powerful feature in Tableau

but they can also be a source of performance problems... Calculations can also have a significant impact on workbook performance."

Source: Tableau Whitepaper

"Designing Efficient Workbooks

" (e.g.

versions from 2015-2022)

Sections on "Filtering" and "Calculations."

4. Duke University

"Advanced Features and Best Practices

" instructors emphasize that workbook optimization

including simplifying calculations and being judicious with filters

is a critical skill and the first line of defense against poor performance before blaming the server or data source.

"Data Visualization and Communication with Tableau

" Module 5

Video: "Best Practices for Performance."

Scroll to Top