Publishing to Tableau Server - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Tableau Server Publishing Permissions

Which of the following user roles on Tableau Server allows a user to publish new workbooks to a project?

A Publisher

B Viewer

C Explorer

D Interactor

💡 Hint

Think about the role that can interact with content and also publish new workbooks.

The Publisher role allows users to interact with content and publish new workbooks to projects where they have permission. Viewer cannot publish. Interactor is not a standard Tableau Server role. Explorer cannot publish.

🎯 Scenario

intermediate

Publishing a Workbook with Data Source Credentials

You want to publish a Tableau workbook to Tableau Server so that users can refresh the data without entering credentials. Which publishing option should you select?

A Publish with user prompt for credentials

B Publish with embedded credentials

C Publish as a packaged workbook (.twbx)

D Publish without credentials

💡 Hint

Think about how to allow automatic data refresh without user input.

Embedding credentials allows Tableau Server to use stored login information to refresh data sources automatically. Publishing without credentials requires users to enter them. Packaged workbooks bundle data but do not affect credentials. User prompt requires manual entry.

❓ dax_lod_result

advanced

Calculating Total Sales per Region Using LOD Expressions

Given a Tableau data source with sales data by region and date, which LOD expression correctly calculates total sales per region regardless of filters?

Tableau

{FIXED [Region] : SUM([Sales])}

A {EXCLUDE [Region] : SUM([Sales])}

B {INCLUDE [Region] : SUM([Sales])}

C {FIXED [Region] : SUM([Sales])}

D SUM([Sales])

💡 Hint

Consider which LOD expression fixes the calculation at the region level ignoring filters.

{FIXED [Region] : SUM([Sales])} calculates total sales per region ignoring other filters except context filters. INCLUDE adds detail, EXCLUDE removes detail, and plain SUM respects all filters.

🔧 Formula Fix

advanced

Troubleshooting Tableau Server Publishing Failure

You try to publish a workbook to Tableau Server but get an error: 'You do not have permission to publish to this project.' What is the most likely cause?

A You lack publishing permissions on the target project

B The server is offline

C The workbook contains unsupported data sources

D Your Tableau Desktop version is outdated

💡 Hint

Focus on the permission message in the error.

The error message clearly indicates a permissions issue. Outdated software or unsupported data sources usually cause different errors. Server offline would prevent connection, not permission denial.

❓ visualization

expert

Designing a Dashboard for Publishing to Tableau Server

You want to create a dashboard that clearly shows sales trends and allows users on Tableau Server to filter by region and date. Which design practice is best?

A Publish separate dashboards for each region

B Use multiple small charts with separate filters for each

C Use only text tables to simplify data

D Create a single dashboard with global filters for region and date

💡 Hint

Think about user experience and filter efficiency on Tableau Server.

A single dashboard with global filters provides a smooth user experience and efficient filtering. Multiple small charts with separate filters confuse users. Separate dashboards increase maintenance. Text tables alone do not show trends well.