Tableau Advanced

50 Minutes

25 Questions

This test assesses expert-level proficiency in Tableau across key areas such as data connections, complex calculations, dashboard performance tuning, scripting, and advanced user experience (UX) techniques. The questions include real-world scenarios, SQL and API integration, and advanced interactivity concepts.

Topics Covered
- Advanced Calculations & Table Calculations
- Tableau Performance Optimization
- Advanced Scripting & Data Integration
- Dashboard UX (User Experience & Interactivity)
- External Data Sources in Tableau (Salesforce & Priority ERP)

Example Question:

Multiple-Choice

You are using a complex calculated field with IF statements in a large dataset. The performance is slow. How can you optimize it?

Current Calculation:

IF [Category] = "A" THEN [Sales] * 1.1
ELSEIF [Category] = "B" THEN [Sales] * 1.2
ELSEIF [Category] = "C" THEN [Sales] * 1.3
ELSE [Sales] * 1.4
END

Answers

1. Use a WINDOW_SUM() function to avoid row-by-row evaluation

2. Convert the calculation into a parameter-based selection

3. Precompute the multipliers in the data source and join them as a separate table

4. Replace IF/ELSEIF statements with a CASE statement