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.

Practice

1. What is the main purpose of Tableau Cloud?

easy

A. To create dashboards only on a local computer

B. To share dashboards online easily without extra software

C. To replace Tableau Desktop for data analysis

D. To store raw data files without visualization

Solution

1. Step 1: Understand Tableau Cloud's role and compare options

   Tableau Cloud allows users to publish and share dashboards online easily. Only To share dashboards online easily without extra software describes sharing dashboards online without extra software, which matches Tableau Cloud's purpose.

2. Final Answer:

   To share dashboards online easily without extra software -> Option B

3. Quick Check:

   Tableau Cloud = Easy online sharing [OK]

Hint: Remember: Tableau Cloud = online dashboard sharing [OK]

Common Mistakes:

• Confusing Tableau Cloud with Tableau Desktop
• Thinking Tableau Cloud stores raw data only
• Assuming Tableau Cloud replaces data analysis tools

2. Which step is required to make a dashboard available on Tableau Cloud?

easy

A. Publish the dashboard from Tableau Desktop to Tableau Cloud

B. Save the dashboard as a PDF file

C. Export the dashboard as an Excel file

D. Email the dashboard file to team members

Solution

1. Step 1: Identify how dashboards reach Tableau Cloud and eliminate other options

   Dashboards are uploaded by publishing from Tableau Desktop to Tableau Cloud. Saving as PDF, exporting as Excel, or emailing files do not upload dashboards to Tableau Cloud.

2. Final Answer:

   Publish the dashboard from Tableau Desktop to Tableau Cloud -> Option A

3. Quick Check:

   Publishing = Upload to Tableau Cloud [OK]

Hint: Publishing from Desktop uploads dashboards online [OK]

Common Mistakes:

• Confusing saving with publishing
• Thinking exporting files uploads dashboards
• Assuming emailing shares dashboards on Tableau Cloud

3. After publishing a dashboard to Tableau Cloud, which feature allows team members to interact with filters and see updated views?

medium

A. Data source refresh only

B. Static image export

C. Email notifications

D. Interactive dashboard controls

Solution

1. Step 1: Understand interactivity in Tableau Cloud and compare options for interactivity

   Tableau Cloud supports interactive dashboard controls like filters that update views dynamically. Static images and email notifications do not allow interaction; data refresh updates data but not interactivity.

2. Final Answer:

   Interactive dashboard controls -> Option D

3. Quick Check:

   Interactivity = Dashboard controls [OK]

Hint: Interactivity means using filters and controls live [OK]

Common Mistakes:

• Confusing static exports with interactive dashboards
• Thinking email notifications enable dashboard interaction
• Assuming data refresh equals interactivity

4. You published a dashboard to Tableau Cloud but team members cannot see it. What is the most likely cause?

medium

A. Team members need Tableau Desktop installed

B. Dashboard file was saved locally but not published

C. Dashboard permissions are not set to allow access

D. Tableau Cloud does not support dashboards

Solution

1. Step 1: Check access control on Tableau Cloud and eliminate other causes

   Permissions control who can view dashboards; if not set, team members cannot see the dashboard. Dashboard was published (not just saved locally), Tableau Cloud supports dashboards, and team members do not need Desktop to view online.

2. Final Answer:

   Dashboard permissions are not set to allow access -> Option C

3. Quick Check:

   Permissions control access [OK]

Hint: Check permissions if team can't see dashboards [OK]

Common Mistakes:

• Assuming saving locally publishes dashboard
• Thinking Tableau Cloud lacks dashboard support
• Believing Desktop is needed to view online dashboards

5. You want to share a sales dashboard with your team on Tableau Cloud but restrict editing rights. Which combination of features should you use?

hard

A. Publish dashboard and set viewer permissions to allow interaction but no editing

B. Export dashboard as PDF and email to team

C. Publish dashboard with full editing permissions for all team members

D. Save dashboard locally and share file via cloud storage

Solution

1. Step 1: Understand sharing with restricted editing and evaluate options for sharing and permissions

   Tableau Cloud allows setting permissions so users can interact with dashboards but not edit them. Exporting as PDF or sharing files locally does not allow interaction; full editing permissions do not restrict editing.

2. Final Answer:

   Publish dashboard and set viewer permissions to allow interaction but no editing -> Option A

3. Quick Check:

   Publish + viewer permissions = controlled sharing [OK]

Hint: Set viewer permissions to restrict editing [OK]

Common Mistakes:

• Sharing static files instead of publishing
• Giving full editing rights unintentionally
• Confusing file sharing with Tableau Cloud permissions