Subscriptions and alerts in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Tableau Subscriptions

Which of the following best describes how Tableau subscriptions work?

A Subscriptions automatically update the data source without user intervention.

B Subscriptions create alerts that notify users when data changes beyond a threshold.

C Subscriptions allow users to edit dashboards directly from their email notifications.

D Subscriptions send a snapshot of a dashboard or view to users on a scheduled basis via email.

💡 Hint

Think about what users receive when they subscribe to a Tableau view.

Tableau subscriptions send a snapshot of a dashboard or view to users by email on a set schedule. They do not update data or allow editing from email.

🎯 Scenario

intermediate

Configuring Data-Driven Alerts

You want to notify sales managers only when monthly sales drop below a target value. Which Tableau feature should you use?

A Create a subscription for the sales dashboard to send weekly emails.

B Use Tableau Prep to clean sales data before visualization.

C Set up a data-driven alert on the sales metric with a threshold condition.

D Schedule a data extract refresh to update sales data daily.

💡 Hint

Think about how to notify users only when a specific condition is met.

Data-driven alerts in Tableau notify users only when a metric crosses a defined threshold, such as sales dropping below a target.

🔧 Formula Fix

advanced

Troubleshooting Subscription Delivery Failures

A user reports they are not receiving Tableau subscription emails. Which of the following is the most likely cause?

A The data source is set to live connection instead of extract.

B The user's email address is not verified or is blocked by spam filters.

C The Tableau workbook has no filters applied.

D The user has not published any dashboards.

💡 Hint

Consider common email delivery issues.

If subscription emails are not received, often the user's email is unverified or filtered as spam, blocking delivery.

❓ visualization

advanced

Designing an Alert Dashboard

You need to create a dashboard that highlights KPIs with alerts triggered. Which visualization best supports alert clarity?

A Use color-coded KPI tiles that change color when alert thresholds are met.

B Display all KPIs in a single table without color or icons.

C Show KPIs as line charts without any alert indicators.

D Use pie charts to represent alert counts per KPI.

💡 Hint

Think about how to make alerts immediately visible to users.

Color-coded KPI tiles that change color when thresholds are crossed make alerts clear and easy to spot.

❓ data_modeling

expert

Optimizing Alert Performance with Data Extracts

To improve performance and reliability of data-driven alerts on large datasets, which approach is best?

A Use incremental data extracts refreshed frequently instead of live connections.

B Use live connections with direct queries to the database for real-time alerts.

C Disable data extracts and rely on manual data refreshes.

D Create multiple copies of the data source for each alert.

💡 Hint

Consider how Tableau handles large data and alert refreshes efficiently.

Incremental extracts reduce load and improve alert performance by refreshing only new data, unlike live connections which can be slower and less reliable for alerts.

Practice

1. What is the main purpose of subscriptions in Tableau?

easy

A. To create new dashboards automatically

B. To send scheduled dashboard snapshots to your email

C. To instantly notify you when data changes

D. To share dashboards only within Tableau Server

Solution

1. Step 1: Understand what subscriptions do

   Subscriptions send dashboard snapshots on a schedule to your email, so you get updates without opening Tableau.

2. Step 2: Differentiate from alerts

   Alerts notify instantly when data meets conditions, not on a schedule.

3. Final Answer:

   To send scheduled dashboard snapshots to your email -> Option B

4. Quick Check:

   Subscriptions = Scheduled emails [OK]

Hint: Subscriptions send emails on schedule, alerts notify instantly [OK]

Common Mistakes:

• Confusing alerts with subscriptions
• Thinking subscriptions notify instantly
• Believing subscriptions create dashboards

2. Which of the following is the correct way to create an alert in Tableau?

easy

A. Right-click a continuous axis and select 'Create Alert'

B. Click 'Subscribe' on the dashboard toolbar

C. Export the dashboard as PDF

D. Use the 'Data Source' tab to set alert conditions

Solution

1. Step 1: Identify how alerts are created

   Alerts are created by right-clicking a continuous axis or measure and choosing 'Create Alert'.

2. Step 2: Eliminate incorrect options

   Subscribing sends scheduled emails, exporting PDF does not create alerts, and 'Data Source' tab is not for alerts.

3. Final Answer:

   Right-click a continuous axis and select 'Create Alert' -> Option A

4. Quick Check:

   Create Alert = Right-click axis [OK]

Hint: Alerts come from right-clicking continuous axes [OK]

Common Mistakes:

• Choosing 'Subscribe' instead of 'Create Alert'
• Trying to create alerts from data source tab
• Confusing export with alert creation

3. If you set an alert on Sales > 10000 and the sales data changes from 9000 to 12000, what happens?

medium

A. The alert is deleted automatically

B. You get a scheduled subscription email later

C. You receive an instant notification email

D. Nothing happens until you refresh the dashboard manually

Solution

1. Step 1: Understand alert trigger conditions

   Alerts notify you instantly when data meets the set condition, here Sales > 10000.

2. Step 2: Apply the condition to the data change

   Sales changed from 9000 (below threshold) to 12000 (above threshold), so alert triggers immediately.

3. Final Answer:

   You receive an instant notification email -> Option C

4. Quick Check:

   Alert triggers instantly on condition met [OK]

Hint: Alert triggers instantly when condition is met [OK]

Common Mistakes:

• Thinking alert waits for subscription schedule
• Believing manual refresh is needed
• Assuming alert deletes itself

4. You created an alert but never receive notifications. What is the most likely reason?

medium

A. The alert condition is never met by the data

B. You forgot to subscribe to the dashboard

C. Alerts only work on discrete fields

D. You must refresh the dashboard manually to get alerts

Solution

1. Step 1: Check alert condition relevance

   If the alert condition is never true, no notification is sent.

2. Step 2: Understand alert requirements

   Alerts work on continuous fields, subscriptions are separate, and manual refresh is not needed for alerts.

3. Final Answer:

   The alert condition is never met by the data -> Option A

4. Quick Check:

   No alert if condition false [OK]

Hint: Alerts need condition met to send notification [OK]

Common Mistakes:

• Confusing alerts with subscriptions
• Thinking alerts work on discrete fields
• Believing manual refresh triggers alerts

5. You want to receive a weekly snapshot of a sales dashboard and immediate alerts when sales exceed $50,000. How should you configure Tableau?

hard

A. Create only a subscription with a filter for sales > 50000

B. Use subscriptions only, as alerts cannot be combined with subscriptions

C. Set an alert for weekly notifications and subscribe for instant alerts

D. Create a subscription for weekly emails and set an alert on sales > 50000

Solution

1. Step 1: Understand subscription purpose

   Subscriptions send scheduled snapshots, so weekly emails require a subscription.

2. Step 2: Understand alert purpose

   Alerts notify instantly when data meets conditions, so set alert for sales > 50000.

3. Step 3: Combine both features

   Use subscription for weekly snapshots and alert for immediate notifications simultaneously.

4. Final Answer:

   Create a subscription for weekly emails and set an alert on sales > 50000 -> Option D

5. Quick Check:

   Subscription + alert = weekly + instant updates [OK]

Hint: Use subscription for schedule, alert for instant notify [OK]

Common Mistakes:

• Trying to use subscription for instant alerts
• Believing alerts can schedule emails
• Thinking subscriptions and alerts cannot be combined