Examworthyexamworthy.comTableau Certified Data Analyst cheat sheet
Tableau
Free to share. Examworthy is not affiliated with or endorsed by Tableau; Analytics-DA-201 and related marks belong to their respective owners.
At a glance
Format: Multiple choice and multiple response
Domain weight map
Heaviest first - spend your time hereHow this exam thinks
The Tableau Data Analyst exam rewards the answer that matches Tableau's documented behaviour and the analytical goal in the scenario, the right connection type, the right combine method, the right calculation or LOD, and the right publishing control, not the option that merely sounds capable.
Spot the trap
Tempting wrong answers, and why they failTempting but wrong
To count complete months subscribed, write DATEDIFF('month', [Cancel Date], [Signup Date]) minus the day adjustment.
Why it fails
The day-adjustment is correct, but the two date arguments are reversed. DATEDIFF returns a negative value for any customer who cancels after signing up. The arguments must run start then end.
Explore and Analyze Data
Tempting but wrong
Can a single-axis line chart drawing both measures against the same scale show revenue and margin clearly?
Why it fails
Drawing both on one axis is the natural first attempt, but the percentage line would be flattened against the much larger revenue scale, defeating the comparison.
Create Content
Tempting but wrong
A live connection works for offline analysts because every interaction simply reflects the database's current real-time state.
Why it fails
Tempting because live connections do show current data, but a live connection sends a query to the source on every interaction. That fails the offline requirement and worsens the throttling the team is trying to avoid.
Connect to and Transform Data
Tempting but wrong
Can you just publish the workbook with a live connection to the local Excel file path so colleagues can view it?
Why it fails
Tempting because nothing seems to need changing, but a live connection to a local file path is only reachable from the analyst's own machine. Colleagues on Tableau Cloud would see an error when the laptop is off, which is the very problem being avoided.
Publish and Manage Content on Tableau Server and Tableau Cloud
Tempting but wrong
Subtract month numbers with DATEPART, then adjust by the day, to count months subscribed.
Why it fails
Subtracting month numbers ignores the year, so it miscounts across year boundaries and returns a negative figure when the cancel month is numerically lower than the signup month.
Explore and Analyze Data
Tempting but wrong
Does a clustered bar chart of average defect count per line let you compare the spread across production lines?
Why it fails
A bar of averages summarises each line with one number and hides the spread, quartiles, and outliers that the team needs to compare.
Create Content
Tempting but wrong
Keep a live connection but lower the workbook's refresh frequency so the source receives fewer queries during business hours.
Why it fails
Tempting because it sounds like a throttling fix, but there is no per-interaction refresh frequency to lower on a live connection. Each view interaction still issues a query, so it solves neither offline access nor throttling.
Connect to and Transform Data
Tempting but wrong
Is giving each report its own packaged workbook with an embedded copy of the connection a good way to share one governed model?
Why it fails
Tempting because it is simple per report, but embedding a private copy of the connection in every workbook duplicates the model. There is no single shared place for naming and calculations to be governed, so they drift apart.
Publish and Manage Content on Tableau Server and Tableau Cloud
Exam-day rules
- Read each scenario for the analytical goal and the stated constraint first, then match it to Tableau's documented behaviour. The distractors are written to sound reasonable; the right answer is the feature that delivers the stated goal, not the one that merely sounds capable.
- Spend your study time where the marks are. Explore and Analyze Data is 41 per cent of the exam and the hardest domain, so make it solid before polishing dashboards, and study the 9 per cent publishing domain for accuracy rather than depth.
- On connection questions, decide on offline versus real-time. Choose an extract for offline access and fast in-memory querying against a busy source, and a live connection only when interactions must reflect the latest rows and the source can take the load.
- On combine questions, pick by what must be preserved: a relationship to keep each table at its own grain without multiplying rows, a join when you truly need one flattened row-matched result, and a union to append more rows of the same shape.
- For level of detail, read against the view: FIXED ignores the view's dimensions, INCLUDE refines the grain, and EXCLUDE coarsens it. Remember context filters run before FIXED while ordinary dimension filters run after, so promote a filter to context to narrow a FIXED total or a Top N.
Revision schedule
- Day 1Map the blueprint and book a date
- Week 1Lock down the data foundations hands-on
- Weeks 2 to 3Go deep on calculations, LOD, and table calculations
- Week 4Cover filters, parameters, sets, maps, and the analytics pane
- Week 5Build content and learn publishing