Salesforce-Tableau-Data-Analyst Exam Questions With Explanations

The best Salesforce-Tableau-Data-Analyst practice exam questions with research based explanations of each question will help you Prepare & Pass the exam!

Over 15K Students have given a five star review to SalesforceKing

Why choose our Practice Test

By familiarizing yourself with the Salesforce-Tableau-Data-Analyst exam format and question types, you can reduce test-day anxiety and improve your overall performance.

Up-to-date Content

Ensure you're studying with the latest exam objectives and content.

Unlimited Retakes

We offer unlimited retakes, ensuring you'll prepare each questions properly.

Realistic Exam Questions

Experience exam-like questions designed to mirror the actual Salesforce-Tableau-Data-Analyst test.

Targeted Learning

Detailed explanations help you understand the reasoning behind correct and incorrect answers.

Increased Confidence

The more you practice, the more confident you will become in your knowledge to pass the exam.

Study whenever you want, from any place in the world.

Salesforce Salesforce-Tableau-Data-Analyst Exam Sample Questions 2025

Start practicing today and take the fast track to becoming Salesforce Salesforce-Tableau-Data-Analyst certified.

2654 already prepared
Salesforce Spring 25 Release
65 Questions
4.9/5.0

Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.


Explanation:

To add a distribution band on the Profit measure to show the standard deviation from -1 to 1 in the SalesVSProfit worksheet of the Book1 Tableau workbook, follow these steps. This process assumes you are working in Tableau Desktop and that the SalesVSProfit worksheet contains a visualization (e.g., a scatter plot) with Sales and Profit data, likely from the Sample Superstore dataset.

Steps to Add a Distribution Band:

1. Open the Workbook:
Locate and open the Book1 link on your desktop. This will launch Tableau Desktop and load the Book1 workbook.

2. Navigate to the SalesVSProfit Worksheet:
At the bottom of the Tableau workbook, click the SalesVSProfit tab to open the worksheet. You should see a visualization, such as a scatter plot, showing the relationship between Sales and Profit for a dimension (e.g., Sub-Category).

3. Access the Analytics Pane:
➡️ On the left side of the Tableau Desktop interface, locate the Analytics tab (next to the Data pane).
➡️ Click the Analytics tab to open the Analytics pane, which lists analytical objects like Reference Line, Distribution Band, and Box Plot.

4. Add the Distribution Band:
➡️ In the Analytics pane, find Distribution Band under the Model section.
➡️ Drag Distribution Band from the Analytics pane and drop it onto the Profit measure on the Rows shelf (or the axis where Profit is displayed, typically the vertical axis in a scatter plot).
➡️ Tableau will display a dialog box titled Edit Reference Line, Band, or Box.

5. Configure the Distribution Band:
In the Edit Reference Line, Band, or Box dialog box:

➡️ Scope: Select Table, Pane, or Cell depending on the desired scope. For a scatter plot with Sub-Category on the Columns shelf, Table is typically appropriate to compute the standard deviation across all data points in the view.
➡️ Value: Choose Standard Deviation from the dropdown menu.
➡️ Factors: Set the Band From value to -1 and the Band To value to 1. This configures the band to show one standard deviation below and above the mean of Profit.
➡️ Label: Choose an option for labeling (e.g., Value to show the standard deviation values, Computation to show the field name, or Custom for a custom label). For clarity, Value is often used.
➡️ Formatting: Adjust line styles, colors, or shading as needed (e.g., select a fill color for the band to make it visible).

Click OK to apply the changes.

6. Verify the Result:
The visualization will now display a shaded band on the Profit axis, representing the range from -1 to +1 standard deviations from the mean of Profit. This band highlights the variability of Profit values, with approximately 68% of the data (assuming a normal distribution) falling within this range.

Explanation:
➡️ What the Distribution Band Does: The distribution band visualizes the spread of Profit values around the mean, with the -1 to 1 standard deviation range indicating where most data points lie in a normal distribution. In a scatter plot, this band appears as a shaded area along the Profit axis, helping to identify outliers or typical profit ranges.

➡️ Scope Considerations:
Table: Computes the standard deviation across all data in the view (e.g., all Sub-Categories).
Pane: Computes the standard deviation for each pane (e.g., each Sub-Category if Sub-Category is on the Columns shelf).
Cell: Computes the standard deviation for each mark (less common for this scenario).

For a grand total across all regions or categories, Table is typically the correct scope, but adjust based on the visualization’s structure.

➡️ Standard Deviation: The band from -1 to 1 standard deviations covers approximately 68% of the data in a normal distribution, making it a common choice for visualizing data variability.

Notes:
➡️ If the SalesVSProfit worksheet is a scatter plot with Sub-Category on Columns, Profit on Rows, and Sales on Columns or another shelf, the distribution band will apply to the Profit axis across all Sub-Categories (if Table scope is selected).
➡️ If the visualization includes filters or other dimensions, ensure they don’t restrict the data in a way that affects the standard deviation calculation.
➡️ The question about adding a comment to March 2020 from your previous query is unrelated to this task, as distribution bands are about visualizing data spread, not adding comments. If you need to add a comment or annotation, that would involve right-clicking a data point for March 2020 and selecting Annotate > Mark or Annotate > Point, but this is not part of the current question.

Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.


Explanation:

The task requires creating a filled map (also known as a choropleth map) in Tableau Desktop to visualize the distribution of total Sales by State across the United States, using the Sample - Superstore data source in the Map worksheet of the Book1 workbook. A filled map uses color shading to represent the value of a measure (here, total Sales) across geographic regions (here, U.S. states). Below is a detailed explanation of the task, why it’s relevant for the Salesforce Tableau Data Analyst Exam, and how to execute it, addressing the provided options and their irrelevance.

Context and Purpose:
➡️ Objective: The goal is to create a visualization that shows how total Sales vary across U.S. states, with each state shaded according to its sales value. This helps identify geographic patterns, such as which states have higher or lower sales.
➡️ Data Source: The Sample - Superstore dataset, a standard dataset in Tableau, includes fields like State (a dimension with a geographic role for U.S. states), Sales (a measure), and others like Category or Profit. It’s commonly used in Tableau training and certification exams.
➡️ Worksheet: The Map worksheet in the Book1 workbook is the target location for the visualization.
➡️ Relevance to Exam: This task aligns with the “Create Content” section (26% of the Salesforce Tableau Data Analyst Exam), which tests skills in building visualizations, including maps, to represent data distributions effectively.

Why a Filled Map?
A filled map is ideal for showing the distribution of a measure (Sales) across geographic areas (States). Each state is filled with a color, where the shade or intensity represents the magnitude of total Sales (e.g., darker shades for higher sales).
Tableau automatically recognizes the State field in the Superstore dataset as a geographic field, enabling map creation without additional configuration.
The filled map provides a quick, intuitive way to compare sales performance across states, useful for business analysis (e.g., identifying high-performing regions).

Steps to Create the Filled Map:

Here’s how to accomplish the task in Tableau Desktop:

1. Open the Workbook:
Locate the Book1 link on your desktop and double-click to open it in Tableau Desktop.
This loads the workbook, which should include the Sample - Superstore data source.

2. Navigate to the Map Worksheet:
At the bottom of the Tableau interface, find the Map worksheet tab and click to open it.
If the worksheet already contains a visualization, you can modify it; if blank, you’ll build the map from scratch.

3. Verify the Data Source:
In the Data pane on the left, ensure the Sample - Superstore data source is selected. Look for fields like State (under Dimensions, with a globe icon indicating its geographic role) and Sales (under Measures).

4. Create the Filled Map:
➡️ Add State to the View:
Drag the State field from the Data pane to the Detail shelf in the Marks card (or drop it directly onto the worksheet canvas).
Tableau recognizes State as a geographic field and generates a map view, initially with symbols (e.g., circles) for each state.

➡️ Change to Filled Map:
In the Marks card, click the mark type dropdown (initially set to Automatic or Circle) and select Map. This converts the visualization to a filled map, where each state is a filled shape.

➡️ Add Sales to Color:
Drag the Sales measure from the Data pane to the Color shelf in the Marks card.
Tableau automatically aggregates Sales as SUM(Sales), coloring each state based on its total sales. A color gradient (e.g., light to dark) appears, with a legend showing the sales range.

5. Customize the Visualization:
➡️ Color Palette:
Click the Color shelf, then Edit Colors. Choose a gradient palette (e.g., Blue, Orange-Gold, or Green) to represent sales. Select Reversed if you want higher sales to appear darker.

➡️ Labels (Optional):
Drag Sales to the Label shelf to display sales values on each state.
Format labels by clicking Label > Format, selecting Currency (Standard) or $#,##0 for readability.

➡️ Map Layers:
Go to the Map menu > Map Layers.
Adjust Washout to make state boundaries clearer, enable State/Province Borders, or add other map features like coastlines.
Ensure the map is zoomed to the United States (use Map > Map Options or zoom manually).

➡️ Tooltip:
Click the Tooltip shelf and edit to include fields like State and SUM(Sales) (e.g., “State: , Total Sales: $<SUM(Sales)>”) for user interaction.

➡️ Filter Non-U.S. Data (if needed):
If the Superstore dataset includes non-U.S. data (e.g., Canada), drag Country to the Filters shelf and select United States.

6. Finalize and Save:
Double-click the worksheet title and rename it (e.g., “Total Sales by State”).
Verify the map shows U.S. states shaded by total Sales, with a color legend indicating the range.
Save the workbook to preserve changes.

Result:
The filled map displays each U.S. state shaded according to its total Sales from the Superstore dataset. For example:
🧩 States with high sales (e.g., California, New York) might appear in darker shades.
🧩 States with low sales might appear in lighter shades.
🧩 Hovering over a state shows a tooltip with the state name and total sales.
🧩 The color legend on the right indicates the sales range (e.g., $0 to $500,000).

Open the link to Book1 found on the desktop. Open the sales dashboard.
Add the Sales by State sheet in a Show/Hide button to the right side of the dashboard.


Explanation:

✅ Goal: Embed the “Sales by State” worksheet into the Sales dashboard, and control its visibility using a Show/Hide button placed on the right.

🧭 Step-by-Step Instructions:

1. Open Book1 from the Desktop:
➜ Launch Tableau and open Book1.
➜ Navigate to the Sales dashboard.

2. Drag in a Floating Vertical Container (Optional, but helpful):
➜ From the Objects pane, drag a Vertical Container into the dashboard.
➜ Set it as Floating, and place it on the right side of the dashboard.
➜ This container will help control layout and make toggling smoother.

3. Add the “Sales by State” Worksheet:
➜ Drag the Sales by State sheet into the container (or directly into the dashboard) on the right side.
➜ Make sure it’s set to Floating, if not already.
➜ Size and position it so that it fits nicely along the right edge.

4. Add a Show/Hide Button:
➜ Select the Sales by State sheet (you should see a blue border around it).
➜ In the top-right of that container, click the small dropdown arrow (more options).
➜ Click “Add Show/Hide Button”.
➜ Tableau will add a toggle button—drag this button to a visible area, like near the right edge of the dashboard.
➜ You can customize the button (e.g., change icon or label) in the Item hierarchy under Layout pane.

5. Test the Button:
➜ Click the button. It should toggle the visibility of the Sales by State sheet.
➜ Click again to hide/show.

🧩 Tips:
➜ If needed, you can add text or an image instead of the default button using the "Edit Button" option.
➜ You may want to format the worksheet or container background to make it stand out or match your dashboard theme.

📘 Tableau Reference:
Show/Hide Button for Dashboard Objects

In which three formats can you export a worksheet from the Worksheet menu? Choose three

A. png

B. .html

C. .xlsx

D. .txt

E. .pptx

F. .csv

A.   png
C.   .xlsx
E.   .pptx

Tableau provides various options to export data from a worksheet. The formats available are typically those that are best suited for visualization or further data analysis. The options include:

.png for exporting images of the visualizations
.xlsx for exporting data in a format that can be opened with Microsoft Excel
.pptx for creating PowerPoint presentations with the visualization embedded

These formats are designed to facilitate sharing and presenting the insights derived from Tableau visualizations, or for conducting further analysis in tools like Excel.

You create a worksheet named Sales by Region and hide the tide of the worksheet. You print the worksheet as a PDF and notice that the worksheet title appears. You need to prevent the title from appearing when you print the worksheet as a PDF. Which settings should configure from the File menu in Tableau Desktop?

A. Page Setup

B. Print

C. Export As PowerPoint

D. Share

E. Export As Version

A.   Page Setup

Explanation:

Even if you hide the worksheet title in Tableau Desktop, it can still appear in printed or exported views depending on the print/export settings.
The Page Setup dialog (File → Page Setup) controls:
Whether sheet titles, captions, and legends are included in the printed/PDF output.
Margins, scaling, orientation, and other page layout settings.
To prevent the title from appearing in the PDF:
Go to File → Page Setup.
In the Print Options section, uncheck Show Title.
Save and then Print to PDF.

Why the other options are wrong
B. Print → This lets you print/export directly, but it won’t give you the control to disable sheet titles unless you already configured Page Setup first.

C. Export As PowerPoint → Exports to slides, not PDFs.

D. Share → Used for publishing to Tableau Server/Cloud or saving packaged workbooks, not print layout.

E. Export As Version → Used to save to an older Tableau version, unrelated to printing.

Reference:
Tableau Help — Page Setup
Tableau Help — Print to PDF

Prep Smart, Pass Easy Your Success Starts Here!

Transform Your Test Prep with Realistic Salesforce-Tableau-Data-Analyst Exam Questions That Build Confidence and Drive Success!