Video |

Tableau | Data visualisation | Data prep

View Data Models in Worksheets : Tableau 2025.1 - 8 Language Audio Track

For the first time you can actually see what the data model is doing on a worksheet basis, and it's a small change that's genuinely huge.

Tim Ngwena •25 March 2025 •1 min read •4 min watch •2.8K

Part ofWhat's new in Tableau 2025.1

Watch on YouTube

Tableau 2025.1 adds a 'View Data Model' option under the Worksheet menu, showing the model relationships behind a specific sheet for the first time
The 'Hide unused tables' toggle strips the model down to only the tables driving the current view, making it easy to trace which relationships affect your numbers
When numbers are disputed, you can view raw data and then inspect the data model to check that relationships like editions and catalogues are resolving correctly
Tim favours relationships over joins and unions, arguing union work belongs upstream in a warehouse or in a better SQL query

0:00In Tableau 25.

0:011 you can now view the data model inside of your sheet.

0:04Now this is a very very small but really important huge update.

0:09Let me show you how this works then you'll understand why it's useful.

0:12I've connected up to the bookshop library's

0:15demo dataset.

0:15I'll put a link to this in the description.

0:17You can download it from Tableau's website.

0:19It's a good example of a data model that they have set up in advance.

0:23If I go and edit the data source you'll see the data model is quite complex relative to

0:28what you're typically used to inside a tableau and it has pretty much everything going on all the way from a uh physical table with a join in there and we've even got unions happening for sales files that are happening over

0:40Multiple years we've got Q1, 2, 3, and 4.

0:43So this is a very very uh busy data model.

0:46Now if I go back to the worksheet, I'm just going to do a very very simple chart.

0:51I'm going to bring in

0:52uh the titles from uh my books table so this just has the names of each book and what I want to do is find out how many libraries stock this particular book.

1:02If I'm a promoter I want to make sure that my book is available in the library so people can read it and get the word out.

1:07So I'll go ahead to the library profile and I'll just go ahead and bring library onto detail.

1:13Now when I put it here you get these dots here that kind of show you the number of libraries.

1:17Each of these is a distinct sort of library.

1:19If you hover over them, it tells you which one it is.

1:22But what I

1:22want is the count distinct of libraries so that I count the distinct number of libraries and then I can go ahead put that on text and there you go I have my very very basic chart I can then go sort this from greatest to smallest

1:34go to the bottom.

1:35Actually I can sort it from smallest to largest and then say okay look I'm gonna send these four libraries a free book so they just they stock my book and you know people start to read it.

1:43So it's a really basic analysis now

1:46Let's say you dispute this numbers.

1:47Let's say you get an email saying, hey, look, I think we actually have 10 books in this library.

1:52You might then start to wonder, well, what's going on here?

1:54And you'll maybe click on this little cell and you'll go and view the raw data.

1:58And then you'll get this view, which just gives you the number.

2:01And then if you go to the library profile table, you'll get something that looks like this.

2:05So you have the title and then you have all the individual libraries.

2:07Now

2:08The thing about this is that it's built in a slightly different way because you're using the data model.

2:13So how do you actually diagnose how that data model is driving this answer?

2:18In order to do that, you need this new feature.

2:20You can go ahead here to worksheet.

2:22and go down here to this new option that says view data model.

2:25When you click on that, you get this view.

2:27Now this view initially shows you the whole data model as a starter you can expand it

2:32You can move it around, it's a modal window, it's really nice.

2:35But here's a really nice thing.

2:36You can go ahead on the top right here and click this hide unused tables.

2:40And it gets rid of everything that's not being used in this sheet.

2:44So even though I drag the titles from my book table

2:47and I went and got the distinct libraries from my library profile.

2:51Tabo has used the additions and catalogs to real to create that relationship all the way through.

2:57So if I'm diagnosing any potential issue with numbers, I know I need to go and check and make sure that my relationships in the edition and catalogue all the way down to library profile.

3:06are all doing the right thing.

3:08Now this is a very small change but it's huge because for the first time you can actually see what the data model is doing on a worksheet basis.

3:16Before the only view you had was this view and you had to really abstract this understanding in your

3:21your head to kind of understand what was going on.

3:24I swear by the data model I think using joins and unions are you know a thing of the past.

3:29Unions make sense but really if you're doing unions you should really do that work upstream inside of a warehouse or write a better SQL query to bring it all.

3:36in relationships to me are fundamental part of Tableau.

3:40I'm going to be doing a series with Kirk Monroe.

3:42We're we're making something to really try and create the masterclass for the data model.

3:46But until then, I just love the updates that Tableau keeps pushing to the data model.

3:51I think you should check them out tea.

3:52Thanks for watching and I'll see you in the next one.

Rollup

Tableau 2025.1 lets you view the underlying data model directly from a worksheet, so when a number looks wrong you can trace exactly which relationships produced it without leaving the sheet.

Tim connects to a demo dataset with a deliberately complex data model (joins, unions across yearly sales files, and multiple relationships). He builds a simple count-distinct chart showing how many libraries stock each book, then uses it to show how the new feature helps diagnose disputed numbers.

The Breakdown

Start with a complex data model 0:23

Opening the data source editor shows how tangled a real model can get, with physical joins and unions layered on top of relationships. This complexity is exactly what makes diagnosing numbers on a worksheet hard without a dedicated view.
Build a simple count-distinct chart 0:47

Bring a dimension onto the view, add a related field on detail, then change it to count distinct to answer a question like 'how many libraries stock this book'. This ordinary chart is the thing you'll later need to diagnose if someone challenges the numbers.
Someone disputes the number 1:46

When a viewer questions a total, your first instinct is to click the cell and view the underlying raw data. That raw data view shows the numbers but not how the data model's relationships actually produced them.
Open View Data Model from the Worksheet menu 2:18

This is the new step: go to Worksheet > View Data Model to open a modal showing the model behind the current sheet. You can expand and move it around to inspect the full structure.
Hide unused tables to isolate what matters 2:40

Click 'hide unused tables' in the top right to strip the view down to only the tables actually feeding the current worksheet. This reveals hidden intermediate tables (like editions and catalogues) that Tableau used to resolve the relationship, even though you never dragged them into the view yourself.
Why this matters 3:06

Before this feature, you had to hold the entire data model in your head to reason about a worksheet's numbers; now you can see it directly, scoped to what's relevant, for the first time.
Relationships over joins and unions 3:22

Tim's personal preference: treat unions and joins as legacy patterns better handled upstream in a warehouse or via better SQL, and lean on relationships as the fundamental building block in Tableau.

Worth Knowing

The modal initially shows the entire data model, which can be as busy and hard to read as the data source editor until you toggle 'hide unused tables'.
The feature only shows the model as it applies to the current worksheet, not a general-purpose data model browser.

Use It When

Reach for this when a stakeholder disputes a number and you need to prove or debug which tables and relationships actually feed a specific worksheet, rather than guessing from the full data model.

How this Rollup was made provenance & method

A Rollup is drafted by AI from the video's transcript, then reviewed and edited by Tim. Everything used to produce this one is listed below — the model, the exact prompt, and the source video — so the process is transparent and reproducible.

Transcription: On-device — NVIDIA Parakeet v3 for recent videos, OpenAI Whisper large-v3 for earlier ones. The transcript never leaves the machine or gets published.
Drafting: Claude Sonnet 5 in the cloud, from that transcript.
Prompt: The exact Rollup prompt (v2) — the full system prompt, unedited.
Source video: Watch on YouTube
Drafted: 5 July 2026 at 09:38
Reviewed & edited: 5 July 2026 at 09:41 · by Tim Ngwena

Model + prompt + video is everything you'd need to recreate a Rollup like this yourself. The one thing we don't share is the transcript.

Rights. The video and its transcript are the property of TN Media Ltd. Unauthorised use or download is prohibited. © TN Media Ltd.