UK Healthcare Tableau User Group 12 May 2026
UK Healthcare TUG - Tableau Conference Feedback - May 2026
55 min 9,563 words transcribed
Summary
The UK Healthcare Tableau User Group's May meeting, a week after Tableau Conference 2026, recorded by the group on its own YouTube channel and republished here with credit. Co-leads Charlotte Shearsby and Steve Adams host (Rowan and Sara are away), open with UK and virtual user groups worth joining and the Tableau community on Slack, and trail a June careers panel. In "Tip, Tip, Hooray", Charlotte demonstrates favorite tips from the TC26 tip sessions on Superstore data: the Flerlage Twins' two fixes for the blue highlight on a clickable BAN (a transparent custom shape, or moving the number into a caption), setting a default currency format on several measures at once, replacing a data source in the physical layer rather than the logical layer (shown in a recorded clip from Kevin Flerlage), Jeff Shaffer's quick fixed LOD by Ctrl-dragging a measure onto a dimension, and Andy Kriebel's bar chart with no axis, double-click average lines, and the SIGN function to turn above-or-below-average into a two-color Boolean. Charlotte adds building a 1-to-100 parameter list from a range, scatter plot drop lines, four ways to sort, swapping rows and columns, clearing a sheet, grouping the data pane by folder, and right-dragging a date to pick its level, plus a personal habit of moving cards to widen the canvas. Steve closes with a tour of TC26 sessions worth watching on demand: Fraser Gallop on KPI cards, a guide to high-performance dashboards, Sean Miller's Workout Wednesday techniques, Maxime Baux on data scaffolding, Paul Moran on Tableau Server performance, dashboards at scale, SCIM user management on Tableau Server, the forward-looking composable data sources, Heinz Terenschuss on running an internal TUG, Fi Crocker and Sarah Burnett on data storytelling, and Blake Feiza on map layers, with a further eight for later. The meeting ends with a chat question and the monthly prize-wheel draw.
Key points
- Stop a BAN showing the blue selection box: change its mark to a transparent custom shape, or cut the number into the sheet's caption and show the caption on the dashboard.
- Ctrl-select several measures in the data pane and set Default Properties > Number Format once to format them all everywhere.
- To swap a data source for one with the same structure, replace it in the physical layer, not the logical layer, or everything turns red.
- Ctrl-drag a measure onto a dimension to have Tableau write a FIXED LOD for you.
- Put a measure on Size and set the mark to Bar for a bar chart with no axis; double-click Average Line in the Analytics pane to add one instantly.
- Wrap an above-or-below-average calculation in SIGN and make it discrete to get a clean two-color Boolean you can style.
- Create a long parameter list by entering a range with a step size, then switching the parameter to a list.
- Most TC26 sessions are free on demand on Salesforce+; search by the exact session title to find them.
Jump to a chapter (38)
- 0:00 Welcome, a week after TC26
- 1:30 User groups worth joining
- 3:14 The Tableau community on Slack
- 3:39 Next month: a careers panel
- 4:27 Charlotte Shearsby: Tip, Tip, Hooray
- 5:37 The TC26 tip sessions
- 7:20 BANs without the blue box: transparent shapes
- 9:09 Second fix: the number in a caption
- 11:54 Default number formats for several measures
- 12:43 Replacing a data source
- 13:40 Clip: Kevin Flerlage on the physical layer
- 15:44 Jeff Shaffer's quick LOD
- 16:28 Andy Kriebel: bar chart with no axis
- 17:06 Average lines and color by above or below
- 18:16 The SIGN function for a Boolean
- 19:30 Discrete colors, and moving cards around
- 20:48 A parameter list from a range
- 22:07 Scatter plot drop lines
- 22:56 Four ways to sort
- 24:17 Swap rows, clear a sheet, group by folder
- 26:06 Right-drag a date
- 26:53 Steve's tip: run a tips battle
- 28:39 Steve Adams: TC26 sessions worth watching
- 29:43 Fraser Gallop: KPI cards
- 31:25 Stop the Wait: high-performance dashboards
- 33:04 Sean Miller: from Workout Wednesday to the workplace
- 35:01 Maxime Baux: data scaffolding
- 36:50 Paul Moran: Tableau Server performance
- 37:33 Making dashboards that scale
- 38:58 SCIM user management on Tableau Server
- 40:15 Forward-looking: composable data sources
- 41:53 Heinz Terenschuss: an internal TUG that lasts
- 43:49 Fi Crocker and Sarah Burnett: Datafluencers
- 45:29 Blake Feiza: designing with map layers
- 46:58 Eight more sessions
- 50:32 A question from the chat
- 51:29 Prize wheel
- 53:56 Close
Transcript
0:00 Charlotte Shearsby: Everybody.
0:01 Welcome to our May TUG event.
0:05 Uh, we are just a week out of Tableau Conference, which was over in San Diego, uh, this year. Uh, it was Tuesday to Thursday, uh, last week. Lots of people, loads of people went from the Tableau community. Steve and I did not. Um, we stayed at home, but we watched it all on Salesforce Plus. Um, and there'll be a, a link where you can watch those. There was, uh, lots of live sessions, but being in San Diego, uh, did have a bit of a topsy-turvy week, uh, with watching, um, a lot of, of sessions in the evening.
0:38 Um, but, uh, there is a lot of sessions that were filmed, um, and that are now available on demand. So do, um, check those out. Um, your host today is me, Charlotte, um, and Steve, um, who is, uh, the other person that's on camera at the moment. Um, um, and we also have our, our co-host, our co-leaders, um, uh, Rowan and Sara, who can't be with us today.
1:05 Um,
1:07 we always kick off, uh, with some, uh, user groups that we think you'll love. So we've got our UK user groups here. So we have got the London Tableau User Group, which is by far one of the biggest and actually, um, one of the original ones. Uh, Atlanta and the, well, the UK TUG as it was known back then, uh, now rebranded as the London TUG, were the first two TUGs to ever get going.
1:30 Um, we've got the Scotland TUG, we've got the North East Tableau User Group, we've got the North West Tableau User Group, and if you wanna know more about that, hit Ella up because she's the leader of it. And we've got the Data+ Women, um, in London, and I think they've got a session next week if you want to get to that.
1:48 Virtual user groups that we think you'll love. Uh, we've got the Tableau Analytics User Group. Mass- I think it's the biggest user group. Uh, or is the Newbies the biggest user group, user group? Either way, two massive user groups, the analytics and the newbies. And just… The newbies isn't necessarily… It is for newbies, but there is always something that everyone can learn.
2:06 So a good one to go to, no matter your skill level.
2:11 There is the Accessibility Tableau User Group, which is great for understanding accessibility needs, and the, uh, relatively new AI and Tableau User Group, which is a very interesting user group exploring the use of AI.
2:26 Um, and if you want to join any of those user groups or just wanna have a peruse at what's on, you can do so via this QR code there. I'll leave it up for a moment. Uh, this will take you to the chapter pages, so you can see all of the different, um, uh, user group chapters that are around the world, both… They're all, some are virtual, hybrid, um, and in person, all there for you to choose from.
2:50 And then there is also, I think along the top, there's a little, um, menu item for upcoming events.
2:56 So you can also go and look at any events that are upcoming in your area or in your time zone if you're watching virtually.
3:03 So I do recommend, uh, joining other TUGs beside ours as well because you get to touch, uh, a range of, of knowledge and information from everybody.
3:14 Uh, there is the Tableau community on Slack. That's where we all hang out. That's where we all ask questions, share our ideas, and we see cool vizs and things. So if, uh, you are on Slack or if you can get access to Slack, I recommend scanning this QR code now to get your invite to the Tableau community on Slack.
3:33 Uh, oh, Chris, you put this in. This wasn't mine.
3:38 Steve Adams: No, I did. I did bung this in for you.
3:39 Charlotte Shearsby: Steve's put this in. So we've got our June TUG is all about careers. Now, we know that the NHS is undergoing quite a few changes career-wise for a lot of us, myself included. Um, we have got, um, a panel, um, of speakers, uh, still to be confirmed, but they are this close to being confirmed, um, um, that will come and speak to us about careers. Um, so you can…
4:05 We'll have a few questions, uh, led by myself, and then we will, um, head on to, uh, your questions, and then we can see what, what's what with careers and career advice for everybody.
4:18 TC roundup, but Steve says he's not going first. He says I'm going first. So-
4:23 Steve Adams: Yeah
4:24 Charlotte Shearsby: … here we are.
4:25 Steve Adams: And take your time, Charlotte. Take your time.
4:27 Charlotte Shearsby: I will try my best. Okay. So, um, I've called my session Tip, Tip, Hooray, um, and I hope that you will all be hooraying afterwards, um, when I've finished. Um, if you do want to catch up on any of the sessions that were filmed during TC last week, you can scan this QR code, and that will take you to Salesforce Plus, which will host all of the on-demand videos.
4:52 I don't think you need a separate login. If you've got a Tableau login, you just need that.
4:57 Um, so, uh, the tips that I'm sharing from, there were five tip sessions that were recorded this year. Uh, we got, um, double trouble with the Fur- Flerlage twins. Um, and not just that, uh, we got two sessions from them, so quadruple Flerlage maybe. Um, so they did a, uh, a quick, um, at-desk interview, um, where they gave us some, uh, some tips, and they did their larger how to do cool stuff in Tableau keynote.
5:28 We also had, uh, three other, uh, uh, tip type, uh, sessions. One, Risky Vizness.
5:37 Uh, the Tableau Tip Battle, which sees Tableau community members battle each other in a tournament style, uh, in a tournament. Yeah, just in a tournament. Um, to see who would be crowned the ultimate tipper of the, uh, conference. And we had Speed Tipping. Speed Tipping is a long-standing feature of Tableau Conference and, um, of DataFam Europe now as well.
6:05 Um, and this year saw the return of the GOATs, the greatest of all times, the original speed tippers, Jeff- Jeff Shaffer and Andy Kriebel.
6:16 I watched this session, and I counted 42 tips, I believe.
6:21 Um, so- Uh, it goes very fast. I, I watched it again and slowed it down and, and so, um, it's, yeah, really, really great session. But that is enough of those. We are… That was my last slide, yep.
6:38 Um, I'm gonna stop sharing that screen, and I'm going to start sharing the monitor in front of me to do my tips. Um, as I said, I am not in my comfort zone doing technical, um, technical demonstrations, so this is just…
6:55 I, I wanted to do this so that I could just push myself a little bit, so please do be kind. Um, I hope that you enjoy what I have to show you. So, um, hoping you can see my Tableau screen.
7:10 Attendee: Mm-hmm.
7:10 Charlotte Shearsby: So I've just got Tableau set up with, uh, Superstore data. So I'm not using any data other than Superstore data, which comes pre-built into your Tableau instance.
7:20 So BANs. We are… We love a, a big KPI number, a big aggregated number in the NHS, but we do not like, oh gosh, when you can click on them, and this horrible blue thing comes up. Because if we click, we think it does something, don't we? And this just doesn't do anything, um, other than make it blue. So how to fix it. The Flerlage Twins gave us two options to fix it.
7:45 The first is to change the mark type from automatic to shape. So w- we do it is we take our sum of sales… Um, no we don't.
7:55 We come up to the mark type here, and we change it to be a, a shape.
8:02 And we'll see this puts a circle on here, which is… You, you can still kind of click it. It's not really that great, but what we now have on the mark shelf is the shape icon. So we can go and select more shapes.
8:14 We come down here. I've got quite a lot of custom shapes, um, built in here, and transparent shapes will be a custom addition. But you can download transparent shapes from the Flerlage Twins if you just Google Flerlage Twins transparent shapes Tableau. Um, or you can create your own in PowerPoint and save them.
8:32 Um, and if you're at all… If anybody in the comments wants to know how to do that, um, just say, "Yes, please," and I will show you how to add shapes into your Tableau, um, repository, uh, at the end.
8:46 So yes, we've got our transparent shapes here, and there's obviously nothing there because they're all transparent. So we'll just click on one and go OK.
8:53 That shape disappears, as does all of the, uh…
8:59 There's nothing there that you can click now, so that is fantastic. No more blue square.
9:05 Um, so we've got this lovely thing here. Oh, that's just showing it's fixed.
9:09 Um, second fix is to pop it in a caption, which might sound a little bit odd, but that's what we're going to do anyway. So if I come back to my fixed one here, um, all I do is go to my, uh, label, go to text, and what I'm going to do here, I'm not gonna copy this, I'm going to cut it. So Control and, uh, X to cut it.
9:34 Apply and go away. So that takes it out of there, but you'll see that the sum of sales is still on the marks card, still on label, so I can still use it. And I'm gonna come up to worksheet. I'm going to cle- select show caption.
9:47 Double-click in there, highlight what's there, and replace it with what I've just cut from the label shelf. Click, uh, just center it up and, and whatnot. Click apply, and then it appears in our caption down at the bottom.
10:03 When we come onto our…
10:05 uh, put it onto a, um, a dashboard, um, it will usually come on with the title on already, which isn't, you know… We don't want that really. So all you've got to do is, if I take that off now, uh, bring that onto here. You can see where it is there. Not very nice.
10:25 Um,
10:28 am I using the right one? Yeah.
10:30 Think so. Uh, remove the title.
10:35 I don't think I'm using the right one.
10:38 Um, I've remembered what I didn't do.
10:41 So, uh, you gotta make the caption come on on the thingy. So, uh, bring the tile, so your ba- your second fix, onto the dashboard. Come to the little dropdown menu. Select to show the caption. Your BAN appears.
10:56 Turn off the title, and a little bit of resizing, and you've got your BAN, um, on your dashboard.
11:03 So there's two fixes for making the BAN, you know, not clickable with that horrible blue.
11:09 Um, you may have noticed that on my BANs, um, they're not, uh, formatted in any shape i, in any way. They've, uh, not got their pound sign in front of them or their dollar sign as this should be. Um, so how do I do that without having to go back and change all of these BANs that I've just created? But also, I've got a few other things on here that are also probably gonna be money.
11:31 So I've got the sales, I've got the profit, and I've got the discount that, um, all need to be, uh, formatted as, um, as, uh, as currency. So how to do that in one fell swoop for all three, um, is I'm going to select sales. I'm going to hold down the control key, and then I'm going to select profit also.
11:54 Um, and then it doesn't matter which one I click on. I click on the little downward arrow. We can go to default properties, and we can go to number format, um, and we can change it to, uh, currency, and we will change it to, uh, pop the dollar sign in front of there because Superstore is American.
12:12 Uh, can change it to, uh, no decimal places, et cetera. And now it's changed on all my sheets.
12:20 Um, it's, it's updated on all of the sheets that I've just made. Um, and profit is also… If I bring profit into here too, you'll see profit there has the dollar sign in front of it also. So that is how you can change your default properties by multi- multi-selecting- Um, uh, uh, items in your data pane.
12:43 Switching data sources now. I'm going to give you a sneak preview of what to expect from, um, uh, from, uh, the on-demand service, and I'm going to, uh, let Kevin explain how to do this.
12:57 So hoping that this works, got it queued up in the right place.
13:11 No, I knew it would do that. It's gone back to the beginning.
13:15 But luckily I noted down exactly when I wanted it to start.
13:27 Can you hear that sound coming through?
13:29 Steve Adams: I didn't hear any sound at the moment, Charlotte.
13:32 Charlotte Shearsby: Okay. Let me just-
13:32 Steve Adams: It's on pause at the moment
13:33 Charlotte Shearsby: …
13:34 stop sharing and make sure include sound. There we go. Okey-dokey.
13:40 Kevin Flerlage (TC26 clip): International DataFam, let's take a look.
13:42 Steve Adams: Yes.
13:43 Kevin Flerlage (TC26 clip): Okay, we have this dashboard here, and the goal here is we need to replace the data source with a new data source. Uh, it's in the same exact structure, same field name, same data types, uh, but we just need to update it with a new, uh, file. So let's go here. We see here in the logical layer we have this Superstore data with targets Excel spreadsheet.
14:04 We're gonna replace it with a different one, su- data… uh, excuse me, superstore_data_with_targets_2. Great name.
14:11 Let's double-click that. Now we have this selected, let's take this sheet and drag it over top of this in the logical layer and see what happens.
14:20 All right, and uh-oh, I see lots of red. Let's go back to the dashboard, see what it looks like.
14:27 Everything appears to be broken, and there's red literally everywhere, so that's not good.
14:36 Uh, let's back this up and try something different.
14:39 Um, all right, it's back to where it was. Instead of doing it in the logical layer, let's try double-clicking here to go to the physical layer, and then let's do this replace. We'll just drag that right on top.
14:51 Oh, things look good. Let's go to the dashboard.
14:56 Everything looks like it's good. We go to the sheet, nothing broken, no red. So the trick here is if you need to replace a data source, don't do it in the logical layer. Seems like it breaks every time, turns everything red. Go to the physical layer and make that replacement. Another great one. Thank you guys so much.
15:14 Charlotte Shearsby: Okay, so that tip, basically, why I really love that tip is, um, we were always swapping out data sources from when you move from maybe, um, dev to production and things like that, and then everything kind of just breaks and goes a bit bad. Um, but if you go into the, uh, data pane and swap your data sources out, not at a logical layer but at the physical layer, that really will help maintain everything in your dashboard.
15:39 Um, and it will just, uh, go more smoothly.
15:44 Um, this was a really cool tip, tip from Jeff Shaffer, how to create a quick LOD. Um, so LOD are the ones with the curly brackets, um, that scare some people, but you don't need to be scared anymore, um, because Jeff shows us how to create one with just a few clicks. So with your handy control key held down again, I'm going to select sales, and I'm going to pop that over, I don't know, category.
16:09 Uh, uh, go, and you'll see down here I've now got a, um, calculated field that says sales category. If I go to edit that, you'll see it's created that fixed LOD for me.
16:23 Um, so just a nice quick way to create a fixed LOD.
16:28 Bar chart, no axis. Uh, this was from Andy Kriebel. Um, if you don't want that pesky axis there, uh, let's, uh, fix that by… we'll take our sum of sales, um, and instead of putting it on the column shelf, I'm gonna move it to the size shelf. And yeah, that looks a bit crap. Um, so let's move that to bar, change the mark to bar, make this a little bit bigger, and there we have a bar chart with no axis.
16:56 And if, uh, of course, if you want to see the, uh, numbers, you can always turn the label on, and that will pop the numbers wherever you want them around the bar.
17:06 So that is a bar chart, no axis, axis. Uh, bar chart with an average line. So this has a few tips in it. So to create an average line, we come up into the analytics, and you can either drag your analytics to, uh, here, and there we've got a lovely axis line, or, uh, did you know you can just double click it and you've got, um, an average line? So that's nice and easy.
17:28 And if you decide, "Oh gosh, I really don't want that average line," uh, you could click there and remove it, or you can just pick it up and drag it off. So, uh, a few quick little average line tips there. Now, if we want to color encode this, uh, this, these bar charts based on our average line, we can do that. So I have one I prepared earlier.
17:52 Where have I done it? So, um, I've just got a really quick calculation, which is just taking the sum of sales minus the average, um, and we will pop that onto color, and you'll see it gives me this diverging color chart, which I don't really want. But yeah, blue is over the average, and the orange is below the average. But what if I want, um, just a, a nice simple little Boolean here?
18:16 Andy introduced us to the sign function. Um, now I'm not gonna go, I don't- not gonna pretend to understand the mathematics behind this.
18:25 Um, but if you wrap that, uh, that above or below average calc in sign, then you get a Boolean. So if we, um, take above or below… And here's another tip. Did you know that you can just, um, swap things out by just-… popping them over.
18:44 Um, so what all I did there, so if I wanted to do that again, I would have to take that off, put that on, take that off, put that on, or we can just, um, yeah, hover over, um, and that quickly changes. Um, and you can do it up here as well. If I didn't want the sub-category up here, if I wanted to change that to say, um, region, just pop that over there and it changes to region.
19:10 So yeah, there's just another little, uh, a little insight I don't know, another little bonus tip there, um, for you. Um, so now you'll see I've got this Boolean minus one, mi- uh, minus one and one. Um, and we can also just change that to be discrete. Um, at the moment, if we want to change this color, it's again doing this diverging color palette.
19:30 Um, but if we want a little bit more control over it, um, Andy simply says to change it to discrete, and then you have more color choice, um, color options to do that. Um, and I don't know about you, but um, here's another little, a little tip that's from me, actually. Um, I, I don't know anybody that does this but me. Um, but I, I hate, uh, the, the cards coming over here and the filter cards come over there too when you put a filter on.
19:57 Um, let's just all apply. Um, ugh, I really just… I don't know why it annoys me, but it annoys me that they are, um, always over here. Um, so I, I… You can, you can pick these up. You can pick anything up. You can pick these up and, and you can move them around. Um, so you can, like, customize it, and I prefer them there because then it makes my canvas, um, bigger.
20:21 Um, so yeah, I tend to stack everything over there, but you, you can do whatever you want. You can pop that there. You know? You, you can, you, you can move your page around and customize, um, how your page looks to your heart content, um, you know, you do you in there with your, with your workbook.
20:37 Um, was that everything? Yes, that was everything to do with average lines with a bit of divergence into, um, organizing your workspace.
20:48 Create a parameter list with a range. Now, let's see if I remember how to do this 'cause I didn't write… You'll see that it's not formatted at the top. This one went in, uh, last minute. Um, so, um, you might want to create a parameter that has maybe like a list of, like, one to 100, and you can pick one to 100 or whatever.
21:07 Um, and what you really don't wanna have to do is come here and type out one to 100 'cause that is, like, boring and going to take forever.
21:16 So, uh, let's… Whoops.
21:21 Let's remove those. Instead of creating a list, I'm gonna go and create a range and say the minimum was one, the maximum is 100.
21:28 Um, I'm gonna say okay, and then when I come back into this parameter
21:36 and edit it, I'm gonna change it to a list. Oh, and it's not done it.
21:42 Oh, step size. I need the step size in. I apologize. And there it's got, um, your list of easy one to 100. Um, so you can add them in as a range, um, and then change them to be, uh, a list.
21:59 And then when you go and show your parameter, and I'm gonna move it over here 'cause that's where I like it, I've got my list of one to 100.
22:07 Uh, scatter plot drop lines. Uh, so here I have a scatter plot.
22:11 Um, and what I'm going to do is right click on a point, come down to this drop lines, and say, say show drop lines.
22:21 Um, and you'll see it's made a drop line that goes across to profit and one down to sales, which is really nice.
22:27 Um, what I can also do is then add edit the drop line to add the labels and put that automatic labeling there. So I can now perhaps if I wanted to, uh, remove the headers, um, and that just maybe gives you a little bit of a nicer visualization whilst still maintaining, uh, the numerics for when you want them.
22:50 Um, so here's a bunch of tips to navigate Tableau workbooks.
22:56 So, um, sorting options. Let's go to sorting options first. So here I just have, you know, a, a simple sales by state, and there are numerous ways to sort this. You can sort on the numeric axis down here, um, by clicking the little button, um, and you can sort that way, or you can come up here, find it there as well, and sort up here as well.
23:18 Just put it back. Um, there is also sorting, um, up here on the taskbar, so lots of different ways to sort. You can also, the fourth way to sort is coming up to the state or province, clicking on here and going to sort, and this is where you can sort, um, a little bit more detailed because you can add in… You can sort it in data source order, uh, which by the looks of it is just alphabetical.
23:43 Uh, you can sort it… There you go, you've got another alphabetical order. You can sort it by field, so whatever field you have, um, you can sort it by. We can sort it by profit if we wish to. Um, so you can sort it by whatever field is in your data pane, uh, numeric field is in your, your data pane. So we can sort by, uh, anything. Even though it's showing sales on the view, we can sort it by profit, um, just by sorting by field.
24:06 Um, or we can manually sort it by just moving around, um, all of our, uh, uh, all of our, uh, names here.
24:17 So there are four different sort options. We can also swap rows. So I'm just gonna come back to this sheet for one. There's this button up here that really quickly just lets you swap from a, a bar to a column and back again, uh, depending on whatever you wish.
24:34 Um, did you know that you can also clear the worksheet? So if I… I'm like, "Ugh, God, this is awful," I can come up here, and instead of dragging all these things off, I can just reset the worksheet by clicking clear worksheet, and then it is all cleared and sorted- Um, we had a good tip from Jeff, um, which was, uh, if you don't like how this is sorted in data source, um, so we've got the people, the returns, the orders.
25:01 These are, are three different data sources that are put together. If you don't like that, you can click on this little drop-down arrow, uh, just here, and we can… You see it's grouped by data source table. We can group by folder, and this is more of a sort of a classic view, um, that you, you might remember if, uh, you go back with your Tableau play far enough.
25:23 Uh, this is sort of how it used to look.
25:25 Um, and you, you can obviously switch back again, um, to have it however, however you want it.
25:31 Um, oh, um, a really good one that I like using, um, this one's from Andy Kriebel. We've got order date here. Um, so I can drag order date onto columns, and you see it always, always will default to the highest… It'll always default to the year. Um, and then if I wanted to go down, I could scroll out through the hierarchy, or I could, um, come in here and then pick, um, pick whichever, um, I wanted here.
26:01 So say I wanted to go with the months, I could. I've- I've got them just there.
26:06 Um, or you can right-click with your mouse.
26:12 Right-click on, on order date, hold your right click down as you drag it up to columns or rows, and now you get a whole bunch of options about what you want to do. So let's, uh, just, you know, pick here.
26:28 Um, and so yeah, that's just a, a little quick way to get, uh, your date up there exactly how you want it. And that is all I have, Steve. I'm sorry I did that really quickly.
26:43 Steve Adams: Not at all. I, I enjoyed that. I'm, I'm gonna add one very small tip at the very end. Um, if you enjoyed that, throw something in the chat and let us know.
26:53 Thank you very much. My, my additional very small tip simplistically is we all love tips, right? We love… Every time you see tips, you learn something and you remember something you've forgotten all about. So my small tip simplistically is if you are having a meeting with other Tableau devs, why not kick it off or finish it up with a small tips battle or just small tips run in the first place?
27:16 Because you do… I mean, you showed some stuff there which I was, I was slapping myself in the forehead with. Not physically, obviously, but, um, you, you, you just forget what's, what's available, don't you?
27:27 So it's really good to-
27:28 Charlotte Shearsby: Yeah
27:28 Steve Adams: … see something new.
27:28 Charlotte Shearsby: And, and I think, you know, there's a range of tips, um, on all of these tip sessions that are… Some are super simple, sort of basic beginner stuff that you're like, "I didn't know you could do that." Because there's just…
27:42 There's probably, you know, three or four ways to do everything in Tableau. Um, so it's just, you know, you, you start off and you're like, "Huh, didn't know you could do it that way." And it's just, yeah.
27:54 Uh, Paul says-
27:54 Steve Adams: Exactly, yeah
27:55 Charlotte Shearsby: … he likes the bang, bang thing.
27:57 Um, cool.
27:59 What do you say?
28:01 Steve Adams: Good.
28:04 Charlotte Shearsby: Cool. Um, so yeah.
28:04 Steve Adams: And in fact, I, I say that exact phrase in my training sessions. I always say, "Look, there's, there's at least three ways to do the same thing in Tableau." Which is why it's so frustrating when you can't find one of them.
28:18 Charlotte Shearsby: Um, yeah.
28:19 Steve Adams: I'm only joking.
28:20 Charlotte Shearsby: Hope you enjoyed those. Uh, do go and watch more on demand. Um, not just the tip sessions. There were some brilliant sessions, um, that we can all enjoy and share.
28:32 Steve Adams: Yeah. Shall I, um, finish off-
28:36 Charlotte Shearsby: Yes
28:36 Steve Adams: … with my-
28:36 Charlotte Shearsby: You can do your news from the conference.
28:39 Steve Adams: I will do my, uh, update from the conference indeed. So the whole screen.
28:45 Um, where is it?
28:52 This is gonna be a little bit dry, so I'll run through this quite quickly, uh, on the basis that you will receive this…
29:02 Oh, that's not what I meant to do.
29:04 Just press that one there.
29:05 Charlotte Shearsby: I see.
29:06 Steve Adams: And you're seeing my screen. You can see my screen, yeah?
29:09 Charlotte Shearsby: Yes, I can. Thank you.
29:10 Steve Adams: Okay. So we will send you these slides, which means, um, you can use this as a reference. But simplistically, as Charlotte said earlier on, I think there's over 150, um, talks and presentations which will be on demand.
29:25 So all I'm gonna do is run through some featured sessions with a little bit of a breakdown so that you will know whether or not it's worth your time actually looking and watching those sessions. I'm not sure how long they all are. Most of them are pretty much 20 minutes, but some of the key ones were longer than that.
29:43 Um, so one of my, um, recommendations, or our recommendations even though I run through most of this, so, like, blame me if there's anything you don't like, um, was from Fraser Gallop. Um, Fraser runs his own, um, public consultancy over in the US, I believe. Um, I've always enjoyed his speeches. This one was about KPI cards, so key performance indicators.
30:06 Um, simplistically we, uh, we use them probably not enough in my opinion. Um, it's important to have that stacking of a number field as well as a trend.
30:19 Um, what he does in this particular presentation is looks at some tips to present key performance indicators.
30:26 One of them I really like the concept of, and that's the second bullet point there, which is that when we color things about things being under or below all, all the time, it basically means everything's got a color. And that… All, all of a sudden what you're doing is you're detracting from what really matters.
30:42 Okay. So, um, his suggestion is that you take a, a percentage, um, limiter. In his case he's suggesting 5%. So if you're outside of 5% of a goal, um, then you're… Then you, you wanna show an alarm, whether it's a good or a positive alarm, but you don't… Not really having any false alarms going off.
31:02 Um, and he, uh, presented, uh, 18 KPIs in a six by three grid looking at various different key performance indicators. Um, and his overall view was that you're, you're getting from this presentation a complete KPI dashboard framework that any desktop user can build today. So that's quite a useful session if you're into key performance indicators, or rather if you're not into them, you might discover why you should be.
31:25 This session, um, was all about performance. Stop the wait, a guide to high performance. And just for anybody that does want to watch any of these, the title at the very top here is the exact title, um, of the video on demand. So you can use that in the search button. Um, Charlotte gave you the QR code earlier on. I'll show you the link later on as well.
31:45 Uh, so if you go to there, you can go onto the on demand or the all sessions. You can type into the search, and you can find any of these.
31:52 Um, this particular presentation, if you've got slow performance, um, if you followed all of these tips, all of these tips basically, uh, helped one of their users, their customers of Tableau, um, improve their server performance stats by forty-five percent. That's a hell of a lot if you think about it. Um, most of the complaints we get is the fact that when you've got a really good dashboard, it takes too long to load.
32:16 Um, performance is not the single toggle you can just flip. You need to go through all these different things. But if you've got a slow performing dashboard, people are gonna remember that bit more than all the insights they should be getting from the dashboard. So it really is quite important.
32:30 Um, they went through bottlenecks in order. So they worked with design, calculations themselves, the queries under the hood, data and the whole environment. Um, some of the hot tips I just pulled out of there is that marks matter more than the sheet count. So fifty thousand marks on a dashboard is much more of a problem than, for example, having fifty sheets on a dashboard.
32:52 They also ran through some of the inbuilt, uh, checks you can do, such as running the optimizer, et cetera, et cetera. So as I said, I mean, if performance has been a bit of an issue for you, then that's definitely a must-see for you.
33:04 Um, and then I pulled out one from Sean Miller. Now, Sean Miller goes by the name of HipsterVizNinja. If you're into h-um, hashtags, uh, you will find him. He is, um,
33:17 a Tableau principal consultant. He has also been contributing to the Workout Wednesday, uh, program for quite a long time. So what he's done, I think it's nine years he's been doing that.
33:30 Um, so he pulled out his top five learnings from doing, uh, Workout Wednesday over the last nine years. That already is a bit of a hot win. I've summarized them here, but of course, you're not gonna really understand the real tip until you actually watch it live. But for example, he's put– picked out how you can use Window Max to, um, identify something above or below, so the end neighbor.
33:53 So for example, if you want to pick out something, um, that you want to analyze, let's say it's a treatment or something like that, and you want to know what the length of stay is by those different treatments, you can zone in on that particular one treatment, and then you can look at the f- plus or minus five that rank above or below that. So you're actually zo-zooming into a particular section.
34:12 Um, he also talks about saving styled empty layout containers as template workbooks to be able to reuse them to save time building dashboards.
34:20 Um, he talks about using one Boolean parameter control in order to actually configure all of the, uh, dynamic zones on a dashboard. You can switch between what you're showing and what you're not showing just with one parameter rather than playing with lots of different things. And, and a hot tip at the end was just to remember that a parameter doesn't belong to a dashboard.
34:43 It doesn't belong to a worksheet or a data source. It actually just lives outside all of that. So that allows you to use parameters for some really useful global controls and parameterization in terms of what you can see, what you can't see, and what the impacts are, uh, across multiple dashboards, across multiple datasets.
35:01 So that's a pretty good session from Sean. Um, and then if you like listening to French accents, you're gonna love listening to Maxime Baux, um, always massively energetic.
35:14 Um, this particular session, he dived into the concept of scaffolding. Scaffolding tends to scare people. We talk about data scaffolding, concept in terms of what you want to use it for and why you might use it, but then how do you do that? So Maxime went from the very basics. In this case, he's actually using a simple union, unioning three different, um, pieces together to get a scaffold table, and allowing you to do some pretty cool stuff.
35:40 So for example, and I used this technique myself quite recently, building a bridge chart or a waterfall chart. Um, you can build a waterfall quite easily, but what you can't do very simply is have the beginning, the middle, and the end, um, parts of that bridge easily embedded within the same visualization. And you have to build it across multiple worksheets, which gets really quite messy.
36:02 But using a scaffolding approach allows you to do exactly what you want to do. So you can bridge between, for example, last year, uh, scenario, uh, your planned scenario, and your actual result scenario. We can actually see each of those different pieces and the– how we bridge between those two. So that's a really useful session.
36:21 Um, and his overall concept, and you may have heard it before from the Flerlage twins, is that Tableau is just about your X and your Y. So it's really just about using and painting your data, uh, but understanding how you just move your X and your Y coordinates around to get exactly what you want.
36:39 Um, so in this particular presentation, he ran through bridge charts, but also Sankey's and radial layouts as well.
36:50 Um, one for the admins. This was quite an interesting one. I don't know how many admins we've gotten here. Um, but this, uh, was from Paul Moran, who's, um, from Tableau. He's based over in Dublin.
37:03 Dedicated, uh, setups in terms of increasing your load speed, looking at various node runs, making sure you got your VizQL service set up properly, and thinking about Tableau as not being, uh, just a set it and forget it tool, which is, I think, one of the concepts that some organizations do wor- uh, do, do leave it as. They set it up at the beginning, and then they walk away from it.
37:23 Actually, it needs constant tuning, but also constant improvement in terms of understanding how people are really using it as well. So I thought that was really quite a useful session for the Tableau admins.
37:33 Um, this one is from, uh, some Salesforce employees, Jimmy Bowen, Jack Heffernan, and Nicole Saleh. It's about making dashboards at scale, design performance as well as people. Um, so there's a few interesting tips, uh, hard-won enterprise lessons directly applicable to only… to any Ser- Tableau Server team as well.
37:54 Um, um, but also from a design perspective. So for example, just simplistically, one color should mean one thing everywhere, not just on a single chart or on a dashboard even, but a- across multiple dashboards within a pad. So if red's gonna mean below target, then let's make it only mean red equals low target across all those objects. Why? Because otherwise your user just gets really confused and have to keep thinking and looking at legends and understanding what's going on elsewhere.
38:21 So there's a lot of useful tips in that session.
38:26 Charlotte's already stolen some of the best bits from this one, I believe. Um, uh, I didn't realize she was going to, so I put this in here as well. Ten tips for better vizzes. Uh, so-
38:35 Charlotte Shearsby: I don't think I did those ones. That's fine.
38:37 Steve Adams: Oh, you didn't do those ones, but you did actually look at… Okay, so this is definitely a cool one. Um, rounded bars, dual axis super marks, spot line, and obviously using, uh, some table calculations. Some of my favorite o- ones are the helper calculations, such as the last one, for example, here. Um, so some cool little tips in there as well.
38:58 Um, this one was secure and scalable, mastering user management with Tableau. Um, so this is from a Salesforce employee, um, Lokesh Tripathi.
39:08 Um, just introducing the fact that SCIM is now live on Tableau Server. So that allows you to fully integrate any user management system that you have outside of Tableau and inside of Tableau. What that means in practice is, if somebody comes in, uh, to your organization and they're assigned a particular role, they will automatically or could automatically get updated in terms of what they can access on the server.
39:32 And likewise, if they leave the organization or they leave that part of the organization, that will also dynamically update as well. It mentions that you need an on-prem agent required. Don't worry, that's not AI. That's just like a little piece of code that needs to run in order to actually sync the two tools together. I thought that might be useful, again, for some server admins.
39:51 But more importantly, even if you're not a server admin, knowing that that exists might help you have a decent conversation with your server admins, because it is one of the big headaches in our organizations.
40:03 Um, bit of a red flag. We talked about what we should be discussing here, uh, before doing this session, and, and most of it we've showed you is already available to you.
40:15 This is a forward-looking piece of information, but it is absolutely critical that you understand that this is coming, because this can change your world in terms of being a dashboard designer as well as being a Tableau administrator, and that is the concept of composable data sources.
40:37 Uh, not compostable, apparently. It's composable. Um, and what that simply means is that when you're creating a new data source, you can reference a data source which has already been published on the server as being one of the source systems.
40:55 So what that really means is we don't need blends anymore, and what it really means is that we should be able to reduce significant numbers of unused extracts or minimally used extracts. And overall, we should be able to, um, stop rebuilding stuff and s- and start reusing data sources rather than have to build them up from scratch ourselves. It's an incredibly complex piece, which is why it's taken so long to come, because it's been requested for many, many years now.
41:22 Um, but it will be available on Server and Cloud, uh, this year. Um, I believe it will be available in the next release on Tableau Server.
41:34 You can't take advantage of it right now. However, this is one of those things that you might wanna start thinking about how you plan how that might impact your infrastructure, because there can be a lot of changes, a lot of rebuilding, which will improve performance, but also, uh, improve accessibility as well for access to the right data.
41:53 Um, here's an interesting one you might wanna think about. Here we are at the, uh, Tableau user group. Heinz Terenschuss, I hope I pronounced that properly, he's a BI director at Kaplan, talks you through how you could set up your own Tableau user group internally.
42:07 Um, and there are some real benefits of being able to do that. So he talked about the three legs being speakers, the members, and the leadership team as well. All three of those are required in order to keep a user group healthy.
42:21 Um, one of the things he did, which is quite interesting, was he just, uh, templated a, uh, a reach-out email or connection request. So every day he would do a quick, um, doom scroll of LinkedIn, for example, or whatever social media platform you prefer, find some vizzes that he liked which were pertinent to his organization, and he just connected with the author and just said, "By the way, would you like to present at our Tableau user group?" So he was introducing external people in as well as actually getting internal people.
42:52 So that was quite a, an easy win because he was looking through that location anyway, um, and just inviting externals in.
43:01 Um, his advice is always, if you're gonna have a Tableau user group, Charlotte, we should always have a backup session ready. Um, which I had you, so that was perfect for me.
43:10 Um, and From an internal discussion perspective, phrase this as employee engagement, because that's what's gonna help you earn your executive support.
43:21 Um, and it's exactly the same as, I think, attending other events as well.
43:25 Uh, the more… And big headline was the more technical he went, the less people stayed, or less people got interested. So that was an interesting concept.
43:35 Um, we as Tableau developers, we like a little bit techy, but not everybody in the room is looking for that. So, uh, he gives you a playbook that you can rip and replace and put into your organization, which is quite cool.
43:49 Um, if you don't know these ladies, you should. Fiona Crocker and Sarah Burnett, they run a, uh, practice down under. Uh, I think they cross between Australia and New Zealand. They call it DubDubData. They do a podcast as well actually, which you can, uh, have a look at for free anytime, where they interview quite interesting people from the community.
44:10 But their pr- presentation was about the story arc, and talking you through how you can involve people in your organization in that story arc.
44:19 And before you jump into it, a story arc isn't necessarily something you put in a dashboard, but it is certainly the way that you put it in, the way you present that dashboard to other people in your organization. You can try and build it in if you want to as well, but the, the whole point of a story arc is you start from the hook, getting people interested, you then walk them through the problem, you find the insight in your data, you present the solution and the result that you can get from that, and also pass on any learning, and any specific calls to action that people need to make in order to actually employ and, and learn from that process.
44:52 And one of the examples they had was just a simple reframing of one of their clients from, "How did we do?" To a, "Well, what becomes waste?" Helped them save an additional 672,000 apparently. I think it says pounds. I'm not too sure what the, uh, unit of measure was. Uh, it's pretty something, yes.
45:10 Um, so that's a, a useful section to go through if you're looking at design ideas, but also engaging people in your organization around data, hence the title about data culture, and turning people into datafluencers within your organization.
45:29 Um, Blake Feiza. I don't know if I've got that right. So probably Feiza, Feiza. Data viz engineer at Apple. Um, some design ideas, and, uh, this time it's around using map layers. And I'm not sure if you're aware, I'm sure you probably are, but map layers aren't just about maps.
45:46 There's lots of ways we can trick the use of, uh, using map layers to build much more specific visualizations. So Blake went through a lot of processes there. Um, he talks about, obviously you need to turn off the map, 'cause you don't really wanna see the map, but you can build s- s- um, specialist advanced chart types using map layers.
46:06 And one of the concepts is to use something which is called Null Island, and Null Island basically is zero, zero from a latitude, longitude point around the world. Um, that's your starting point, and you can then start building from zero, zero, and increase latitude and longitude in different, uh, ways in order to place things exactly where you want.
46:25 And he shows you an examples of doing things like doughnut charts.
46:29 Uh, proper doughnut charts, which don't have, um, horrible things when you hover over them, getting in the wrong, in the way, for example. Also heat maps. He talked about, um, having distribution heat maps where, for example, you might want to actually know what the, uh, heat map is, but also the distribution on the horizontal and then also on the vertical columns.
46:48 Combining that all into one sheet again as well. So lots of really funky stuff going on.
46:53 And talking about the fact that your only limit, the only limit is your imagination.
46:58 So those were 12 sessions, which I would strongly recommend you having a look at the summary on, and diving into. I've also added another eight just for fun as well. I'm not gonna go through these in much detail, because you will get the slide download anyway. But we've got, um, speed tipping. Obviously, Charlotte did a fantastic job. There might be some other ones in there, uh, that are interesting to you.
47:22 Charlotte Shearsby: Yeah.
47:22 Steve Adams: What was that, Charlotte?
47:23 Charlotte Shearsby: There was loads.
47:25 Steve Adams: It was quite a long session I think, wasn't it, that one?
47:29 Charlotte Shearsby: Yeah, it was about 40 minutes.
47:31 Steve Adams: Um, we've also then got Rafael Guevara. Usage data has your back, designing dashboards for impact. I thought that was quite good. Like Rafael Guevara a lot as well. And I mentioned, um, composable data sources. Uh, this is actually another presentation from the brilliant Kirk and Candy.
47:50 Um, another one of those marriages made in Tableau.
47:53 Um, and Kirk especially does a lot of, uh, posting and investigation around how to get the best out of composable data sources. Um, so that's a very useful session for when that comes available to us.
48:09 And then there's a brilliant piece from Jessica Bautista Gona. So this is very much aimed at people who use Tableau Public, but also are interested in understanding viz extensions. So viz- all of their viz extensions are available to use in Tableau Public completely for free. So that's a great way to sample it, get some ideas, um, how you might be able to use viz extensions to display and en- engage with data more efficiently.
48:35 Or perhaps just to build things more efficiently, 'cause you're gonna build that anyway. So, um, that's a really useful session from, um, Jessica.
48:44 Tableau Security and Admin, if you like a bit of that. You've also got some more stuff coming from Sri and Jun as well.
48:51 Um, and Ojo was talking about navigating the Tableau ecosystem.
48:58 That does cover Tableau Next and CRM, so if you're not using those, probably not worth your while having a look at. But I thought I'd throw that in for a bit of fun. Um, and Klaus Schulte lastly, uh, my fellow presenter a couple of years ago actually, TC23. Um, he's now working with apps for Tableau. So again, there's a whole bunch of extensibility which doesn't depend upon your Tableau Server, um, version.
49:21 You can bring in Tableau apps easily, uh, without updating your server. And he addresses, especially for finance people, some of the, uh, ways you can very quickly show what finance people need to do around P&L, demonstr- uh, visualizations, workflows, um, et cetera, et cetera. So again, very useful and short session to look at.
49:43 Oh, I didn't realize there was another one. I missed this one. This is Sheets Happen. Be careful how you say that.
49:49 Um, this was from Taksina and Will. Uh, looking primarily bit of cloud focus because it's looking at Google Sheets integration as well.
49:58 Um, and there's a lot of extensibility coming, not just around Google, but also with Microsoft Office products as well. We saw that in the keynotes. Uh, but that's not available yet. Um, but this session is, uh, is using stuff which is already available if you've got access to it, and that was it.
50:16 As I mentioned, watch them all for free at Salesforce. Uh, there's the URL. You have the QR code from, um, Charlotte as well earlier on. Uh, but as I said, for the sessions I've recommended just, uh, copy and paste the titles and put them in the search bar, and you're in.
50:32 Charlotte Shearsby: Right. Thanks, Steve. Um, Paul asks, "Any work done on dynamic HTML for the URL links feature?"
50:41 Steve Adams: Um, sorry, that's gone straight over my head. Um, any work done on dynamic HTML for the URL links feature? Not that I saw, um, Paul. Give me some more details in the chat, and I'm more than happy to do a bit of research and find out if I can find something on that for you.
50:58 Charlotte Shearsby: There's also the, um… Oh, what do they call it?
51:01 Where we put our ideas in for Tableau to take away what we want.
51:07 Uh, what's, what do they call it?
51:09 You know, we put our-
51:10 Steve Adams: Tab-
51:10 Charlotte Shearsby: … like dev ideas on.
51:12 Steve Adams: Yeah. That used to be the ideas something or other, but it, it moved over to Salesforce anyway.
51:16 Charlotte Shearsby: It's changed something now, hasn't it? Yeah.
51:18 Steve Adams: Yeah.
51:19 On Trailblazer
51:19 Charlotte Shearsby: Yeah.
51:20 Steve Adams: We-
51:20 Charlotte Shearsby: There might be an update on there.
51:24 Um, okay. So-
51:25 Steve Adams: Yeah, Paul, if you could wr- put some more details in the chat, and I'll, uh, definitely make a note of it.
51:29 Charlotte Shearsby: So while Paul is doing that, I will do our, our, uh, prize wheel spin. We do it every month. Three lucky winners will receive some Tableau swag from me, but not just yet because they are changing the, um, the Tableau store, um, over at Tableau. So, um, can't actually buy any at the moment, but you are all going on a list, and you will get some, uh, as soon as I have some to send out.
51:55 And I know that there are some people from the last one that are still waiting, but I assure you, your names are kept and precious, as are your addresses. You will get some nice Tableau prizes sent out to you as soon as I have some. So, um, let's have a look. Oh, I don't know why I've got an extra space there, but never mind. Let's go spin the wheel.
52:20 Darren. Darren wins some swag.
52:26 Darren Randall: Oh, I won last month. You should spin again, Charlotte.
52:29 Charlotte Shearsby: Okey-dokey. If you're sure. Darren didn't get his last month either.
52:34 Jacqueline.
52:35 Steve Adams: I didn't do.
52:36 Charlotte Shearsby: No, because I don't have any.
52:42 Uh, Jacqueline, congratulations.
52:46 Um, our next winner is Lisa.
52:56 Um, one more 'cause Darren has forfeited his spot.
53:05 Looks like that will be Caroline.
53:08 Yes.
53:11 Caroline O'Donnell.
53:13 If you want to, um… I'm just gonna pop some details in the chat. If you want to send me over your postal addresses, um, to my email address. Um, and as soon as I have swag in stock, I shall send some over to you. Um, so congratulations, Jacqueline, Lisa, and Caroline.
53:33 Oh, all ladies winning. Whoop-whoop.
53:38 Steve Adams: Whoop-whoop.
53:38 Charlotte Shearsby: Okay. Um, so I think, uh…
53:44 Yeah. A- anything more to say on Paul's comment?
53:47 Steve Adams: Not at the moment. What I'll do, Paul, though, is I'll look into that, and I'll include some details in a follow-up email for everybody. Okay?
53:56 Charlotte Shearsby: Super. Um, I think we've actually… We didn't think that we would… We've, we've actually come to time. It's, it's… We've finished on time. Whoo. Um-
54:05 Steve Adams: We have. We've finished a, well, a little bit over time actually. Makes a change.
54:09 Charlotte Shearsby: Yes. So, um, thank you everyone for joining us. Um, I've seen as I've got my, um, panelists firmed up for our June TUG. You will hear all about it.
54:19 Um, and yeah. Hope you enjoyed, uh, our feedback from the conference. Do go and watch some sessions, um, on Salesforce+, but if you can't, um, I know that a lot of user groups, um, quickly snap up speakers from Tableau Conference to present at their user groups. So do make sure that you check out those user groups. Um, yeah. That's it. Thank you, everybody.
54:48 Steve Adams: Great. Thanks very much, Charlotte. Thank you, everybody.
54:50 Charlotte Shearsby: Bye, everyone.
54:51 Steve Adams: See you next time.