Tableau Cloud basics - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Tableau Cloud User Roles

Which Tableau Cloud user role allows a user to publish content and manage projects but does NOT allow site administration?

A Explorer

B Viewer

C Site Administrator

D Creator

💡 Hint

Think about the role that can interact with content but has limited administrative rights.

The Explorer role can publish and manage content but cannot perform site-wide administration tasks, which are reserved for Site Administrators. Creators have full capabilities including content creation and publishing, while Viewers can only view content.

🎯 Scenario

intermediate

Scheduling Data Refreshes in Tableau Cloud

You want to ensure your published data source refreshes every day at 2 AM automatically. Which Tableau Cloud feature should you use?

A Subscription Email Settings

B Manual Refresh Button

C Project Permissions

D Data Extract Refresh Schedule

💡 Hint

Look for the feature that automates data updates on a set schedule.

Data Extract Refresh Schedule allows you to automate refreshes of your data sources at specific times, such as daily at 2 AM. Manual refresh requires user action, subscriptions send emails, and project permissions control access.

❓ visualization

advanced

Best Practice for Dashboard Sharing in Tableau Cloud

You created a dashboard that should be shared with a team but only certain members should edit it. What is the best way to set this up in Tableau Cloud?

A Make the dashboard public so everyone can edit it freely.

B Send the dashboard file via email to team members who need to edit it.

C Publish the dashboard to a project and set project permissions to allow editing only for specific users.

D Create multiple copies of the dashboard and share each copy with different users.

💡 Hint

Think about controlling access centrally and securely within Tableau Cloud.

Setting project permissions in Tableau Cloud allows you to control who can view or edit dashboards centrally. Sending files by email or making dashboards public risks loss of control and security. Multiple copies cause version confusion.

🔧 Formula Fix

advanced

Troubleshooting Failed Data Refresh in Tableau Cloud

A scheduled data refresh in Tableau Cloud failed with an authentication error. Which of the following is the MOST likely cause?

A The user viewing the dashboard does not have permission.

B The credentials stored for the data source have expired or changed.

C The Tableau Cloud site is down for maintenance.

D The dashboard was published with incorrect filters.

💡 Hint

Think about what authentication errors usually mean for scheduled refreshes.

Authentication errors during refresh usually mean the stored credentials for the data source are invalid, expired, or changed. Filters or user permissions do not cause authentication errors, and site maintenance would cause broader issues.

❓ dax_lod_result

expert

Calculating Unique Users per Project in Tableau Cloud

Given a dataset with columns ProjectName and UserID, you want to calculate the number of unique users per project using Tableau's LOD expressions. Which LOD expression will correctly calculate this?

Tableau

{ FIXED [ProjectName] : COUNTD([UserID]) }

A { FIXED [ProjectName] : COUNTD([UserID]) }

B { EXCLUDE [UserID] : COUNTD([ProjectName]) }

C { INCLUDE [ProjectName] : COUNT([UserID]) }

D COUNTD([UserID]) / COUNTD([ProjectName])

💡 Hint

Remember that FIXED calculates values at the specified dimension level regardless of filters.

The FIXED LOD expression calculates the distinct count of users for each project, ignoring other dimensions. INCLUDE and EXCLUDE change granularity differently, and simple division does not group by project.