Tableau Data Analyst Practice Exam 2025: Latest Questions

A data analyst connects to a CSV file and notices the first row of actual data is being treated as column headers in Tableau. What is the best way to fix this in the data source?

A worksheet shows Sales by Category. The analyst wants to compare each category’s sales to the overall total sales in the view as a percent of total. Which feature should they use?

A stakeholder wants a dashboard to allow users to click a bar in a chart and filter the rest of the dashboard to that selection. What should the analyst enable?

A workbook has been published to Tableau Server/Cloud. The publisher wants viewers to always see the most up-to-date data from the database without manually refreshing the workbook. What should be configured?

An analyst joins Orders (one row per order) to Order Items (multiple rows per order). After joining, the analyst notices total Order Revenue is higher than expected. What is the most likely cause and best fix?

A view shows Sales by Region. The analyst wants to display each region’s rank (1 = highest Sales) and also filter to only show the Top 5 regions. What is the recommended approach?

A dashboard contains three sheets and a filter for Order Date. The analyst wants the Order Date filter to control all three sheets, even when users navigate between dashboard tabs in the same workbook. What should the analyst do?

A published dashboard is slow for many users at the same time. The data source is a live connection to a database that struggles under concurrency. Which change most directly improves performance while keeping the analysis accurate?

An analyst needs to calculate Month-over-Month (MoM) growth for Sales and ensure it works correctly even when users filter to a single Region. The current calculation breaks (shows nulls or wrong values) when filters are applied. What is the best approach?

A company wants row-level security so that each sales rep only sees their own accounts in a published dashboard. The same workbook must serve all reps without creating separate workbooks. Which design best meets this requirement?

A Tableau user connects to a CSV that contains a column named "Order Date" stored as text (e.g., "2025-01-15"). In the Data Source page, the field is treated as a string, preventing date functions in the worksheet. What is the best way to fix this in Tableau?

A stakeholder asks for a quick check of whether this month’s sales are above or below last month’s sales on a single KPI tile. Which feature is most appropriate to create this comparison in Tableau?

A dashboard is crowded, and the author wants to show additional details only when a user hovers over a mark (without adding more worksheets or filters). What is the best option?

You have two tables: Orders (Order ID, Customer ID, Order Date) and Customers (Customer ID, Segment). You need Segment on views built from Orders, and you want Segment filtering to apply without duplicating rows. What is the best approach on the Data Source page?

A view shows Sales by Category. The business wants the bars sorted by the latest month’s Sales, even when multiple months are in the data. What should you do?

A dashboard uses an action filter from a "Region" map to filter several worksheets. Users report that clicking a region sometimes results in an empty dashboard. What is the most likely cause and best fix?

A workbook contains a calculation: IF [Profit] > 0 THEN "Positive" ELSE "Negative" END. The analyst now wants a third state for null Profit values called "Unknown". What is the best revision?

You publish a data source to Tableau Cloud and want analysts to use a certified, governed version while still allowing them to build workbooks. Which approach best supports this goal?

You have a fact table Sales (many rows per Customer) and a target table Customer Targets (one row per Customer per Year). You relate the tables on Customer ID only. When you build Sales by Year with Target, targets appear duplicated across months. What is the best fix?

A dashboard includes two charts: one by Product Category and another by Sub-Category. The user wants clicking a Category to update the Sub-Category chart, but clicking a Sub-Category should NOT filter the Category chart. What should you configure?

A dashboard contains a map view with several geographic fields. Users report that selecting a state on the map does not filter other sheets on the dashboard. The map sheet and the other sheets use different data sources. What is the most likely reason the filter action is not working?

You are preparing a dataset for analysis and notice that a single column contains values like "$1,200", "950", and "1,050" (stored as text). You need the field to behave as a number for aggregations. What is the best approach in Tableau?

A dataset has one row per order, including a field called DiscountPercent (e.g., 0.10, 0.15). The business wants to see the overall discount rate across all orders weighted by sales amount (i.e., total discount dollars divided by total sales). Which calculation is most appropriate?

You need a dashboard that supports detailed troubleshooting by users (drill from a KPI to the underlying records) while also maintaining fast performance. The fact table contains tens of millions of rows. Which approach is the best practice?

A user creates a bar chart showing Sales by Category and adds a filter for Region. They want the bars to always appear sorted in descending Sales for the selected Region. After applying the filter, the sort order does not update as expected. What should they do?