Skip to content

Summary

The Higher Education Tableau User Group's October 2026 meeting, recorded by the group on its own YouTube channel and republished here with credit. Co-leads Virginia Moench, Roshni Gohil, Sam Homier and James Emery host. Roshni announces Tableau's From Data to Decisions higher ed showcase on 28 October. In a State of the Union for Tableau in higher education, Gabriel Bregon, who leads Tableau's higher education team, and solution engineer Dan Bradley answer the co-leads' questions: about 2,300 higher ed contracts and 228,000 Tableau user licences, Tableau Cloud carrying nearly five times as many as Server, how data management and advanced management are counted, why Server still has more Creators, about thirty campuses on Tableau+ bundles, Salesforce use around recruitment, advancement and student success, renewed investment in Server, MCP servers and AI, how far behind most Server installs run, the Standard, Premier and Signature success plans, and e-learning and other resources. Sam then announces Tableau Prep School Confidential, a 2027 training series on Tableau Prep with education data, and the co-leads share Prep speed tips: Ginny shows detail view for numeric fields such as student IDs, Roshni speeds up slow database inputs by staging them as Hyper extracts, James saves reusable cleaning steps as a flow, and Sam uses an aggregate step to keep only the columns needed and remove duplicates. Russ Cantrell, director of data administration and strategic initiatives at the University of South Alabama's Whiddon College of Medicine and a five-time Tableau Ambassador, gives his TC26 encore, Making Curriculum Data Make Sense: a standard course spreadsheet template with drop-downs, course and year parsed from file names, a Tableau Prep flow over about 350 spreadsheets that cleans delimiters and maps MedBiquitous codes to the college's own approved methods, nulls renamed so missing data reads as missing, and dashboards for curriculum mapping, course review, objectives, assessment and a print view for the accreditation report. The meeting closes with the HEDW call for proposals, the November meeting and upcoming user groups.

Key points

  • Higher ed runs about 2,300 Tableau contracts and 228,000 user licences, with Tableau Cloud carrying nearly five times as many licences as Server.
  • Most Server installs run about a major version behind, often because admin teams wait for maintenance releases or freeze changes during the academic year.
  • Every customer has Standard Success; Premier comes with the Plus bundles, Signature is purchased, and the higher ed team's webinars, user groups and roadmap sessions are open to all.
  • In Tableau Prep, switch a numeric field such as student ID from summary to detail view to list every value without changing its type.
  • Staging slow database tables as Hyper extracts in their own small flows can make the main Prep flow load in seconds.
  • Save repeated cleaning steps from a flow and insert them into other flows instead of rebuilding them.
  • An aggregate step early in a flow keeps only the columns you need and removes duplicates, and it is easy to add fields back later.
  • A familiar template with drop-downs gets faculty to submit consistent curriculum data without changing how they work.
  • Replace nulls with plain words such as 'No data submitted', so people read a gap as missing data rather than an error in the tool.
  • Watch how people actually use a dashboard; the course review team needed a year-over-year view of one course, not the whole curriculum.

Jump to a chapter (31)

  1. 0:00 Welcome and agenda
  2. 1:00 Announcements and the From Data to Decisions showcase
  3. 3:30 State of the Union: meet Gabriel Bregon and Dan Bradley
  4. 5:46 Tableau in higher ed by the numbers
  5. 10:16 Bringing Tableau into Salesforce
  6. 12:24 Cloud versus Server and Tableau+
  7. 14:58 What's new and coming: AI, MCP and the data foundation
  8. 20:21 Which Server versions campuses run
  9. 23:17 Success plans and support
  10. 26:55 E-learning and other resources
  11. 30:03 Announcing Tableau Prep School Confidential
  12. 32:12 Tip or Trick or Treat: Tableau Prep speed tips
  13. 32:15 Ginny: detail view for numeric fields
  14. 33:33 Roshni: stage slow inputs as Hyper extracts
  15. 35:59 James: reuse saved steps across flows
  16. 38:25 Sam: keep columns and remove duplicates with an aggregate step
  17. 40:31 Introducing Russ Cantrell
  18. 41:26 Russ Cantrell: Making Curriculum Data Make Sense
  19. 44:24 The problem: scattered, siloed curriculum data
  20. 46:19 The plan: a familiar template
  21. 50:04 Cleaning up in Tableau Prep
  22. 53:37 Delimiters and MedBiquitous codes
  23. 56:21 Renaming nulls so missing data reads as missing
  24. 58:02 Dashboards: the whole curriculum on one page
  25. 58:54 Watching the dashboard in use
  26. 1:03:59 A print view for the accreditation report
  27. 1:06:44 Results and a team of one
  28. 1:09:17 Limitations and next steps
  29. 1:12:00 Discussion
  30. 1:13:03 HEDW call for proposals and the November meeting
  31. 1:17:11 Upcoming user groups and close

Transcript

0:04 Virginia Moench: Hello everyone, and welcome to the October twenty twenty-six Higher Education Tableau User Group meeting. We are super happy to have you with us today. We have a fabulous agenda, and we're gonna get right into it.

0:17 So we're going to start with our welcome and announcements, followed by our Meet the Tableau in Higher Education State of the Union address by, uh, Gabriel Bregon and, unfortunately, Umberto could not be here today, and then Dan Bradley. So we're gonna have that, followed by Tip or Trick or Treat, your favorite October special.

0:38 Um, we're going to be sharing Tableau Prep speed tips today. That would be the HETUG co-leads. And then Russ Cantrell is finally going to present his TC twenty twenty-six encore, Making Curriculum Data Make Sense. I've been dying to see this. And then we'll have our wrap up and chat. So before we get into it, does anyone wanna come off mute, make an announcement?

1:01 If you don't wanna come off mute, you can put it in the chat.

1:06 No announcements.

1:08 I do have one announcement I'd like to share. I'm gonna put a link in the chat. We've got an open position in my office, so if anybody wants to come work with me, um, it's not a really Tableau-heavy role.

1:22 It's really more about, uh, federal reporting and, uh, banner and our data mart and kind of making sure all of that data is accurate and validated.

1:34 Um, but it is also open to a hybrid or remote, you know, situation. So if you have any questions, feel free to reach out.

1:46 Let me know. We also have, um, a second job posting in my office for an assessment person. Where do I work? I work at Appalachian State University. Um, and so if you're into assessment, that's really not a very Tableau-centric job, but yeah, two job openings in my office. Yay.

2:07 All right.

2:08 Roshni Gohil: Well, I have an announcement.

2:09 Virginia Moench: Good deals. Yeah. Good for you, Roshni.

2:12 Roshni Gohil: So the, the Higher Ed Tableau team is offering a webinar, um, from data to decisions in two weeks, just about two weeks, October twenty-eighth. Um, it's gonna showcase a bunch of dashboards from around higher ed, as well as some, uh, Tableau ambassadors and partners are gonna be there to answer questions and sort of talk about some of these dashboards.

2:32 Um, so we're about to put the link, uh, to the invite in the chat, um, but you can also grab the QR code, uh, as well.

2:43 There you go. And the link is now in the chat. Um, but you can see there's a whole lot of different, uh, areas. There's campus use. There's, um, IR, like, operations in there. Uh, there's a lot around students leaving out, stopping out, um, where the industry is going in terms of STEM fields, uh, shrinking, growing. So there's a whole lot of… And alumni engagement.

3:07 So there's a whole lot in there. It's not just one area of higher ed. Um, so I'm excited to see what some of these dashboards look like.

3:15 And excellent, Russ just RSVP'd. I, I mean, North Alabama's there, so South Alabama's gotta, gotta attend to support, right? Uh, all right. And then I'm gonna pass this along, pass this back to Ginny.

3:31 Virginia Moench: And I'm really just gonna pass it on to Dan and Gabriel. So, um, welcome, Dan, Gabriel. Uh, thanks for joining us from Tableau today to give us a State of the Union address for higher education.

3:42 Um, I'm gonna let the two of you introduce yourselves before we get into the questions.

3:48 Gabriel Bregon: Yeah, that sounds great. Thank you, team, and, and happy to be here. Ginny, I have to say, you have the perfect radio voice.

3:55 That I cannot match nor will I attempt to.

3:58 Virginia Moench: Well, thank you.

4:00 I'm, I'm not the only one.

4:03 Gabriel Bregon: On, uh, here on this, on this chat, I'm sure not. Uh, but no-… I do wanna say thank you for the time. You know, the team asked Dan and myself to join, and they had a number of questions to get further insight into how Tableau is used throughout higher education. I know it's easy for all of us in our roles to feel like we're one of a few, when in reality you're one of many.

4:23 And, uh, we did wanna open up the data truly to show you how many people there are within higher education that are using Tableau, the different versions, and as, as much as we can possibly share. So we're excited to go through that with you.

4:36 And by way of introduction, for those who do not know me, uh, I oversee hi- the higher education analytics team here at Tableau/Salesforce, and I've been with us for about six years.

4:47 And Dan, if you wanna introduce yourself, that'd be great.

4:49 Dan Bradley: Yep. Um, absolutely. And, um, extend a thank you as well to everyone for the, the invitation and, and chance to be here. Um, I'm part of the solution engineering team of, of Tableau Salesforce.

5:03 Uh, so I partner with and work closely with Gabe and his, uh, team of account, account executives. I've been with Tableau, uh, about eight and a half years now, and been focused in the higher education space during that time. So, uh, you may have seen me before on a call. Uh, I've, uh… Nice to see you all again, and, uh, nice to meet many of you who I haven't had a chance to talk to before.

5:27 Virginia Moench: Awesome. So, um, I think, Gabriel, were you gonna share your screen?

5:33 Gabriel Bregon: Yes. Happy to.

5:34 Virginia Moench: Fantastic.

5:36 And you can maybe just start off by telling us a little bit about who is using what in the Tableau world, in, in the higher ed Tableau world.

5:46 Gabriel Bregon: All right. Can everyone see my screen? Some thumbs up.

5:48 Virginia Moench: Yeah.

5:49 Gabriel Bregon: Cool.

5:50 All right. So this is very high level, but hopefully this is insightful nonetheless. And feel free to ask any questions in the chat if you want me to delve into anywhere specifically.

5:59 Virginia Moench: Sure. I will, uh, watch the chat for questions that come up.

6:02 Gabriel Bregon: Thank you, Ginny. All right, so here is the overview. So I'm sure this is new for a lot of you, but as I was saying, you are one of many.

6:10 We've about twenty-three hundred contracts. Now, what does that mean?

6:14 It's… You know, I was asked how many customers or how many institutions are using Tableau. That is harder for us to quantify, as some institutions have fifty contracts, um, and some m- many less. So, uh, that is currently the number of contracts we have across higher education. But really the number that you all would find probably interesting is the number of users, and that is just role-based users.

6:41 So that's when we think of creators, explorers, and viewers.

6:44 That does not actually count all the folks that are on 8-core server licenses. So we have about two hundred and fifty-two 8-cores across higher education, and about five four cores. We actually don't support… sell those anymore, but, you know, hey, the data was there, so we decided to throw it in there.

7:00 Some other parts that, uh, I think Ginny and, and Roshni thought would be valuable were how many folks actually have data management, and that's around nine thousand on Tableau Cloud and around eight thousand on Tableau Server.

7:14 Uh, again, that number is also different based on the 8-cores, 'cause a number of those also do have data management and advanced management.

7:22 Any other questions specific to this outside of, you know, Slack and CRMA that's also here in Tableau Next?

7:29 Roshni Gohil: Can I ask a quick question about that data management count?

7:32 Gabriel Bregon: Yeah.

7:32 Roshni Gohil: Is that… So is that a user license count or is that the number of sites that have it? Can you… Like, what, what does that eight thousand nine hundred and forty-five… Like, what is the denominator? If I wanted to, to take one of those, those BANs at the top and, like, put that as, as a denominator, which nominator is the right denominator to use there?

7:51 Gabriel Bregon: Great question. So data management can be used, it's derived across each of these: creator, explorer, viewer.

7:58 So they're saying of the a hundred and eighty-eight thousand, nine thousand have data management.

8:04 Roshni Gohil: Wow. That's a much smaller number than I expected.

8:08 Gabriel Bregon: And that again is just for Cloud.

8:11 Here. And then Server is eight thousand relative to forty thousand, and most of them are gonna be on those 8-cores.

8:19 Roshni Gohil: Cool. Thank you.

8:20 Gabriel Bregon: Yeah.

8:21 Virginia Moench: In the Slack we had a couple questions. Um, Evan, I'm not really sure what you mean by your question, but advanced management, is that a different type of data management?

8:34 Gabriel Bregon: That is another add-on. Um-

8:35 Virginia Moench: Oh, okay

8:36 Gabriel Bregon: … I do have that data. I actually did not pull it in here, but let me take a look. Good question.

8:42 So advanced management on Server, there's about two thousand users, again excluding any 8-cores. And on the Cloud there are around nine hundred twenty-four.

8:57 Virginia Moench: Um, another question is: Why are there so many more creator licenses for Tableau Server?

9:02 Gabriel Bregon: Oh, good question. So, um, more…

9:06 Just some background, right? I mean, higher education has been an early adopter of Tableau.

9:11 And so more times than not, you're gonna see a lot more, at least initially, we had a lot more Server licenses, and frankly, a lot more of those 8-cores. So you're gonna see a lot less, um, you're gonna see, at least in the short term, a lot more on the creator side for on-prem, as that's a lot, that's allocated a lot to these 8-cores.

9:32 And we are continuously moving folks to Tableau Cloud.

9:36 M- m- when did we create Tableau Cloud? 2014, right, Dan? Something around there?

9:41 Dan Bradley: Somewhere around there. And then, you know, kind of accelerated in, uh, the, the late twenty-tens to, you know, be more, but much more, I think, enterprise, enterprise grade.

9:53 Gabriel Bregon: So that's why you'll see that difference. Uh, a lot of these folks are moving over to the left side. Some people are very happy on Server as well, and that's okay.

10:02 A lot of good innovations coming to the Server side.

10:05 Virginia Moench: Another question is: Does this include the free student licenses?

10:09 Gabriel Bregon: Good question. It does not. That would be a whole different-

10:12 Virginia Moench: Yeah

10:12 Gabriel Bregon: … data

10:16 to.

10:16 Virginia Moench: All right.

10:18 Well, then, I guess we'll move on to our next big question for you. How much is higher ed bringing Tableau into Salesforce?

10:26 Gabriel Bregon: So, um, there's multiple layers to that question.

10:30 Virginia Moench: Yes. Feel free to dive into whichever layers you'd like.

10:34 Gabriel Bregon: And you… So are you… Do you mean embedding Tableau into Salesforce, or using our Tableau Next licenses?

10:43 Roshni Gohil: So initially the question was around, like, lightning web components and use-

10:47 Virginia Moench: Mm-hmm

10:47 Roshni Gohil: … of Tableau built dashboards in there as opposed to using the built-in, um, CRM analytics tool.

10:54 Gabriel Bregon: Got it.

10:55 Roshni Gohil: But we want to hear the Tableau Next.

10:57 Virginia Moench: Hm.

10:58 Gabriel Bregon: As well. S- good question. Dan may have more anecdotal stories around that, but we don't have the data to back that. Dan, is there any comments you'd want to mention?

11:08 Dan Bradley: Yeah, I think, you know, again, not having specific numbers to attach to it, but what I typically see is more, more use cases around recruitment and admissions, advancement, student success.

11:25 Um, so those divisions and departments. And, um, you know, embedding either, you know, the long way before the lightning web, um, component was, was available, um, embedding some of the Tableau dashboards inside of where those various divisions typically operate within, within CRM.

11:44 Um, and, uh, and also, you know, as, as we've started to venture more into Tableau Next and, you know, CRMA is also part of that mix, having a more native way to embed some of the visualizations for those use cases is naturally where we're, we're continuing to see the, the most growth and development. So, um, not that it isn't used in other places, but it, it tends to be A, I, I think most conversations center around those three areas.

12:16 Virginia Moench: That really does make sense.

12:18 Gabriel Bregon: Yeah. Any other questions on that? And I think I can click over to the next slide. There may be some more information here that's helpful.

12:25 Virginia Moench: Yeah, I do think there was a piece, if I look into the sub-questions, is asking about the split of Server versus Cloud.

12:35 Gabriel Bregon: Mm-hmm.

12:36 Virginia Moench: And that, I think, might be what you're about to elaborate on.

12:42 Gabriel Bregon: Delve into a bit more. Sure.

12:44 So Cloud, and again, this is for…

12:47 It depends how you, you look at the data, right? But right now, Cloud leads about six in ten higher ed Tableau customers run Cloud only.

12:55 Um, now accounts with active Tableau, oh, I guess we do have those numbers. Around sixteen hundred and forty are four-year institutions, two hundred and forty are community college, five hundred and ten K-12, and then three seventy other.

13:09 Um, we do not track or split the public versus private.

13:14 Uh, what else do we have?

13:15 Dan Bradley: And I can add a little bit other context around that as well. Um, as I think many of you have probably experienced on your campus, sometimes the very grassroots or organic way that the Tableau has come up, come up about at institutions is there may actually be initially multiple Tableau Server deployments. Um, and then at some point there's typically kind of a, a movement where central IT may consolidate them, um, all into one or, you know, one of the particular departments takes, takes ownership of that from a central perspective.

13:50 But we're seeing something similar happening, um, with Tableau Cloud as well in terms of there may be a central IT presence for Tableau Server, um, but, uh, maybe athletics has a specific use case that they want to spin up a Tableau Cloud site for. So there may be instances where there, there's that hybrid approach, um, not necessarily all driven under a central IT type of policy, but rather just to fit the, the needs and use cases of, of multiple departments around an institution.

14:21 Gabriel Bregon: Yeah. I'd even add more times than not, where we see those eight-core servers are when it's centralized behind IT.

14:28 Virginia Moench: I'm surprised only thirty campuses have Tableau Plus bundles.

14:33 Maybe it's coming later.

14:34 Gabriel Bregon: Well, think about it, it's a very new SKU.

14:36 Virginia Moench: Mm-hmm. Mm-hmm.

14:37 Gabriel Bregon: Uh, as of… Has it even been a year? Time is moving so fast.

14:42 Virginia Moench: It really is.

14:43 Gabriel Bregon: Um, but yes, thirty campuses hold Tableau Plus as of right now, and most of them are very large.

14:50 Virginia Moench: Mm-hmm.

14:51 Gabriel Bregon: Made that move.

14:53 Virginia Moench: It would be interesting to check back in a year and see how that's changed.

14:57 Gabriel Bregon: Agreed.

14:58 Virginia Moench: The next question, I think, is about what is new and/or upcoming in Tableau features that are going to change how higher ed uses Tableau?

15:09 Gabriel Bregon: Let's see. Do I have that in here? I think I do.

15:13 Dan Bradley: So maybe this one.

15:14 Virginia Moench: I think, yeah, this is under number three, roadmap.

15:18 Gabriel Bregon: So ask the question again for me, Ginny.

15:20 Virginia Moench: Oh, just, you know, what's new and upcoming that's gonna change the way higher ed uses Tableau?

15:27 Gabriel Bregon: There's so much there. Um- And I think right now we're in a big meet institutions where they are kind of phase. You know, we're bringing a lot of our development to Server, whereas in the past, I think since Salesforce has, you know, acquired Tableau, a lot of our focus has been on Cloud, and a lot of folks on this call, I'm sure, feel Server has been left behind.

15:52 That has changed, you know, not dramatically, but I think frankly for the better, and we're gonna continue to see that innovation speed up.

16:01 So, you know, when we think about agentic, I mean, God, if I could have a dollar for every time I hear AI or agentic. But th-

16:09 Virginia Moench: Mm-hmm.

16:10 Gabriel Bregon: But that is where, um, we're trying to find reduced friction for institutions.

16:18 Um, and the biggest opportunity for everyone is focusing on the data foundation, and I think we're trying to get deeper within that stack because it doesn't matter how great the visualization is if the data is not sound and, um, not accurate and well-defined. So that right now has been a big focus of ours, uh, and how do we do that at scale, and how do we then surface that information in a headless way, right?

16:43 So whether you're working in Slack or you're working in Teams or you're working in Salesforce or you're working in Claude or Gemini or what have you, how can I benefit from all of the data that we've entrusted and put and built on bad data models within Tableau, but leverage that across a myriad of different platforms?

17:03 Dan, anything to add?

17:04 Dan Bradley: Yeah, I think I'd, I'd add just some detail under those, those broad points. Um, you know, we, we see a wide range of interests and awareness and proficiency to adapt some of the more AI forward capabilities and features inside of, of the Tableau stack.

17:29 Um, everything from we absolutely don't want anything to do with it, we want to continue, you know, to maintain Tableau as have an AI free space, to we really wanna know what is, is ahead and help, help us to understand the, the specifics of how, you know, we can start integrating our, our various agents or, or LLM technologies with our existing Tableau footprint.

17:59 So a lot of that interest and maybe discussion and focus that we're seeing right now centers around MCP, um, servers.

18:11 So that applies to both Tableau Cloud… installs as well as the Tableau Server installs.

18:18 Um, you know, and there, there are some differences in terms of whether it's self-hosted or Tableau-hosted for those MCP servers. But that is a way that we're seeing, I think, some of, some of the institutions that are really leaning into, um, how we can we leverage our existing Tableau assets for agents start to, to, um, experiment with.

18:43 Um, so I, I would say that, that that's an area that I imagine we'll continue to see growth and, and change in for higher ed in, uh, the coming six to twelve months.

18:55 Um, somewhat related to that is this trend that has popped up at least kind of more front and center for me recently around vibe coding dashboards, right? And, um, we saw that if anyone watched any of the, the Dreamforce, the Salesforce big conference, Dreamforce announcements, um, a lot of, of, uh, fanfare was made around Cloudforce and being able to create dashboards inside of Cloudforce using, using natural language.

19:25 Um, you know, it's pretty, it's, it's pretty interesting technology, and I think that it's opening up folks' eyes to looking at Tableau as a bigger stack and solution than just a visualization layer. So we're seeing things like, um, extra effort and emphasis being put into Tableau knowledge, um, for more, more semantics and, um, ontology between the different data sources.

19:54 So, um, a lot of, you know, decades worth of, in some cases, investment in data and, uh, and analytics has been placed into Tableau centers at, at institutions all over. Um, so it's, it's a really, I think, fast-changing place right now in, in terms of how various institutions are approaching how they want to, to use that going forward. Sorry, that was a long-winded answer.

20:21 Virginia Moench: It's all right.

20:24 Roshni did put a question in the chat asking if you could go back a couple slides and talk about, um, what server versions folks are on.

20:33 Dan Bradley: Mm.

20:34 Roshni Gohil: 'Cause that's always been the sort of-

20:36 Virginia Moench: Yeah.

20:36 Roshni Gohil: Yeah, it's one, one of those challenges. If you're, if you're on cloud, great, you're getting all these new features. But if you're on server and, you know, the idea is meet people where they are, like some of these new features aren't gonna be available to them. So what… How many folks are on older versions of Server and, and how does that impact their ability to get some of these new features or, or, yeah, their just, their, their, the availability of those, those features?

21:01 Gabriel Bregon: That's a good question.

21:02 So as you can imagine, given that on-prem would mean it's on your servers and not ours, we wouldn't have visibility into that data as to which version they're typically on.

21:15 Um, again, only anecdotal from that perspective, and I think it, it varies. Some institutions run, you know, where they're almost a year behind the specific version. Other ones are right on it. Um, and then many are laggards, where they maybe get a little bit less active upgrades from that perspective.

21:39 Um, so that kind of feeds into the features that are then available based on the version that you are inherently on, with the newest features feeding into the newest versions. So, um, I don't know if that's a… That's kind of a non-answer to your answer, Roshni, but it, it certainly depends.

21:59 Dan Bradley: And I can anecdotally give my take on that. You know, we do, um, server health checks with some regularity, uh, around, you know, ba- basically anywhere that, that there might be a server instance. So, you know, we've done, we've done several hundred of, of these over the last few years. Um, most of the server instances I would say it's, it's about a version, a major version behind to maybe two, you know, two minor releases behind.

22:28 Um, Gabe has on the slide a couple of those reasons, right? Sometimes it's an admin team. Sometimes it's related to just changes in, in technology, you know, freezing at, at different points in the year. Um, a lot of it as well I find is just, um, server admin teams may be cautious about upgrading to the latest and greatest new, new version, um, until a couple of maintenance releases have, have kind of gone out and, uh, and fixed some of the, the, the bigger bugs.

22:57 So I, I tend to fi- find that that's, um, a pretty common practice as well for, um, for server teams to wait, wait a few versions before they upgrade to the next major release.

23:11 Roshni Gohil: Thanks. That's helpful.

23:12 Gabriel Bregon: Did that answer your question as much as we could?

23:15 Roshni Gohil: It did.

23:16 Gabriel Bregon: Hmm.

23:17 Virginia Moench: So moving on, uh, we've got two questions left. What support and services does Tableau Higher Ed team provide to Tableau users in higher ed?

23:28 Gabriel Bregon: So good question. Um, there are a number of different levels of success here at Tableau, and I'm sure most of you have been longtime users of Tableau, and hopefully s- there's a bunch of you that are, that are newer as well.

23:45 But, uh, to level set, you know, I'm sure a lot of you are used to just CSMs that were a part of your, your team based on, you know, you being an enterprise customer or not or whatever the case may be. That was, you know, the old Tableau before Salesforce, and since then we've been matching how Salesforce does a lot of their success plans.

24:04 So most of our customers are on standard success. That is where you put in a ticket, and you're in a long, potentially long queue, and you have the same access to success as anyone else. Much more self-service, but all customers get that off the bat.

24:20 Uh, Premier Success, now that's included in some of our SKUs already, whether it be Cloud Plus or Server Plus or Tableau Plus, et cetera.

24:29 Or you can purchase that separately. But you do get expedited support. There are some enablement features inside of that with expert coaching that a lot of our customers find valuable.

24:41 And then the last tranche would be Signature Success.

24:44 Now, that does have a cus- a designated customer success manager.

24:48 That does have proactive monitoring. That is someone who's, you know, part of your team, understands your infrastructure, uh, is meeting with that server team to help them understand, hey, this is what the next release has, this is how we should potentially, um, upgrade to that, best ways to architect certain things, et cetera.

25:07 It is, it is their way to feed and reach back into Salesforce to get experts to speak to the customer.

25:15 Uh, now that is something that is purchased separately, uh, as well, and a lot of customers actually do end up going that route once it is central to the institution.

25:27 Um, and the last two, I think, would be the Higher Ed team. So whether that's us, Dan, myself, and the, the, the other members of our team, whether that's through webinars or user groups, as with this one. We have a number of partners that create exchange accelerators. We do roadmap sessions, et cetera.

25:45 Uh, that's available to everyone, and then partners and professional services. So if you're thinking, "Hey, I need a s- a specific pain point," or, "I'm hoping to help implement or migrate or do some training, but I want maybe in-class or whatever that is," that is something that can be contracted separately as well. So there's really ways to m- to meet folks where they are, um, on top of Trailhead and everything else that Salesforce has built.

26:11 Virginia Moench: Roshni put a question in the chat as well: How can we, as Tableau users, work with our pur- procurement or IT or whoever to learn about what level of success that we have, and what questions should we be asking?

26:25 Gabriel Bregon: Good question. I think I have this one.

26:30 Um, so these are some questions that you could ask to your purchasing or IT team, is what success plan are we on, Standard, Premier, or Signature, and who is allowed to open support cases? That would probably be the fastest way to get that answer.

26:44 Uh, you could also ask your account executive or, or SE. We're happy to answer those questions as well, for that one specifically.

26:53 And same thing with e-learning seats.

26:55 Virginia Moench: Fantastic. All right. So in closing, um, this is kind of a two-part question, so I'll just do one and then the other.

27:02 Are creators on Cloud taking advantage of e-learning, and how can they access that content that's included in the cr- uh, the Cloud Creator license?

27:12 Gabriel Bregon: Yes. Uh, many are. Uh, so the ones that have e-learning, most times than not, I wanna say it's in the portal, and they are accessing it through…

27:23 Dan, correct me if I'm wrong, but I'm pretty sure that's how they access the, the key to be able to access the, the e-learning.

27:29 I'm seeing you head nod.

27:31 Dan Bradley: Yeah. I, I, I believe so. Some-someone on the call may be able to confirm if that-

27:34 Gabriel Bregon: Yeah

27:35 Dan Bradley: … is the case. Yeah.

27:36 Gabriel Bregon: But yes, that is heavily leveraged, the, um, the e-learning, and so are the expert coaching for those who have, um, Premier Success and the, um, and Signature Success.

27:49 That is a very heavily used plan.

27:53 Virginia Moench: That's good, 'cause it's an excellent, um, resource.

27:56 And then the last question is: What other resources are Higher Ed users taking advantage of, like Trailhead, Trailhead Academy, Tableau Conference, boot camps, et cetera?

28:09 Gabriel Bregon: I think you really hit them. Um, Trailhead Academy, instructor-led certification, TC, boot camps, academic programs. We have a lot of, um…

28:20 I mean, we support a number of different conferences as well, so whether you go to EDUCAUSE or, um, we're gonna be at CARE this year. Not in… We're, like, uh, you know, we'll be around, uh, so if you happen to be at the, the CARE conference. I was at AIR this year. So I think it, it'll just depend on where we are and the best way to support us. But frankly, if you're able to reach out to your account executive or your, your sales team, we're happy to work with you and your institution on better ways that we can partner with you, uh, even if that's not from a, a paid perspective, right?

28:50 Just from an enablement, "Hey, can you guys come and do a Tableau day?" Uh, we are happy to, to work with you on what's the best way to partner with your institution.

28:59 Virginia Moench: It's always fun bumping into you guys at a conference that's not the Tableau Conference.

29:04 Gabriel Bregon: Yeah. We're around.

29:06 Virginia Moench: Yeah. All right. Are there, is there anything else that you wanted to add before we make our next big an- announcement?

29:14 Gabriel Bregon: Um, you know, I think the, the biggest thing for me is I can recognize that things are moving really fast.

29:25 And whether it be inside Salesforce or even outside Salesforce, there's just a lot coming at all of us, and I want, hopefully, everyone on this call to understand that you're not alone in that. And if you need a resource, if you need any help, even if you have a question, uh, and that for whatever reason Claude can't answer, you have a team here, Dan, myself, and a very robust Higher Education team that's happy to support you, uh, just to pique through knowledge or answer any questions.

29:52 And I think that's, like, the biggest takeaway, 'cause there's a lot that we change often, um, and a lot that can benefit you all, and it doesn't necessarily always have to be in a paid, paid way.

30:03 Virginia Moench: Thank you so much. So I know you're as excited as I am about this next big announcement. I'm gonna turn it over to Sam to do the honors.

30:13 Sam Homier: Thank you, Ginny, and thank you Dan and Gabriel. That was very, very helpful.

30:17 Yes, our next announcement, uh, we, the education TUG leaders and the Tableau Higher Education team, are very excited to announce a new training initiative that is kicking off in 2027, and we're calling it Tableau Prep School Confidential.

30:32 So the idea is that we're gonna teach you Tableau Prep fundamentals using education data From connecting your first data source, to pesky pivots, to aggravating aggregate aggregations, and to complex calcs.

30:45 So our goal is to help you earn your license to build in Tableau Prep Builder.

30:51 So what does this mean for you? Well, do you love Tableau Prep? Do you have some tips and tricks up your sleeve that you wanna share with the higher ed community?

31:00 If the answer is yes, then please go to the HETUG presenter interest form. Thank you, Roshni, she's put it in the chat. And let us know.

31:10 If you're not ready to teach, well, we want to know what you want to learn. So what burning Tableau questions do you have, what's haunting your nightmares and your prep flows, and what's driving you absolutely batty?

31:23 Tell us in the chat, or post in the, uh, Tableau Prep Data Management channel that's in the higher ed Tableau Slack.

31:31 Or, after the meeting, we will have a Tableau Prep School confidential breakout room that you can join and chat with us about this.

31:39 We are extremely excited about this initiative, and we can't wait to bring education data and Tableau Prep training together in this amazing partnership that we have with the Tableau team.

31:50 So, yeah, thank you. And, and I hope you guys are all as excited about this as we are.

31:55 And it's not scary, David, it's just a Halloween-themed announcement.

32:00 The next thing that we wanted to go over is, um, the other TUG leads and I have some tips and tricks that we all want to show you in Tableau Prep. So I think starting us off is Ginny.

32:16 Virginia Moench: All right.

32:17 So my, um, Tableau Prep speed tip is, is a really simple one, but I, I was so happy when I discovered it, because it's something that really, it's very pesky for me. So you have this numeric field in Tableau Prep, and it go… It, it bins everything for you. You can't see all the individual values, and I… This is a problem with, um, student ID for me a lot.

32:46 And I used to think you had to go in and change it from a number to a string in order to see all the different values, but, um, that is not actually the case.

33:00 I don't know how I figured this out or discovered it, but quite by accident I realized if you click on the dot dot dot, and you change it from a summary du- to a detail, it will stay a number, but it will list out all the individual values for you in Tableau Prep, and that has been a game changer for me. And then you can toggle it back and forth just by changing it back to summary if you wanna see it binned into the different, um, values again.

33:27 So that is my Tableau Prep speed tip of the month.

33:34 Sam Homier: And then next I think is Roshni.

33:39 Roshni Gohil: Oh, look, who, who are you gonna pick next? All right. So, um, I forgot to show this slide earlier, but, like, isn't it cool? Ginny made all these little-

33:46 Virginia Moench: It's so cute

33:47 Roshni Gohil: … emojis for us. And I'm the single head that has been replaced by a dinosaur.

33:52 So we have all-

33:53 Virginia Moench: Because you're always a floating head.

33:55 Roshni Gohil: I am. It, it's so, so perfect. All right.

33:58 Virginia Moench: Mm-hmm.

33:58 Roshni Gohil: So who has been stuck in that spot where you're just waiting and waiting and waiting for your tables to load, whether it's a simple joi- join like this, or it's something very complex. You're just seeing this whole retrieving data thing just showing up. Five minutes later, you're still retrieving data. I'm like, dude, the d- data is not that big. It is not that hard to retrieve, right?

34:18 So there's a tri- a trick that I learned. Um, I think I learned it in either an HETUG meeting in the higher ed Tableau Slack, or maybe at some other TUG meeting, but I'm pretty sure it was from someone in education. May have been a David, it may have been a Rob. I'm not really sure who. But this tr- ti- tip is my favorite. Um, so instead of having all of your, your data sources in that, that prep file that does all of the work, um, one thing that can help make things faster is to create separate flows to just get the data from your database.

34:55 So you have a two-step flow. Here on, on the left you have academic terms as my table, and all I'm doing is taking that input and then outputting it directly to hyper.

35:04 Do the same thing with my other table, in this case course catalog.

35:08 Those individual hyper flows take seconds. You see that eight seconds and change, less than a second for the, the academic terms table.

35:16 Those things take very little time to cha- to, to load, and then I made a video.

35:23 And then all you do is you connect to those hyper files, replace your original database tables, and look at that. The data, it loaded in seconds. Not minutes, not hours, just seconds.

35:36 Why does, was that work? I don't really know, but I hear that it has something to do with the way that hyper files are just optimized for use in Tableau Prep and Tableau Desktop. So even if you're not doing any actual changes to the data, just simply using a hyper file as your input will make, um, the, the whole thing work a lot faster.

35:55 So that's me. I'm gonna pass it to-

35:59 Sam Homier: James

35:59 Roshni Gohil: I don't know. Sam? Oh, oh, all right.

36:02 Sam Homier: I'm going in order. We made a list.

36:04 Roshni Gohil: All right. All right.

36:07 James Emery: If there are parts that you do frequently, so s- there's, there's steps or either certain transformations or just the, the cleanup, you're just constantly doing the same thing over and over again. And so y- sometimes you may forget and have to go back, but you don't have to always do this. What you can do is you can kind of group it. You don't have to group, but I do suggest grouping because it does make it cleaner, and you can actually start adding in, uh, documentation when you bring it over.

36:32 So you can kind of group the, the s- the transformations or the steps you do all the time- Then you can right click on it and say…

36:42 Well, I may have to do it when it's op- large again.

36:46 Yeah.

36:47 I don't know. Okay, so there should be, and I don't know why it's not showing at the time, there should be a step saying, kinda export this as a, uh, uh, pretty much say that, export it out as a steps.

37:02 I'll g- I'll go back on this to figure out exactly why it's not showing that. But how you would use it is, you have the, your new data here.

37:10 Actually, let me go back because I do wanna show one, one thing that kind, will kind of help.

37:16 Is, you do want… It would help to have a step where it says, "Hey, pretty much this is where you're gonna attach your, your data." So when, when you open it up, you're not kind of going, "Well, what am I supposed to do with it?" So now if we go over to the, to here, if you go up to, to edit, go to insert a flow, and then you can browse, and you, you can publish it.

37:37 So that step that I wasn't able to bring up, it asks you, do you want to save it as a file or do you want to publish it? I save it as a file, and then I will add it in, and here is that flow. So I'm gonna move it over, 'cause it's gonna expand. I wanna join it.

37:53 There it is. Here's where my, uh, need to add the data here. So I take my data, add it, and now all that cleanup, all that, uh, those steps are now in the flow, so you don't have to rebuild it each time.

38:08 I wanna see if I can just do it here.

38:10 Okay, here's, for whatever reason why it's showing up there, is save steps as, save a file, or publish. So I can do it here, but not in the other one. But that's, so that's what you just want to do, is, uh, save it or publish it, and then you can import it into other ones.

38:22 And now I will hand it over to Sam.

38:26 Sam Homier: Thank you. I'm not really sure if this is a tip or a trick. This is just something, this is my favorite thing to do in Tableau Prep because it saves me a lot of time.

38:35 Um, so here I have a table with a bunch of student demographic information, but if I only need one thing, so for instance, if I'm only looking if a student is first gen, rather than coming in here and removing these fields like this, what I prefer to do is create an aggregate step before I do any other t- sort of cleaning, 'cause that does two things at once.

39:02 It allows me to keep the columns that I want, so student ID and first gen, and it also removes any duplicate values. So now only one, every student is only appearing one time by their first generation status.

39:18 The reason I prefer to do this is because if I need to bring a field in later, it's a lot easier to just go here and click. So if I need gender later, I can just come here and pick that.

39:30 Whereas in this step, I'd have to go figure out where I removed gender, find it, un-remove all of those fields, and then start removing fields again, right? So this is just a little bit more time-consuming and a lot more clicking around.

39:44 Um, and this also, one of the reasons I don't like to use the identify duplicate rows button, is because if I add columns in later, that but- that will break, and it won't include that column in the identify duplicate rows functionality.

40:03 So this only works if you are at the final, final stage of cleaning your data, and it is the very last thing that you wanna do. Any changes you make before you do this do not get implemented into this calculation here.

40:17 So this is just a really simple, easy way to both, like I said, remove duplicates and keep only the columns that I want to keep. Yeah.

40:26 So that's my tip or trick or treat for this month. Yeah.

40:31 James Emery: If I could, uh, introduce Russ, uh, Cantrell, who's be doing a, another one of our TC twenty six Encore presentations. So Russ is the Director of Data Administration and Strategic Initiatives at the University of South Alabama's College of Medicine.

40:46 He is also a five-time Tableau Ambassador, and that kind of, he's an academic ambassador, which now I think they're called the, the Teaching Community Leader.

40:54 And he is also the leader of the Gulf Co- Gulf Coast Tableau User Group down at Mobile.

41:01 He's currently pursuing a PhD for computing, and we know that this presentation is gonna be a good one because Russ won the most engaging and inspiring presentation at the twenty twenty-five APQI Research Conference. So he can definitely do good con- uh, presentations. So I will go ahead and hand it to him for this, this one.

41:21 Russ Cantrell: Wow, uh, let me see if I can live up, all that now. Let me go ahead and share my screen.

41:27 I will confess, I have not seen these slides since San Diego, so I will, uh, definitely try my best to be engaging, but I, uh, I may wander a little bit, but that's okay as well.

41:37 The topic here is, um, making curriculum data make sense.

41:42 I presented this at, uh, San Diego, but the issue was there were two higher ed, um, tracks at the exact same time, and a lot of people wanted to have a, uh, repeat of this to try to catch it. So I'm going to do it here and try to, um, try to share what we found out at the College of Medicine.

41:57 Again, name's Russ Cantrell. Uh, keeping in t- keeping in line with the spooky Halloween-y theme, I am a frequent, uh… Whoops, that didn't mean to happen.

42:05 I'm a frequent August, uh, October presenter for special groups, 'cause believe it or not, I used to be a ghost hunter of all things.

42:12 So, um, no ghosts in the machine, uh, right now, but that was just me being a bit, bit clumsy.

42:17 But today I'm here as the Director of Data Administration and Strategic Initiatives at the, uh, Whiddon College of Medicine. Again, five-time ambassador, huge honor. Very, very meaningful for me to be able to give back to the community. I have a very big passion on trying to, especially with the data fundamentals and data literacy, especially for researchers and faculty and non-computing, non-computer science students who think data is a four-letter word, something they just outsource their IT team and, and not worry about.

42:46 I love trying to show them how data can make meaningful changes in your life and make things a lot easier for you.

42:53 The agenda slide here was something that was required by Tableau. Um, not… This is more of a case study customer te-testimonial about what we're doing for accreditation and evaluation, uh, A&E, we refer to it as.

43:05 But like anything, you can break it down into a couple of steps. We had to define the problem, come up with a plan, and then the theme, the other theme of today besides Halloween, is clean up and prep. That was the biggest piece of this. Then finally, designing the dashboards that everybody gets excited about, and then the results at the end.

43:21 I think the results kind of speak for themselves. This was, um, Tim Gilbert is the dean and a phenomenal individual. I love him to death. He is an amazing human being. And he pulled me aside one day and said that I was able to get more accomplished in two months than he was able to get done in two years.

43:39 I just had to sit with that for a minute. That's probably the, the best professional feedback I've ever received in my career. I have to take it with an entire mine of salt, of course, because he is doing a million different things. He's an extremely important person.

43:52 He hasn't been working on this one task alone for two years. But still, that shows you the, the value that a data professional can add to a team and the value that each, each and every one of you add to your teams by having somebody who's trained in data, who's familiar with data, and who has the literacy to be able to do these types of things. You can make huge tr- transformative, um, changes just, just by having, uh, a knowledge of the process, the procedure, and the, uh, and the tools in question.

44:18 The problem we had, this was, uh, when I first signed on with the company about three and a half years ago.

44:24 They had a lot of data, but they didn't know what to do with it. The, the good insight was hard to find. It's not that they didn't care, it's just they didn't know where to go. It wasn't a lack of interest. It was just the underlying data was scattered and, uh, inconsistent to the point that they thought that doing a program review was looking at the student satisfaction scores.

44:46 The numbers here are, are made up. They don't matter. But that's what they would do. They would look at the student satisfaction, uh, surveys. If the s- students were happy, they did a good job, thumbs up all around. That– and that was… They cared. They always wanted to try to do better, but that was really the only tool that they had.

45:03 The problem is they had a lot of unintentional siloing going on. Each course director, whether you're the, um, the person in charge of the surgical, uh, uh, class or oncology or OB or pediatrics, you are the subject matter expert in that course, and you've built everything for your course the way that you need it. But it ends up siloing things such that we can't compare very easily year to year or between course to course.

45:31 There wasn't a, a good clear picture of the entire curriculum at one, at one time.

45:37 Further complicating things is people did things their own way. We had Excel files, PDFs, uh, Word documents, a bunch of different, uh, file types.

45:45 It was just, it was just a, a headache to try to consolidate and, and manage.

45:50 So my first task when I got here was to build something that lets us see the entire med school curriculum on a single pane of glass.

45:58 One piece of paper, every course, every clerkship, everything on one, one single screen.

46:05 And w- I was working with David Williams, the, uh, the assistant dean here. He sketched this piece of paper out and asked me if I could build this.

46:13 And I, I don't have the camera on because I'm presenting, but I'm sure there's probably a couple of chuckles in the audience because of course, we can build this. There's nothing there.

46:22 But sometimes that's the only blueprint we have to work from. So we had to… The, the first step before we could actually start build– even before we could start cleaning up things, we had to come up with a good plan.

46:33 The way that I approached this is that I'm the new guy. I only have limited pull. The people I'm talking to are PhDs, MDs, or sometimes both. They are by far the experts in their, their field, whether it's surgical or cardiovascular or whatever the, the medical school curriculum is.

46:51 And they're set in their ways. They do things the way that they, they need it done.

46:54 So I wanted to make sure my design honored that and try to keep it as simple as I could for them.

47:00 I know that they are only concerned about their one class, so they're still gonna use the Google Sheet or the Excel document as their main fr- uh, tool and their main frame of reference. So I wanted to make sure things remained human readable.

47:13 I wanted to design for the non-technical users while still correcting the things that I needed on the back end to be able to clean up and prep. The, the main goal would be to reduce the manual cleanup wherever possible and create some kind of standardized, um, structure that we could reuse year to year, class to class, and hopefully get as much automation in place as possible to, to take the, the, um, the manual processing off people.

47:36 And by people, I mean me.

47:38 The way I went about this is I made a official template. I took the best parts of the existing course spreadsheets that people were using.

47:47 I mixed and matched a couple of pieces, trimmed the fat of some of the parts that were no longer relevant or that we could get from elsewhere.

47:53 That kept it with a very familiar structure and layout, and it gave a, a very… It was a very strong product because it was already been, it had been tested for years, and it was a very easy ask because it's very familiar to what they were already using. It's the same structure and layout, just with some different terminology and slightly different, uh, ordering of some things.

48:15 The big thing i- for us was that it gave us very consistent data across all the courses.

48:21 We didn't have to worry about people, um, doing things slightly different ways, something's being called a, an exam or a quiz or a test. Now they're all written exam and something very, very easy to, uh, to standardize.

48:34 The goal was not to reinvent a process, but use what was already familiar with people and what's already proven to work, and that's gonna give us a lot of, uh, buy-in from the end user when we start making these big changes.

48:45 This is an example of one of the tabs on the, uh, spreadsheet. I, I can– I made them all tabs on a single sheet instead of them being multiple files.

48:53 Basically just your column headers in, on row one, a little quick explanation on row two, and then your data from three on down.

49:00 I also put as many dropdown boxes as possible. Again, so instead of some people calling it a quiz, a written test, an oral test, a pop quiz, an exam, a final, a midterm.

49:10 If you have something called week, uh, something called written exam, now it becomes standardized across every year in the, in the curriculum.

49:18 For the objectives met, I originally had that as a, as a Excel formula, where if it hit a certain percentage, uh, for each of the different items, it would automatically calculate as met. But that ended up breaking a bit, so I just left that as a toggle and then have an error check step in prep such that we can calculate that if it was left blank or if it was incorrect, we can, we can double-check it in prep using those same, um, same formulas and same calculations.

49:42 Big– One of the big issues were the course name and the academic year. I originally had that in the file itself, but that means that the human readable, the human usable file, the first column was column F, which makes it very clunky for them to use because the data they care about is almost entirely off the screen.

50:04 So I hid those fields. If you can't see it, you can't mess with it. Now, I start having collisions where everything is, is, um, uh, family medicine for the year two thousand and twenty-four because nobody ever went back and changed those. How do you forget myself when I'm– Until I see it in prep and wonder why I'm getting such an abnormal result.

50:23 So the easiest thing to do there is pull it out into the file name. As long as you can do it consistently, you have the course, the project, the, the, the academic year,

50:35 and, and of course, the file type. We can then parse that, uh, using the split command in prep on the space character to pull out those different things, and we have a lot of the data that we needed without having to specifically ask for it.

50:48 Prep is the real star of this presentation. In fact, this is the project that made me fall in love with Tableau Prep.

50:55 Before this, I was entirely self-taught.

50:57 Prep was a little bit intimidating. I didn't understand it all that well. I was kinda hesitant to dip my feet into the waters and really learn it. But I saw this project and saw the scope of what they were trying to do.

51:08 Uh, I think right now we're up to about three hundred and fifty different spreadsheets. So that's something that Prep can handle very easily, taking that large number of, um, input files, consolidating them, grouping them, merging them, cleaning them up, and everything that we need to do.

51:22 The first step is, uh, once we have the consistent naming convention, uh, I can start pulling, again, start pulling that in with the split command. That gives me the academic year, the course name, uh, things of, uh, things of that nature.

51:35 Beyond that, there's certain things that always hold true.

51:39 We always know that the year one curriculum is going to start off with the foundational medicine a-and, and things of that nature. We always know that it's gonna be year one, class one in a certain order. So we can go ahead and assign the year and the class number.

51:52 In med school, we have modules and clerkships. Modules being the academic, uh, book learning, classroom environment, and clerkships being when you're tailing a doctor in a clinical setting, learning on the job. So we're able to add these extra data fields based on our existing knowledge of the curriculum. And some of the, some of these things I, I dislike hard coding things on principle, but in these cases, it does make sense because humans are always gonna have respiratory system, they're always gonna have a digestive system.

52:21 Some of the things are, are human nature to the point that they're not gonna change anytime soon. So it's very easy to, uh, to rely on that data being, uh, fairly static.

52:31 The rest were things that came out of the actual committee, which aren't quite as static, but it goes through an entire committee process once every five years before anything changes. So I don't have to worry about this changing unexpect-unexpectedly. We have five objective groups, whether it's, uh, medical knowledge, patient care, system-based practice, and then the different objectives that we have to meet, some that were determined internal by the college, some that are from external accrediting bodies of the different things that we have to be able to prove that our students can do before they can graduate.

53:01 So we have these all listed in here, um, in a lookup field for those, uh, those calculations. That makes the dashboard easier to read later because we don't have to remember or decode all the different, uh, different numbers. We have everything, uh, we can pull up in toolkits and such.

53:18 One of the big issues, though, were had to deal with the delimiters.

53:22 We have a lot of, um, commas, uh, in text. We have names that were last name, comma, first name.

53:30 A bunch of different, uh, uh, people, uh, in the Excel sheets, they would, um, put the objectives as objective one, comma, two, comma, three. So that would break everything that we had to do. So I had to go through several steps of stripping out the commas, cleaning up all the spaces, replacing it with a single delimiter.

53:47 I-I'm using pipe, but I've also used tilde and a couple of others that are seldom used in actual, um, actual text.

53:54 That way, we have the delimiters that we know are meant to be delimiters.

53:58 And then I'd go and spot fix things. If you have a known phrase like truth, justice, and the American way, where it's supposed to be a comma-separated sing-singular thing, we can– I can just go back in there and spot fix those to, uh, to address those.

54:12 We also– That lets us start, uh, analyzing things a lot more reliably because we have things formatted in the pattern that we, uh, we want and we need.

54:20 We also had a couple of external standards that we have to abide by. This one's called MedBiquitous, and they have– it's a certain way of categorizing certain items, mainly the instructional method, uh, how we're teaching the material and the assessment method, how we're recording the responses and making sure that it's learned and verifying that it's, that it has been learned and has been, uh, been memorized.

54:42 They have their own coding, uh, one, one, two, five, seven, nine. So I've got the lookup table there.

54:49 But the problem we would run into is we get frequent groupings. Again, using the exam as a, um A, a popular example, the professor wouldn't know whether it's technically a quiz or a test, so they would put one five seven nine to cover all of your bases of test, exam, quiz, midterm, whatever. So we would get a lot of things that looked like four different pieces of data, which were really one piece of data.

55:15 That being the case, we end up moving away from that and going to our own, um, our own USA approved objectives.

55:23 The committee met and decided they only wanted, say, written exam.

55:28 So all the other ones I would go and, and manually translate over in a, um, a, a case statement here. If you saw one of the old codes, bring it over to the new code that we've decided on. If it– if there isn't a one-to-one correlation, I, I would use this to throw an error message saying, "This is an ambiguous code. Please update the, the input file." If it's completely unknown, I've got a, a line in here that says, um, "Not on the approved list.

55:56 Please update." That gives the, the, some feedback to the end users what's not displaying and why.

56:03 So when we do go to the actual, um, A and E committee and the course review after each course, they would see that it's not listed for a certain reason, and they would, they would know what to fix and, and why.

56:14 I also have a, uh, an if in here because b-before that change, it's using what was there, and then after that change, it, uh, is using these new codes. That way, it keeps it being, uh, backwards compatible.

56:25 One of the bigger changes I, I've noticed that, uh, you wouldn't think would make a huge difference but did for us was changing null to, to no data or some other, um, human readable term. I ha- ha- you've used that word a little bit too often, but that's, that's probably the best term for it.

56:41 People see null, and they see a computer term. They see an error message, and especially when you have a brand-new program like Tableau that we, that, that we just brought into the university. "This program isn't any good. Look at all the errors that it's throwing." I, I, I don't want that to be the case at all. That's, that's not the case. It's correctly reporting that no data is there, and I needed to distinguish that.

57:00 So I would go through and deliberately change null to unknown, other, no data, or something else that is, uh, contextually appropriate for the category in question. That way, when the review happens and they see no data submitted, now instead of blaming the program, people are looking at the, the instructor like, "Why didn't you turn your stuff in?" And nobody wants to be that guy, so they're more willing to turn their stuff in to make sure their, their area of responsibility loo- is nice and good and has all the green check marks, and they don't get accidentally outed in front of everybody.

57:34 It's a great way to k- to help drive that, uh, that adoption of new, uh, new workflows, new programs, new technologies.

57:41 Especially with a brand-new, uh, format, procedure, template, program, the, the works.

57:47 It's very likely to have a bunch of missing data that needs to be cleaned up or adjusted. So this is a way to, uh, to highlight that and, and do so in a way that's very, um, uh, very conducive to, uh, to working with the program and, and, and getting on board with the new, uh, the new workflow.

58:03 Desktop. Now we get to the part where we start designing stuff in desktop, a little bit of a show and tell of a couple of things we're doing.

58:09 This is where everybody gets super excited about the actual visualization, even though today, I guess it's more a little bit on the, the prep side.

58:17 This was the end result. They wanted the entire curriculum on a single page.

58:22 I've got the classes on one axis, the categories a-along the top, and then the each individual objective. If you were to hover over that, you would see the tool tip, and if you forgot what PC three was, it would say patient care, and it would say objective three equals, uh, showing respect for the patient under these circumstances, whatever, whatever the, uh, actual criteria would be.

58:44 Got it set up as a heat map based on categories, so they can look and see the high spots and low spots at a glance. Again, the numbers are completely artificial here, so d- uh, don't take those to, uh, to heart.

58:54 The most important thing I think I did on this, though, they were thrilled. They were in love with it. They thought this was amazing.

59:00 But I sat in on the first meeting to see how they actually used it. No camera, no audio, didn't announce myself, just fly on the wall, wanted to see what they did.

59:09 And the first thing they did is highlighted one row and looked at that one row.

59:13 Because this was being done as a course review, so after, uh, course number three had completed, uh, I think that's Principles of Foundational Medicine.

59:22 PFM completes. The PFM instructors are kinda justifying what they did, why they did it, how they can improve, looking for, for problems, looking for ways they can, they can do better next time and, and address, uh, any possible, uh, areas of concern.

59:35 But they accidentally made ninety-nine percent of this dashboard completely obsolete.

59:39 What's worse is they would go to academic year and toggle back and forth, this year, last year, this year, last year, to try and see what had changed. So it makes it extremely difficult 'cause you're having to memorize the values and then flip over to the next version and, and try to compare both of them in your head.

59:57 So I, I don't wanna say this was useless because this is still a… this is probably the most useful one that we have, and we use it in a million different contexts, just not the one that they had asked for.

1:00:07 So pretty quick, I threw this together, uh, while I was on the call and, and give it back to them. "This isn't what you asked for, but this is what you need. Here you go." It's not terribly pretty because it's, it's for internal use, uh, only. It's not something we're, we're posting, uh, uh, publicly outside a group site, uh, like this.

1:00:24 But it gives you multiple years, so you can see what's in, uh, in- increased or decreased since the previous year. It's only focused on the one course in question. It also pulls in, instead of pulling in twenty-seven different courses, it's pulling in four different spreadsheets and showing them all on the same screen at the same time. You're able to see the, uh, grades, the course evals, the instructional, uh, methods used, everything that they really needed for their review.

1:00:52 This is now page one of their, their meeting. They load this up, look at it, and then they start diving case by case into the things that they, uh, they specifically need to address.

1:01:02 We previously were using the evaluations for a lot, so I kept that in there. But I'm a big fan of using, uh, graphs as tooltips.

1:01:10 So I took the, the, um, the, the agree to disagree scale, converted it into the, the raw Likert scale numbers. That lets me calculate averages. That lets me sort and rank. Now I was able to sort them by our strongest to weakest areas.

1:01:25 Everybody can see exactly where we're doing well and what we're struggling in. I set an alarm threshold, so if it goes be-below a certain value, none of them here, thankfully, not very many of them at all. But if something were to go be-below, I think four point zero or whatever the case may be, it would be red background, giant text, red, and, and it definitely signal on alert status.

1:01:45 Hovering over the question, you see how do you get that four point three. You can see how many agrees versus strong agrees we have. Lets them, um…

1:01:53 It, it hides the data until they're ready for it, but then it rewards them when they want to explore it, and, and they're ready to start exploring and digging deeper. All the questions that they have are asked just as soon as they think to ask them.

1:02:05 Shifting another layer down, going away from the individual courses towards the individual objectives. I've got a s- a summary here where it's showing on an objective-by-objective basis how many times we may– how many times we presented it, measured it. Did we measure it? Did we not assess it? To try to find out what any– where any weaknesses lie or redundancies lie here.

1:02:27 Also have it broken down by the med school year, so we can see that if something was focused on very heavily on your second med school year, maybe you wouldn't need to focus on it on years three and four because it's already been addressed. We can see, we'll see where in the curriculum some of these changes were happening.

1:02:42 After looking at the objectives, the next logical question was how those objectives are being taught and assessed.

1:02:48 So I created two, one for the assessment methods and one for the instructional methods. That way, we can see very, very quickly how many times we, uh, present lecture, PowerPoint lecture slides versus hands-on lab, um, demonstrations versus peer assessment, research group, class participation. Different, uh, different types of instructional methods or assessment methods.

1:03:12 I also made sure to use the same consistent color coding throughout every sheet. That way, you can look at it very easily and immediately know without even thinking that green equals medical knowledge. It is built in because it's so consistent across every dashboard I build.

1:03:25 Also careful not to make that the only way to distinguish. I've got the learning outcomes as a text column for the sake of accessibility. So you're– if you were color blind, you wouldn't, uh, bleed some of these together.

1:03:37 If you, if you are able to see it, it's very quick and easy shorthand. If not, you're, you're not missing anything because the data is also presented in a way that's, uh, it's gonna be convenient for everybody.

1:03:46 Of course, we've got the, um, the bands at the top of the page for the big questions that you have. I've got that consistently across every, um… the, the same header across every tab, just with different KPIs, depending on the topic of, um, of, of concern for each, um, each tab.

1:04:03 Again, with people using things a little bit unexpectedly.

1:04:06 I work in the accreditation department, and we have to, um, basically justify our existence every eight years, whether we're allowed to continue having a med school.

1:04:15 Our assessment is actually this Monday, so we're three or four days out. God help us.

1:04:20 One of the things we have to do in preparation for that, we have to submit literally a four hundred-page document outlining every single thing we do in the College of Medicine, top to bottom.

1:04:31 And because these, uh, visualizations were so helpful, the first thing people were doing were going and screenshotting them and sticking them in the report because a picture s- uh, sends a thousand words. That's the quickest way to prove what we're doing, how we're doing it, and why.

1:04:45 The problem is this was meant for a PowerPoint presentation or a big, um, uh, video screen.

1:04:52 It was meant to be more self-explor-exploratory or, or driven by a, um, an individual giving a presentation.

1:05:00 So the images didn't really come across very easily in– when, when, when taken out of that context and put into a, uh, a Word document.

1:05:08 So I created a second version and just called it Print View, such that everything is large, bold. The, the color highlighting is, uh, is, is not going to, um, wash out any of the text. The numbers are all large and easy to read. I've got the headings and subheadings for each, uh, each item, so you have immediate context what you're looking at and why.

1:05:30 I would put the filter variables in a highlighted blue color because you can't see the actual filters because you're not seeing the full visualization, but you know that this is for academic year twenty-four, twenty-five. It's for, uh, objective P one.

1:05:45 So y-you have that context even when you're only seeing a small excerpt of the screen.

1:05:50 But I, I'm going too fast again.

1:05:53 Small multiples, of course, is something, uh, uh, very useful. This is one of the, uh, one of the exam results to show areas that we're doing well in versus areas we need to focus on.

1:06:05 This…

1:06:06 I, I don't tend to like stacked bar charts because you lose everything in the middle, but it does show, uh, basically a green chart and a red chart very easily. You can see, uh, two different charts and then read those from the differing axes. And in the middle is, is the ones that are aren't of, uh, of, of good concern. They're not the outliers.

1:06:24 I'm trying to get people onto, um, an actual Sankey. This is from Tristan, LaDataViz. Shout out to him and all the amazing work they do.

1:06:33 Uh, this is more than I would actually show in a, uh, a course review, but just for, for just the illustration purposes, being able to highlight, hover, select, and of course, filter over on the, uh, the side, that gives you a very good way of seeing how things flow into different states. My goal is going to be that if you were to select one specific course or one specific, uh, objective, you would see which courses feed into it, what years, uh, they are, how many were met versus partially met, things of that nature.

1:07:04 I don't think we're quite there yet, but I've got it built out. I'm trying to introduce people to this as another tool in our, um, another arrow in our quiver when we're assessing our courses and curriculum.

1:07:14 As far as the results, I think, uh, that things are going over very well. It's had a very tran- uh, transformative effect here on the, um, the team here locally.

1:07:22 The big question I get when I present this at different places is, the first people, thing people ask is just how many people are on your team? Is, they're just dumbfounded at how much we're able to do in a short amount of time.

1:07:35 And we have an amazing team. Uh, they're all pictured here. Had to shout out to my, uh, my USA folks here.

1:07:42 They're all specialists in a different area, but as far as the data team, that's, that's just me. It's just one person with Tableau doing some of the stuff, and we have completely redone how we handle all of our curriculum, um, assessment, evaluation, and program review.

1:07:59 It's, uh, I'm gonna start, probably gonna sound like a commercial if I start, uh, reading all of these off, but it, it's kind of what you're expecting. It's faster, it's more efficient. You've got clear visibility into gaps and overlaps. Uh, it's gonna be very consistent across courses and years. Uh, the, people have a lot more confidence because they know there's good solid data behind this instead of just being one person's Excel sheet that they're, uh, they're looking at.

1:08:22 And we're able to go into a lot more detail. The inset image here is actually a, um, the first big in-depth program review we've done, and it really opened a lot of eyes. If you pay attention to the, uh, the Post-It notes on the back wall, those are my Tableau dashboards. The, the, the large one with the entire curriculum on one page.

1:08:41 David Williams, uh, l- love him. Fantastic individual. He had giant poster board, uh, pieces of paper, color-coded sticky notes, the same colors that I were using, and he gave them to each of the, the course directors to put them in small teams and said, basically, "Where do you think this is being addressed in the curriculum?" And they would have their best guesses based on what they taught, what stu-students knew before coming into their class, and they would try to guess where certain things were being covered.

1:09:09 And then we would put on the, the big, uh, video boards my dashboard to compare their results to my results, and it would absolutely blow people's minds. They did not know that students didn't know that before coming into their class. Or they would think, "I need to focus on my class because it's not being taught after my class. I need to p- in- incorporate it into my curriculum." 'Cause not everything needs to be addressed in every class, but it does need to be addressed at some point over the four years, and it just becomes a, uh, a method of where do you bring it up and where do you focus on it to make sure a- all your, all of your, uh, requirements are covered before the, uh, before you graduate.

1:09:45 Couple limitations and things I'm still working on. Again, being a team of one person, it's, uh, I'm, I've got a wish list of things that I'm, I'm working on.

1:09:52 My biggest issue is trying to sync things up with Google Sheets. That, that's what we use internally. It's all Google Sheets. And I'm having trouble connecting to them, especially when I'm trying to use things like, um, the, uh, what, what is it called? The, um…

1:10:08 I can't think now. But w- when, when it does some of the automatic cleanup of the columns and, and the rows, it will do it for Excel but not, uh… D- Data Interpreter. Yes. Data Interpreter, where they would use that one f- for Excel, but cannot use that for Google Sheets.

1:10:21 Um, I have to make s- if I leave it, if I'm connecting directly to their stuff, I have to make sure they have the naming convention correct to, to match the wild cards.

1:10:29 And there's still chances of, um, people kind of going off course, doing things a little bit differently.

1:10:35 The, one of the bigger issues is that the file structure is gonna be nested pretty deep under, under, uh, clerkships, under year four, under surgery, under something else. So I'm, I'm having to find all of these different things. My workaround basically is just to, uh, whenever they say that they're done filling it out, I'll save it as an Excel file, put it on my desktop, and I'm using that as a staging ground with the Google offline file sync, and then up to a, a automation with Tableau Prep and Tableau Desktop to u- to push it out that way.

1:11:10 I'm probably gonna have to do some scripting as well to get things the way I, I, I fully need it to to get it fully automated, and that's the, the future improvement. I want to add more drop-downs to, to reduce human error. I want to, um, ch- clean up the prep flow since this is my very first prep, uh, project. I'm very much looking forward to the prep school that's coming up, because I need to learn how to be a little bit more efficient.

1:11:31 Be- it, a- after several years, it's starting to get to the point where it's slowing down a good bit. I need to use some of these tips and tricks to, to make it a little bit easier to, to manage. And then incorporate more of the previous year changes and comparisons of that nature to a- again, answer the questions they have before they think to ask them, and have everything very, um, very, um, at their fingertips.

1:11:52 But that's all that I had prepared. If you have any questions, feel free to, to ask, and I'm, um, I'm here to, uh, address any, uh, questions, comments, or concerns.

1:12:01 Roshni Gohil: Can I just say that that, uh, visual you with the, the clicker in your hand, nice ending touch on that presentation.

1:12:09 Russ Cantrell: Thanks.

1:12:10 Roshni Gohil: We were talking earlier about a bunch of mouse and other, other ghosts in the machines, uh, issues that we were having. So I like that, that closing.

1:12:21 Trying to see if we had any questions. I think we just have a lot of, "Holy cow." Like, "There's all these cool ways of, of doing things." So James had some comments around, um, using, uh, you actually being able to perform calculations on a field before you use a case statement or an if else, um, which can sort of smooth out and speed up, um, some of your, your calculations.

1:12:44 Um, that whole idea of actually seeing your dashboards in use to be able to figure out what is and isn't working, and that fact that you're able to do that live during that one meeting where you just sort of slid in without anyone really paying much attention to you, like that…

1:12:58 I love that story. I just love that you're just able to provide them what they needed almost immediately. Um, 'cause I think it's really important that, you know, we, we actually see what people are doing with what we build so we know if what we're building is the right thing.

1:13:12 Um, 'cause even if they tell us, "This is what I want," that doesn't always mean that that's what they want or need.

1:13:18 Um, I'm not… I'm seeing a bunch of fabulous presentation, great presentation.

1:13:23 Um, ooh, and a tip ar- around potentially using the Google App Script to clean up your Google Sheets instead.

1:13:32 So that was really great.

1:13:34 Um, all right.

1:13:36 And we are running short on time. Um, so we are going to hand out swag, but we're gonna do a wheel of names thing, um, offline so that we can open up breakout rooms while, while folks are still available. Um, I'm seeing one more thing that we wanna call out before we, uh, move on, though. Um, HEDW, the Higher Ed Data World conference is happening.

1:13:59 The call for proposals is now open, um, with a submission deadline of November 1st. That's two weeks and change. Um, the link is in the s- uh, chat, and Miguel, if you can throw that in the Higher Ed Tableau Slack, that would be amazing. Um, I'm seeing a really, really cool big cat on the image, which is just… It- it's almost like a dinosaur, so, you know, obviously I'm gonna be happy about it.

1:14:25 All right. Um, so before we close off, we wanna tell you about what's next. So, um, tell us what you thought of today's meeting. We have a… I'm putting a link in the chat right now. Um, you know, what you tell us will help inform what happens in future HE TUG meetings, um, whether it's in terms of what we have as presenters, what types of questions we have, whether we have more Q&A type things like we did today, um, with the higher ed team.

1:14:53 Um, we are also, uh… The registration's also open for our November 18th HE TUG, and the link is in the chat here. We are looking for a community member to meet. Uh, we will… We can share questions with you beforehand, uh, so you're a little bit prepared. Um, and, uh, we'll have Neha, uh, Thakur from Northeastern, um, talking about gauge charts, and then Michael Faulkner, you may remember from, I wanna say March of '23, '24, something like that, um, talked about, uh, some of the initiatives at Surry Community College.

1:15:27 Well, Michael's going to be back now along with another Michael. I don't know how we're gonna keep Michael and Michael together and, and separate. Um, but they're gonna, they're gonna talk a little bit about some of the, uh, data visualization work and sort of the, the… what's happened since, um, Michael Faulkner's original, uh, message. And then, as always, we wanna hear from you if you wanna present.

1:15:46 Um, the link is in the chat. So whether you wanna present at a future HE TUG or, don't forget Tableau Prep School Confidential. If you want to share some, uh, some, some learning about… around Tableau Prep, um, how to use it, uh, we are looking for folks to help present. Um, there… We didn't talk about it much earlier, but, uh, it's not… You're not just gonna be told, "Hey, go present on this." Um, we're gonna have some support from the Tableau solutions engineers, uh, including folks like Dan, um, and others, uh, to both help build out the curriculum and some of the examples, and we are h- h- you know, gonna focus on using a Tableau, sorry, an education, a higher ed mostly dataset, um, for these examples.

1:16:28 So we're, we're gonna try to provide as much support as we can to help, um, with this initiative. Um, and again, we're getting support from the Tableau team 'cause they're awesome.

1:16:37 Um, so yeah, present. Tell us if you wanna present. And if you don't wanna present or don't feel ready to, to share tips and tricks, um, we do wanna hear what you wanna learn more about, um, in Tableau Prep. So, um, feel free to chat in the Tableau Prep channel in the Higher Ed Tableau Slack. Um, link is somewhere in, in this, um, or just we're, we're gonna post about it in, in the general channel, uh, if not today, then tomorrow.

1:17:04 So with that, I'm gonna pass this off to Sam.

1:17:08 Sam Homier: Yeah.

1:17:09 Roshni Gohil: I'm gonna try to pass it off to Sam. There we go.

1:17:11 Sam Homier: Yes. So we wanna, as always, close out the meeting with, uh, some upcoming TUG meetings that are related to higher ed. So we have the accessibility TUG, and Roshni's gonna put all these links in the chat right now, I believe. Thank you.

1:17:24 Um, so yeah, the accessibility TUG is happening on Friday, and Michael Kaminski and Scott Eaton will be sharing their accessibility journeys.

1:17:34 Roshni Gohil: Miles. Miles.

1:17:37 Sam Homier: And then, um, we mentioned this earlier, the Tableau showcase on October 28th, where a bunch of universities and colleges will be showcasing their dashboards.

1:17:47 The CCC TUG, the California Community Colleges TUG, is meeting on November 5th, and we will have Chris Ozuna and Christian Millian from the chancellor's office showcasing some internal dashboards.

1:18:01 Um, so this is very interesting ti- It, it… We'll get to see kind of what they're doing behind the scenes, right, at the chancellor's office.

1:18:10 Um, and then the newbies TUG is meeting on November 10th, and it is the seventh stop on their road to certification. They're gonna be talking about formatting, actions, dynamic zone visibility, and storytelling, featuring our very own Higher Education's Lisa Trescott. So-

1:18:26 Roshni Gohil: Ah

1:18:26 Sam Homier: … if you are new to Tableau, please attend that.

1:18:29 Um, and yeah, that's it. I will pass it over to James to close out the meeting.

1:18:33 James Emery: Well, thank you for coming today, and I'd like to thank Dan and Gabriel for giving us the, the overview of how Tableau is used in higher education, and, and for Russ for, for teaching us about preaching to himself, but also giving a shout-out to the importance of prep. And so kind of encouraging people to, uh, do the, the, the Prep School.

1:18:53 And don't forget to, uh, to sign up for Slack, um, so you can also tell what you would like to see in the Prep School, and just be able to, to answer questions or ask questions within there. So don't, uh, don't just sign up. Also keep it open or be, be a frequent member or frequent contributor to, to our Slack channel.

Leave a comment

Your email address will not be published. Required fields are marked *