50 Tableau Data Analyst Practice Questions: Question Bank 2025

You connect Tableau to a CSV file that is updated weekly by replacing the file in the same network folder with the same filename. Which approach best ensures the workbook continues to refresh with the latest data?

A worksheet shows sales by month. The business asks to highlight months where sales are above the overall average sales across all months. Which Tableau feature is the most appropriate?

You are building a dashboard for executives and want users to click a region on a map and have other charts update to that selection. Which dashboard action should you use?

You published a data source to Tableau Cloud and want colleagues to find it easily and trust that it is approved for use. What is the best practice to communicate that the data source is recommended?

A table contains a single field named FullName with values like "Nguyen, An". You need separate fields for Last Name and First Name in Tableau Prep. What is the best approach?

You need a KPI that shows the percent of total sales contributed by each product category, and it must always total 100% even when users filter to a single region. Which calculation is most appropriate?

A view shows customer counts by State. Some states are missing even though they exist in the data. The State field is a text field with values like "CA" and "California" mixed together. What is the most likely cause and best fix?

You are designing a dashboard for mobile and want a single layout that adapts to different screen sizes with minimal maintenance. Which approach is recommended?

A published dashboard contains row-level employee salary data. Analysts should see all rows, but executives should only see aggregated totals by department. You must use a single published data source. What is the best design?

You have two tables: Orders (OrderID, CustomerID, OrderDate) and Returns (OrderID, ReturnDate). You want to analyze return rate without duplicating orders that have multiple return records. What is the best approach in Tableau when building the data model?

A data analyst blends two data sources using a shared key. Several records that appear in the secondary source do not show up in the view. What is the most likely reason?

A view shows sales by month. The bars are sorted alphabetically by month name (Apr, Aug, Dec...) rather than chronologically. Which change is the best practice to ensure correct chronological order?

A dataset contains Order Date as text values like "2025-01-15" and "2025/01/16". The analyst needs a usable date field in Tableau. What is the best approach in the data preparation step inside Tableau?

A user applies a filter to show the last 6 months of data, but the range changes unpredictably when the workbook is opened in a different time zone. What is the best solution?

A dashboard has a large cross-tab sheet used for detail. Users complain the dashboard is slow, especially when interacting with filters. Which design change is most likely to improve performance without changing the underlying data?

An analyst wants to display the percentage of total sales for each product category within each region (so each region sums to 100%). What feature should they use?

A manager wants a dashboard that lets users click a bar in a chart to filter all other sheets on the dashboard to that selection. Which technique should the analyst use?

A workbook contains a field called "Customer Segment" with values like "SMB", "MidMarket", and "Enterprise". Leadership requests that segments be displayed in a custom order: Enterprise, MidMarket, SMB. What is the most maintainable way to implement this ordering?

A published data source includes row-level security using user filters. Some users still see rows they shouldn’t after the workbook is published. What is the most likely cause?

A dashboard uses a Level of Detail (LOD) calculation to compute "Customer Lifetime Revenue" fixed at Customer ID. When users apply a date range filter, the LOD value does not change, causing confusion. What should the analyst do to make the LOD respect the date filter while keeping the FIXED logic?

An analyst connects to a CSV extract and notices that the Order Date field is being interpreted as a string, preventing use of date hierarchies. What is the best first step in Tableau to fix this?

You want to let consumers of a dashboard choose which measure (Sales, Profit, or Quantity) is displayed in a single chart without duplicating worksheets. Which feature is best suited for this requirement?

A dashboard shows many marks and takes a long time to render. Which action is generally a best practice to improve performance with minimal design change?

You have an Orders table (Order ID, Customer ID, Order Date) and a Customers table (Customer ID, Segment). You want Segment available for each order without duplicating or losing orders. Which join configuration is most appropriate?

A bar chart shows Sales by Category. You want to highlight bars where Sales are at least 20% above the overall average Sales across all categories. What is the most appropriate approach?

A dashboard contains two worksheets: a map and a trend line. Users want to click a state on the map and have the trend line update to only that state, while keeping the dashboard uncluttered. Which solution best meets this need?

You need a single field that shows the latest non-null value of a status over time for each case, even if the most recent record has a null status. Which approach is most appropriate?

A published data source is used by several workbooks. You need to change a calculation used across all workbooks with minimal rework and consistent results. What is the best practice?

A data model includes a fact table at the transaction level and a quota table at the monthly salesperson level. In a single view, you want to compare actual Sales (transactions) to Quota (monthly) by salesperson and month without inflating quotas. What is the best modeling approach in Tableau?

A dashboard uses a Top N filter driven by a parameter. Users report that when they change the parameter, the view does not update until they click elsewhere. What is the most likely fix?

A dashboard shows different totals depending on whether the user selects a Region filter first or a Product filter first. The analyst suspects filter order is affecting results because some filters are context filters. What is the best practice to make the behavior predictable and improve performance when a high-cardinality dimension is used to reduce the dataset early?

An analyst needs to show the percent of total sales by Category within each Region on the same view. What calculation should the analyst use to ensure the percent is computed within each Region partition?

A data source contains a field [Order Date] stored as a string in the format "2026-01-24". The analyst needs to trend orders by month. What is the most appropriate first step in Tableau?

A dashboard contains a map, a bar chart, and a detail table. The business wants users to click a bar to filter the map and table to only that segment, without adding extra filter controls. Which feature should the analyst use?

A workbook uses data blending between an Orders data source (primary) and a Targets data source (secondary). The analyst notices duplicated Target values when viewing by Product Subcategory. What is the most likely cause?

An analyst creates a relationship between two logical tables: Customers and Orders. After adding a Customers field and an Orders measure to the view, the analyst sees unexpected totals. What Tableau concept most directly explains how relationships behave compared to joins?

A line chart shows monthly sales over time. The analyst wants to label only the last point in each line to reduce clutter while keeping the rest unlabeled. What is the recommended approach?

A published data source includes fields that should not be visible to most users (e.g., employee SSN). The organization wants to allow analysts to use the same published data source while preventing unauthorized access to sensitive fields. What is the best solution?

A dashboard uses a COUNTD([Customer ID]) metric and takes a long time to load against a large database table. The analyst needs to improve performance without changing the business definition. Which approach is most effective?

An organization needs to share a dashboard externally to clients who do not have Tableau licenses. Clients must be able to interact with filters, and the organization wants to maintain centralized governance and authentication. Which solution best fits these requirements?

A Tableau Desktop user wants to see only the top 10 customers by Sales, but still include an 'All Customers' total bar in the same view for comparison. What is the recommended approach?

A data source contains Order Date as a datetime field. The analyst needs a chart showing monthly Sales trends. Which action is the best practice to create the month level of detail?

A dashboard contains several filters. Users report that changing a filter is affecting only one worksheet, but they expected it to update all related views in the dashboard. What should the analyst check first?

An analyst unions monthly CSV files that have the same columns, but some months are missing a column that exists in other files. After the union, the analyst sees many nulls and unexpected extra fields. What is the best way to standardize the union?

A workbook uses a map and a bar chart that should highlight together when a user selects a region on the map. The highlight works on the map but not on the bar chart. What configuration most likely fixes this?

A dataset has multiple records per customer, including Customer ID, Order ID, and Customer Segment. The analyst wants Segment to appear once per customer in the view without duplicating due to multiple orders. What is the best approach?

An analyst creates a scatter plot with Sales on Columns and Profit on Rows. They want marker size to represent Order Quantity and color to represent Profit Ratio. Which shelf placements accomplish this correctly?

A published dashboard will be used on both desktop monitors and mobile devices. The analyst wants to provide a good mobile experience while maintaining a desktop layout. What is the recommended design approach in Tableau?

A Tableau view shows Year and Month in the header. The analyst adds a filter on Month, but the results are incorrect because the Month filter is applied across all years (e.g., selecting "January" keeps January for every year). They need the filter to apply to a specific Year-Month combination. What should they do?

A workbook uses a live connection to a database. Users complain the dashboard is slow because each interaction triggers heavy queries. The organization cannot change the database. Which Tableau approach most directly improves interactivity performance while keeping data reasonably current?