Short answer: no. The Salesforce Certified Tableau Data Analyst exam (Analytics-DA-201) no longer has a hands-on lab. It’s 60 scored questions in 105 minutes, and you need 65% to pass. Many questions still describe a worksheet and ask what you’d do or what result you’d get, so hands-on practice in Tableau is still the best preparation. That’s what the questions below are for.
Old vs current Data Analyst exam format
| Old format (to 2024) | Current (Analytics-DA-201) | |
|---|---|---|
| Items | 30 knowledge items + 1 hands-on lab | 60 MC/MS + up to 5 unscored |
| Time | 120 min | 105 min |
| Lab | yes | no |
| Pass | 750 scaled | 65% |
New to the exam? Start with the Data Analyst study guide, then take the Data Analyst practice exam.
Instructions
Open this Tableau workbook and take the steps to answer the following questions. Then save the workbook and check your steps using the Lab Solutions document. For a realistic practice exam experience, don’t use outside resources (like google) to figure out how to solve these problems. A PDF version of Tableau help is provided during the lab portion of the exam, so you should feel free to refer to it as you work through the problems.
Hands-on practice questions (do these in Tableau)
Lab Question 1
Modify the Avg Oil Price worksheet to use a moving average of the current month and the five months prior.
Lab Question 2
On the data source page, create a union of the PostCPI and PreCPI tables.
Lab Question 3
Create a calculation that combines Month and Year into a date field. Set the date to be the first of the month for the specified date and year so that for example “May” and “2018” becomes May 1st, 2018.
Lab Question 4
Rename the CPI field to “Consumer Price Index”
Lab Question 5
On the Oil Price Histogram worksheet, change the bin size to 10.
Lab Question 6
Update the “Cold Price Table” worksheet so that only the top 5 values with the highest average gold price are shown.
Lab Question 7
Change the default format for Gold Price to so that, for example, a value of 100 will have a default formatting of $100.00.
Lab Question 8
On the “Gold by Year/Month” worksheet, add a reference line showing the lowest value for each year
Lab Question 9
Add a linear trend line to the scatterplot.
Lab Question 10
Add subtotals to the Price Table worksheet.
Solutions
Download PDF solutions to these Data Analyst lab questions
FAQ
Do I need Tableau installed during the exam?
No. It’s a proctored, question-only exam. You do need Tableau to practice, and Tableau Desktop Free Edition works for that.