Tableau Data Analyst Intermediate Practice Exam: Medium Difficulty 2025

A retail analyst connects Tableau to a transactional sales table (one row per line item) and a product table (one row per product). After joining on Product ID, the analyst notices revenue is inflated in the view when slicing by product category. What is the most likely cause and best fix?

A company has a spreadsheet with monthly targets by Region and Month, and a database table with daily actual sales by Region and Order Date. They need a dashboard comparing actuals vs targets by month and region. What is the best approach in Tableau to combine these datasets while keeping each at its native level of detail?

An analyst needs to create a calculation that flags customers as "High Value" if their total sales over the last 90 days are in the top 10% within their region. The dashboard must respect filters for Product Category but ignore filters for Sales Rep. Which approach best meets these requirements?

A dashboard shows profit by State on a filled map. Users complain that small states are hard to compare and want a view that still communicates geography while enabling easier comparison across states. What is the best design change in Tableau?

An analyst is investigating a spike in returns. They want to let users click a product category in a bar chart to filter multiple other views on the dashboard, but also allow users to select multiple categories without holding keyboard keys. What should the analyst implement?

A sales dashboard needs a "Period over Period" comparison showing current month sales, prior month sales, and the percent change. The business uses a custom fiscal calendar that doesn’t match calendar months. What is the most reliable way to build this in Tableau?

A team is building a dashboard for executives. They want a KPI header with current revenue, a target indicator, and a small trend line (sparkline). The layout must remain aligned across different screen sizes. Which approach best supports a consistent, responsive layout in Tableau dashboards?

A workbook uses a shared data source with a custom hierarchy (Category > Subcategory > Product) and standardized calculations for margin. The team wants all analysts to reuse these definitions across many workbooks and reduce the risk of inconsistencies. What should they do?

A dashboard includes a long table of customer records. Users want to click a customer and navigate to a detailed customer profile dashboard in the same site, passing the Customer ID. What is the best feature to use?

A manager shares a dashboard broadly, but regional leaders should only see data for their own region. The same workbook should work for all users without creating separate copies. What should be implemented?