SALESFORCE CERTIFICATION
Certified Tableau Data Analyst Practice Exam
Exam Number: 3751 | Last updated 14-Apr-26 | 581+ questions across 6 vendor-aligned objectives
The Certified Tableau Data Analyst exam validates your ability to explore, prepare, analyze, and visualize data using Tableau Desktop and Tableau Prep. It targets analysts who build workbooks that turn raw data into actionable insights, covering the full analytical workflow from data connection through published dashboards.
Expect about 25% of exam content to cover visualization design, covering chart types, formatting, color, and best practices. Data Connection and Preparation commands 20% of the blueprint, covering data sources, joins, blends, unions, and Tableau Prep. Nearly one-fifth of questions test calculated fields and expressions, covering calculations, LOD expressions, and table calculations. These high-weight domains should anchor your study plan and receive the deepest attention.
Additional sections test your breadth across the platform. The exam allocates 20% to Dashboard and Story Design, which spans layout, actions, filters, interactivity, and publishing. Expect about 15% of exam content to cover Analytics and Statistics, which spans trend lines, forecasting, clustering, and statistical functions. These areas may carry less weight on paper, but they often underpin the complex scenarios that distinguish passing candidates.
Every answer links to the source. Each explanation below includes a hyperlink to the exact Salesforce documentation page the question was derived from. PowerKram is the only practice platform with source-verified explanations. Learn about our methodology →
703
practice exam users
98.7%
satisfied users
90%
passed the exam
4.6/5
quality rating
Test your Certified Tableau Data Analyst knowledge
10 of 581+ questions
Question #1 - Enable and optimize calculations, LOD expressions, and table calculations to empower analysts with powerful calculation tools that surface deeper patterns in the data
A data analyst needs to create a calculated field that shows the running total of sales across months in a Tableau view.
What type of calculation should the analyst use?
A) A Level of Detail (LOD) expression
B) A table calculation using RUNNING_SUM(SUM([Sales])) that computes the cumulative total across the table’s partition and addressing dimensions
C) A parameter-based calculation
D) A basic SUM aggregation
Show solution
Correct answers: B – Explanation:
Table calculations like RUNNING_SUM compute values across the rows of the visualization result set, maintaining a running cumulative total. The addressing dimension (typically date) determines the calculation direction. Basic SUM gives per-period totals. LOD expressions compute at specific data granularities but are not designed for running totals. Source: Tableau Help: Calculations Tablecalculations
Question #2 - Enable and optimize calculations, LOD expressions, and table calculations to empower analysts with powerful calculation tools that surface deeper patterns in the data
An analyst needs to calculate each customer’s total annual purchases regardless of how the dashboard is filtered — even if a user filters to a specific product category, the customer total should remain the complete annual figure.
What Tableau feature should the analyst use?
A) A data source filter on Customer ID
B) A FIXED Level of Detail expression: {FIXED [Customer ID] : SUM([Sales])} which calculates the total at the customer level independent of the view’s dimensional context and filters
C) A table calculation with WINDOW_SUM
D) A standard SUM([Sales]) measure
Show solution
Correct answers: B – Explanation:
FIXED LOD expressions compute aggregations at a specified grain regardless of the view’s dimensions or filters. {FIXED [Customer ID] : SUM([Sales])} always returns the customer’s total. Standard SUM responds to filters. WINDOW_SUM operates on the view result. Data source filters restrict data globally, not per-customer. Source: Tableau Help: Calculations Calculatedfields Lod
Question #3 - Integrate and monitor data sources, joins, and blends to keep data flowing reliably between Tableau and connected data sources with minimal latency
An analyst is connecting to a large SQL Server database with 500 million rows. Building visualizations with live connections is slow.
What data strategy should the analyst implement?
A) Switch to a flat CSV file export of the data
B) Create a Tableau extract with appropriate aggregation and filtering to reduce the data volume, schedule incremental refreshes to maintain freshness, and use extract-based calculations for better performance
C) Reduce the database to 1 million rows
D) Always use live connections for real-time accuracy
Show solution
Correct answers: B – Explanation:
Extracts create optimized, compressed snapshots of data. Aggregation reduces row counts. Filters exclude irrelevant data. Incremental refreshes add only new/changed rows. Extract calculations leverage Tableau’s columnar engine. Live connections to 500M rows will always be slow. Arbitrary row reduction loses data. CSV exports lose the database connection. Source: Tableau Help: Extracting Data
Question #4 - Integrate and monitor data sources, joins, and blends to keep data flowing reliably between Tableau and connected data sources with minimal latency
An analyst needs to join data from two different data sources — a SQL database and a Google Sheet — in a single Tableau workbook.
What Tableau feature should the analyst use?
A) This is not possible in Tableau
B) Use Tableau’s cross-database join or data blending to combine the SQL database and Google Sheet data, with cross-database join for row-level matching or blending for aggregate-level combination
C) Export both sources to CSV and join them in Excel first
D) Copy data from one source into the other before connecting
Show solution
Correct answers: B – Explanation:
Tableau supports cross-database joins that combine data at the row level from different sources, and data blending that combines at the aggregate level using a linking field. Cross-database joins are preferred when row-level detail is needed. Blending works when sources have different granularity. Copying data or CSV exports are unnecessary workarounds. Source: Tableau Help: Datasource Multitable Analysis 702702
Question #5 - Integrate and monitor data sources, joins, and blends to keep data flowing reliably between Tableau and connected data sources with minimal latency
An analyst is building a dashboard and wants to let users dynamically switch between viewing data by revenue, profit, or quantity without creating three separate charts.
What Tableau technique should the analyst use?
A) Use a filter on the Measure Names dimension
B) Create three charts and hide/show them with dashboard actions
C) Create a parameter that lists the measure options and a calculated field that returns the selected measure’s value, then use the parameter to dynamically control what the chart displays
D) Build the chart with all three measures as separate axes
Show solution
Correct answers: C – Explanation:
A parameter with measure options (Revenue, Profit, Quantity) combined with a calculated field using CASE [Parameter] WHEN ‘Revenue’ THEN [Revenue] WHEN ‘Profit’ THEN [Profit] … END dynamically swaps the displayed measure. This creates a clean, single-chart experience. Hide/show multiplies maintenance. Measure Names filter changes the structure. Source: Tableau Help: Parameters
Question #6 - Integrate and monitor data sources, joins, and blends to keep data flowing reliably between Tableau and connected data sources with minimal latency
An analyst discovers that their scatter plot with 1 million data points is rendering slowly and the marks are indistinguishable.
What visualization technique should the analyst apply?
A) Change to a pie chart to avoid the point overload
B) Increase the chart size to accommodate more points
C) Apply mark density techniques: use transparency to reveal overlapping patterns, aggregate to meaningful groupings, use hexbin or density plots, or sample the data with a statistical representative subset
D) Remove data points until the chart renders quickly
Show solution
Correct answers: C – Explanation:
Mark density techniques handle large point volumes: transparency reveals overlap patterns, aggregation reduces marks to meaningful groups, density/hexbin plots show distribution patterns, and statistical sampling preserves patterns with fewer points. Removing data arbitrarily loses information. Pie charts cannot show bivariate relationships. Larger charts do not reduce visual clutter. Source: Tableau Help: View Parts
Question #7 - Enable and optimize calculations, LOD expressions, and table calculations to empower analysts with powerful calculation tools that surface deeper patterns in the data
An analyst needs to show the top 10 products by revenue in a bar chart, but also show all remaining products grouped as ‘Other’.
How should the analyst create this view?
A) Create a separate chart for ‘Other’ products
B) Manually type the top 10 product names into a set
C) Create a calculated field using INDEX() or RANK() table calculations to identify the top 10, then use a calculated field that labels products 1-10 by name and all others as ‘Other’, with a LOD expression summing the Other group
D) Filter to only the top 10 and ignore the rest
Show solution
Correct answers: C – Explanation:
A combination of RANK() or set-based approach identifies the top 10. A calculated field relabels products outside the top 10 as ‘Other’. The LOD or table calculation ensures proper aggregation of the Other group. Simple top-N filters exclude Other entirely. Manual sets do not update dynamically. Separate charts break the single-view comparison. Source: Tableau Help: Sortgroup Sets Topn
Question #8 - Craft and refine chart types, formatting, and color to deliver intuitive, responsive interfaces that drive user adoption and productivity
An analyst wants to add context to a line chart showing monthly revenue by highlighting the months where revenue exceeded target with a different color.
What Tableau feature should the analyst use?
A) Add reference lines for the target without conditional coloring
B) Use dashboard annotations to label months above target
C) Create a calculated field that compares revenue to target (e.g., IF SUM([Revenue]) > SUM([Target]) THEN ‘Above’ ELSE ‘Below’ END) and place it on the Color shelf to dynamically color the line segments
D) Manually change the color of individual data points after building the chart
Show solution
Correct answers: C – Explanation:
A calculated field evaluating the revenue-vs-target condition placed on the Color shelf dynamically colors marks based on the condition. This updates automatically as data changes. Manual coloring does not update. Reference lines show the target but do not color the line. Annotations are static and require manual updates. Source: Tableau Help: Calculations Calculatedfields
Question #9 - Integrate and monitor data sources, joins, and blends to keep data flowing reliably between Tableau and connected data sources with minimal latency
An analyst receives a dataset with date values stored as strings in YYYY-MM-DD format. Tableau is not recognizing them as dates.
How should the analyst convert these to proper date fields?
A) Use the DATEPARSE() function or change the data type in Tableau by right-clicking the field and selecting ‘Change Data Type > Date’, or use a calculated field with DATE() or MAKEDATE() functions to convert the string to a date type
B) Delete the date column and recreate it in the data source
C) Accept that Tableau cannot handle string dates
D) Manually retype every date value in the correct format
Show solution
Correct answers: A – Explanation:
Tableau provides multiple string-to-date conversion methods: DATEPARSE() handles custom string formats, data type conversion handles standard formats, and DATE() or MAKEDATE() functions construct dates from components. Manual retyping is impractical. Data source modification is unnecessary. Tableau handles string date conversion natively. Source: Tableau Help: Functions Functions Date
Question #10 - Integrate and monitor data sources, joins, and blends to keep data flowing reliably between Tableau and connected data sources with minimal latency
An analyst is preparing data in Tableau Prep and needs to merge two input files with slightly different column names and formats into a unified dataset.
What Tableau Prep operations should the analyst use?
A) Open both files in Excel and copy-paste them together
B) Use Tableau Prep’s Union step to combine the files vertically, then use the Rename and Clean operations to standardize column names, and data type conversions to align formats into a unified output
C) Connect only to one file and ignore the other
D) Manually rename columns in the source files before connecting
Show solution
Correct answers: B – Explanation:
Tableau Prep’s Union step combines files vertically. Built-in Rename fields align different column names. Data type conversions standardize formats. The flow is repeatable and automated for future file versions. Source file modification creates maintenance. Excel copy-paste is manual. Ignoring data loses information. Source: Tableau Help: Prep Combine
Get 581+ more questions with source-linked explanations
Every answer traces to the exact Salesforce documentation page — so you learn from the source, not just memorize answers.
Exam mode & learn mode · Score by objective · Updated 14-Apr-26
Learn more...
What the Certified Tableau Data Analyst exam measures
- Integrate and monitor data sources, joins, and blends to keep data flowing reliably between Tableau and connected data sources with minimal latency
- Enable and optimize calculations, LOD expressions, and table calculations to empower analysts with powerful calculation tools that surface deeper patterns in the data
- Craft and refine chart types, formatting, and color to deliver intuitive, responsive interfaces that drive user adoption and productivity
- Build and polish layout, actions, and filters to deliver intuitive, responsive interfaces that drive user adoption and productivity
- Measure and surface trend lines, forecasting, and clustering to give stakeholders timely, actionable insights that inform strategic decisions
How to prepare for this exam
- Review the official exam guide
- Complete the Tableau Data Analyst learning path and practice with public datasets from Tableau Public or Kaggle
- Build a portfolio of five dashboards using different chart types, LOD expressions, and interactive actions
- Analyze real business data at your organization and publish dashboards that stakeholders actually use
- Focus on Visualization and Calculated Fields — they combine for 45% of the exam
- Use PowerKram’s learn mode for Tableau-specific analytical questions
- Run timed exams in PowerKram’s exam mode
Career paths and salary outlook
Tableau analysts are in demand across every data-driven organization:
- Tableau Data Analyst — $80,000–$120,000 per year, building dashboards and performing data analysis (Glassdoor salary data)
- Senior BI Analyst — $100,000–$140,000 per year, leading analytics projects and mentoring junior analysts (Indeed salary data)
- Analytics Manager — $115,000–$160,000 per year, managing analytics teams and data strategy (Glassdoor salary data)
Official resources
Follow the Tableau Certified Data Analyst Learning Path. The official exam guide details every objective.