Analytics-DA-201 study plan

Your step-by-step plan

1. Map the blueprint and book a date

   Day 1

   Read the official Tableau Certified Data Analyst exam guide and the four domains with their weights. Book a provisional date now, because a fixed date turns open-ended study into a plan and is the strongest predictor of actually sitting. Note the weighting hard: Explore and Analyze Data is 41 per cent and the hardest section, so it gets the lion's share of your time, while Publish and Manage Content is only 9 per cent and should be studied for accuracy rather than depth. Plan backwards from the date so the heaviest domain gets the most weeks.

2. Lock down the data foundations hands-on

   Week 1

   In Tableau Desktop, connect to a file and a database, then build the same workbook once on a live connection and once on an extract so the offline-and-speed versus real-time trade-off is muscle memory. Combine tables three ways, a relationship, a join, and a union, and watch a non-unique join key multiply rows while a relationship keeps each grain. Convert fields between dimension and measure and between discrete and continuous, set default properties and aliases, and practise Replace Data Source on a renamed field so you feel it break. This first week buys the fluency the connect-and-transform questions assume.

3. Go deep on calculations, LOD, and table calculations

   Weeks 2 to 3

   This is the engineering heart of the exam, so it gets the heaviest block. Drill the calculation functions the bank leans on, DATEDIFF versus DATEADD, COUNT versus COUNTD, IF versus CASE, INT versus FLOAT, and correct IF and ELSEIF branch ordering. Build a single sheet that shows FIXED, INCLUDE, and EXCLUDE side by side and learn the order of operations, that context filters run before FIXED while ordinary dimension filters run after. Then master table-calculation compute-using scope by switching one Running Total or Percent of Total between Table, Pane, and Cell and reading the different results. Do not move on until these are reflex.

4. Cover filters, parameters, sets, maps, and the analytics pane

   Week 4

   Finish the rest of the 41 per cent domain. Practise dimension and measure filters, Top and Bottom N, wildcard and conditional filters, and promoting a filter to context to fix a Top N. Build parameters that drive a calculation, a filter, and a reference line, and a dynamic parameter that refreshes on open. Create sets, bins, groups, and hierarchies and learn what is dynamic versus a fixed list. Build symbol, density, and filled choropleth maps and add a mark layer. Add reference lines and bands, a trend line with R-squared, distribution bands, and a forecast with seasonality.

5. Build content and learn publishing

   Week 5

   Cover Create Content and Publish and Manage together. Build each core chart from scratch and rehearse the selection cues, dual axis for differing scales, scatter for two measures, histogram for one binned measure, tree map for proportional categories, box plot for distributions. Build a dashboard with tiled and floating objects and containers, then add filter, highlight, set, and parameter actions and dynamic zone visibility. Publish a workbook built on a local file with an extract included, schedule a full and an incremental refresh, and set up an alert, a subscription, and a custom view. Learn the site-role cap and the Deny precedence rule.

6. Drill weak domains, then space the review

   Week 6

   Use your per-domain accuracy to attack the sections dragging you down rather than re-reading what you already know, and expect that to be LOD and table calculations for most candidates. Then space it: revisit each domain's recall prompts after a few days and again a week later. Spacing roughly doubles what sticks compared with cramming, and the calculation and order-of-operations judgement calls need repetition to become reflex.

7. Sit a timed mock and calibrate

   Weeks 6 to 7

   Take at least one full timed mock under exam conditions to rehearse pacing across the 60 questions and the flag-and-return habit. Treat the score as a per-domain readiness signal, not a single number, and weight the analysis domain heavily because it carries 41 per cent of the marks. Review every missed question, naming the exact Tableau behaviour or order-of-operations rule you misread, before you book or sit.

Frequently asked questions