I recently took the Tableau Desktop Certified Data Analyst exam, and I wanted to write up how I prepped for it. Looking at what I focused on, when, and why.
A few Months of just Living in Tableau
Before I ever opened a practice exam, I spent a few months doing something less structured: just getting genuinely comfortable in the tool. And I mean the whole tool, not just the dashboarding part.
It's easy to only practice the part you enjoy. For me that's building the actual viz and getting the interactivity right. But the exam doesn't care about what I enjoy. It wants to know if I understand the tooltips, the menus I never click, the settings buried within a right-click. So for a while I made a point of clicking on things I'd normally skip past. What does this option in the Analytics pane actually do? What's hiding in this dropdown I've walked by a hundred times? I wanted the interface itself to stop feeling like a black box.
Truth be told, Tableau is amazing in that there can sometimes be multiple ways to get one thing done. For example, imagine you are swapping a sheet on a dashboard for another one. For most people, including myself, I imagine they would simply drag the new one next to the old one and then delete the old one. Barring any issues with container formatting, this is probably the quickest way of doing it. However, there is actually a button that exists for this, allowing you to instantly switch out one sheet for another with one quick click and hover.
Another example is with creating FIXED LODs. While most of us are familiar with the straightforward method of creating a calculated field, there are other, quicker alternatives. For example, you can automatically create one by holding Control and dragging a measure onto a dimension in the Data pane. It is these little things that can make the exam feel trickier than it needs to be.
Nevertheless, preparation for the exam also included spending real time in Tableau Prep too. Cleaning steps, joins versus unions versus blends, how a flow actually gets published. None of that is glamorous, but it's a real chunk of the exam, and it's a real chunk of the job too.
The Week Before: Study Sessions and Practice Exams
Once the exam date was actually on the calendar, my approach shifted. That familiarity from the months before was the foundation, but the week before was about drilling and making sure everything was fresh at the same time, not scattered across months of memory.
I built out a running list of topics to hit hard, roughly grouped the way the exam itself is structured:
- Connecting and shaping data. Live versus extract, when to use an incremental refresh versus a full one, the difference between a union, a join, a relationship, and a blend, and when each one is actually the right call instead of just the familiar one.
- Calculations. This ended up being the bulk of my review. Table calculations especially, since functions like `RANK()`, `INDEX()`, `FIRST()`, and `LAST()` all sound similar but answer completely different questions. LOD expressions were the other big one, getting FIXED, INCLUDE, and EXCLUDE straight in my head instead of half-remembering which one does what.
- Building content. Formatting details, dashboard actions, how filter actions and navigation objects are actually different things, dynamic zone visibility, the kind of stuff that's easy to gloss over because it feels like UI trivia until it's the exact thing a question is testing.
- Publishing and managing. Refresh schedules, alerts versus subscriptions, permissions, the server-side half of the job that's easy to under-study if you spend all your time in Desktop.
For each of those, I ran practice exams, and instead of just checking if I got a question right, I went back through everything I missed and turned it into notes. By the end of the week I had a running document that was basically my own condensed version of the whole exam blueprint, built entirely out of my own gaps instead of a generic study guide.
My Recommendation
If I'm being honest, the months of just poking around Tableau probably mattered more than the week of drilling did. The drilling made sure everything was sharp and recallable on exam day, but it only worked because there was already a real foundation underneath it.