Free Tableau Data Analyst Practice Test

A data analyst needs to connect to a CSV file that is updated daily on a network drive. The analyst wants to ensure that the workbook always uses the most current data without manual intervention. Which connection type should be used?

An analyst is working with a dataset containing customer transaction dates stored as text in the format 'MM/DD/YYYY'. What is the most appropriate action to take before creating time-series visualizations?

A company has sales data in a SQL database and product information in an Excel file. The analyst needs to combine these sources for analysis. Which technique should be used when both sources cannot be joined at the database level?

An analyst creates an extract of a large dataset and needs to improve query performance by reducing the extract size. The analysis only requires data from the last two years. What feature should be implemented?

A dataset contains a single column with values like 'ProductA, CategoryX, 2023' that needs to be separated into three distinct fields. Which transformation feature should be used?

An analyst needs to calculate the percentage of total sales for each product category. When dragging the Sales measure to the view, which table calculation should be applied?

A visualization shows monthly sales trends, but the analyst wants to compare each month's performance against the previous month. What table calculation computing method should be used?

An analyst creates a scatter plot showing Sales vs. Profit and wants to add a statistical reference line showing the average profit across all data points. What feature should be used?

A data analyst needs to identify outliers in a sales dataset that contains thousands of records. Which visualization type is most effective for quickly identifying outliers in a single measure across multiple categories?

An analyst creates a calculated field with the formula: IF [Sales] > [Target] THEN 'Above Target' ELSE 'Below Target' END. The calculation returns an error. What is the most likely cause?

A workbook contains a complex calculation used across multiple worksheets. To maintain consistency and simplify updates, what approach should the analyst take?

An analyst wants to allow users to switch between viewing sales by Region, Category, or Customer Segment without creating separate worksheets. What feature accomplishes this most efficiently?

A dashboard contains multiple worksheets, and the analyst wants users to click on a region in one view to filter all other views to show only that region's data. What should be implemented?

An analyst creates a map visualization but notices that several city names are not being recognized and appear as unknown. What is the best approach to resolve this issue?

A dashboard needs to display KPI values prominently with conditional formatting that shows green when above target and red when below. What is the most appropriate visualization type?

An analyst needs to create a visualization showing hierarchical data with parent-child relationships, such as organizational structure or product categories and subcategories. Which chart type best represents this structure?

A complex dashboard contains multiple data sources and calculated fields. Users report slow performance when interacting with filters. What optimization technique should be prioritized first?

An analyst needs to create a dual-axis chart showing both Sales (in dollars) and Quantity (in units) over time, with synchronized axes to allow accurate comparison. After creating the dual axis, what additional step is required?

A data analyst creates a workbook that needs to be shared with executives who don't have Tableau Desktop. The workbook must remain interactive and accessible via web browser. What sharing method should be used?

An analyst publishes a workbook to Tableau Server and needs to ensure that users only see data relevant to their region. The data contains a Region field, and user information includes their assigned region. What security feature should be implemented?