08142024_CCC TUG_First Year Birthday Bash

August 2024 meeting of the California Community Colleges Tableau User Group (CCC TUG). It's true what they say...TUGs really do grow up so fast! The CCC TUG is turning 1, and we're having a birthday bash celebrating all of you and your work. There will be a Tableau showcase exploring dashboards from 3 colleges, a birthday data challenge, and a demonstration of how to build Sankeys using viz extensions.

1. CCC TUG
Birthday Bash
August 14, 2024

2. CCC TUG
Birthday Bash
August 14, 2024

3. This meeting is
being recorded

4. Agenda
3 Tableau Showcases
Birthday Data Challenge
Office Hours - Sankey with Viz Extensions
Next Meeting - October 23, 2024

5. Tableau
Showcase

6. Transfers from
Skyline to UC
Skyline College
Adam Lange

7. Escape Cave
Allan Hancock College
Armando Cortez

8. Data Escape Cave
Armando Cortez
Senior Data Analyst – Institutional
Effectiveness

9. ALLAN HANCOCK COLLEGE
Dashboard

•Purpose
•Timeline
•Features
•Challenges
•Demo – Nuts & Bolts

10. ALLAN HANCOCK COLLEGE
Purpose
Create a dashboard that is fun and
engaging and requires people to explore
all of the various data dashboards AHC
has available for our program review
process.
Timeline
Originally created in early 2023 as a way to
showcase dashboards for the IE office and
promote new program review process. With a
limited rollout to testers it never caught on.

After lying dormant for over a year, recently
the President has enhanced efforts to make
campus aware of our available data
dashboards. There will be a mention during all
staff day and inclusion in the fall IE office
newsletter.

11. ALLAN HANCOCK COLLEGE
Features – AI generated story and images

ChatGPT was becoming a ‘big deal’ in early
2023 and I wanted to try it out to see if it could
write me a story. After some trial and error I
came up with the current version of the story as
a treasure hunter that needed to escape.

But what’s a story without images? I then went
around looking for AI image generators that
could create quick and easy images I could use
to enhance the dashboard. Much more trial and
error here but the end result is visually
engaging.

12. ALLAN HANCOCK COLLEGE
Features – Lock Room

The main part of the dashboard is the lock
room. From here you have questions to be
answered by visiting various dashboards. Using
the red/green circles as ‘correct’ indicators and
a timer at the bottom to track progress.

Tableau Public can reset at a moments notice
so a reminder on this page was important so
people didn’t feel too bad about losing progress.

13. ALLAN HANCOCK COLLEGE
Features – Favorite

My favorite feature is having the questions tied
to which adventurer you choose but not making
it obvious until the end. This way people can
create a more engaging story (the chosen name
is used throughout) and can have multiple
experiences.

I had a vision of a treasure map as the first page
of the dashboard from the beginning so being
able to create it with AI was a fun
accomplishment.

14. ALLAN HANCOCK COLLEGE
Challenges – Incentive

Biggest challenge of new a dashboard is giving
people a reason to interact with it. And
unfortunately, ‘a place to get your program
review data’ is not very enticing.

Adding a leaderboard created a small ‘game’
feeling to the dashboard. If enough people
would submit completion times it could be a fun
discussion topic.

15. ALLAN HANCOCK COLLEGE
Challenges – One and done

I knew I wanted to create something that was
more than a ‘one and done’ experience. Just
because you escape the cave one time I wanted
to allow adventurous people to go again with a
new challenge.

The two solutions I came up with was the
‘choose your name’ mechanic. What seems to
be an innocent choice actually creates four
distinct sets of questions.

I also made the questions easy to update in an
excel sheet so I could refresh the dashboard
annually.

16. ALLAN HANCOCK COLLEGE
DEMO - LINK

17. ALLAN HANCOCK COLLEGE
Summary
•Let AI do heavy lifting of engagement so you can focus on the data

•Create something that connects positive memories to data

•Gamify and incentivize the data as much as possible

•Always work on promoting dashboards and get buy in from all parts of
campus (administration, faculty, staff)

•Make data fun

18. Questions?
Armando Cortez
[email protected]

19. Feeder School
and Local Area
Statistics
Clovis College
Ryan Feyk-Miney

20. Birth-day-ta
Challenge
How common is the
CCC TUG’s birthday?

21. Vinnie Wu
San Bernardino
Valley College

22. Golnoosh
Behrouzian
MiraCosta College

23. Kimberly
Coutts
MiraCosta College

24. Samantha
Homier
San Bernardino
Valley College

25. Lisa Trescott
MiraCosta College

26. Birth-day-ta
Challenge
●Dates
●Heat Maps
Footnote

27. Dates
MAKEDATE()

Returns a date constructed
from a specified year,
month, and day

28. Dates

30. Dates

31. Dates

32. Birth-day-ta
Challenge
•Andy Kriebel
https://www.youtube.com/watch?v=DCGb7sczUWY
•Luke Stanke
https://public.tableau.com/app/profile/stanke/viz/D
ateCalculationsCheatSheet/CheatSheet
•Flerlage Twins
https://www.flerlagetwins.com/2021/02/dates.html
Date Resources

33. Birth-day-ta
Challenge
•What challenges did you
have working with this data?

•Any tricks you’d like to share?

34. Why so
many heat
maps?

36. Heat Maps
When to use
Work well with large
datasets to identify
patterns, correlations,
and outliers


Sequential:
●Gradient in one
direction
●Use with + or - values



Downside
Lack of granularity
makes it hard to
discern exact numbers


Diverging:
●Gradient in 2
directions
●Use with + and -
values


Color

37. Build a Better
Heat Map
https://datavizfairy.co.uk/b2vb-tips/build-a-better-heatmap/
Back 2 Viz Basics

38. Build a Better Heat Map
Back 2 Viz Basics

39. Build a Better Heat Map
Back 2 Viz Basics

41. Office Hours
Sankey Charts using
Viz Extensions

42. Viz Extensions
Bringing new visual libraries
into Tableau

Delight users with descriptive, engaging
visualizations

Create custom viz types for your unique
business needs

Get started fast with templated authoring
experience for rich visualizations

Viz Extensions Summer ‘24

43. See you at the next
meeting!
Wednesday Oct 23, 2024
1:00 - 2:30 PM

Ken and Kevin Flerlage
Moxy Analytics


https://usergroups.tableau.com/e/m4j77f/

44. Feedback Survey
How are we doing?
What’s working?
What’s not working?

We want to know:
https://forms.gle/PimEM3aHoKDmMNRs7

45. Do you have
something you want
to share? Let us
know!

https://docs.google.com/forms/d/e/1FAIpQLScJ
HLKhTRtrkvvLtpfHQBRBI_anicDqVbze0KJBiVyo
9ptdEg/viewform

46. Samantha HomierKimberly Coutts Lisa Trescott
[email protected]
@lisatrescott
Contact Information
[email protected]
@kimstrezz
[email protected]
CCC TUG
[email protected]
@CCC_TUG

48. Date Functions
Cheat Sheet Via Andy Kriebel
date_part DATEPART (09/16/2021)
DATEPART(date_part, date)
DATENAME (09/16/2021)
DATENAME(date_part, date)
DATETRUNC (09/16/2021)
DATETRUNC(date_part, date)
year 2021 2021 01/01/2021 12:00:00 am
quarter 3 3 07/01/2021 12:00:00 am
month 9 September 09/01/2021 12:00:00 am
day 16 16 09/16/2021 12:00:00 am
dayofyear 259 259 09/16/2021 12:00:00 am
weekday 5 Thursday 09/16/2021 12:00:00 am
week 38 38 09/13/2021 12:00:00 am
hour 18 18 09/16/2021 6:00:00 pm
minute 15 15 09/16/2021 6:15:00 pm
second 21 21 09/16/2021 6:15:21 pm

49. DATEPART()

Returns an integer
date_part DATEPART (09/16/2021)
DATEPART(date_part, date)
year 2021
quarter 3
month 9
day 16
dayofyear 259
weekday 5
week 38
hour 18
minute 15
second 21
Date Functions
Cheat Sheet Via Andy Kriebel

50. DATEPART()

Returns an integer
date_part DATEPART (09/16/2021)
DATEPART(date_part, date)
year 2021
quarter 3
month 9
day 16
dayofyear 259
weekday 5
week 38
hour 18
minute 15
second 21
Date Functions
Cheat Sheet Via Andy Kriebel

51. DATENAME()

Returns a name as a string
date_part DATENAME (09/16/2021)
DATENAME(date_part, date)
year 2021
quarter 3
month September
day 16
dayofyear 259
weekday Thursday
week 38
hour 18
minute 15
second 21
Date Functions
Cheat Sheet Via Andy Kriebel

52. DATENAME()

Returns a name as a string
date_part DATENAME (09/16/2021)
DATENAME(date_part, date)
year 2021
quarter 3
month September
day 16
dayofyear 259
weekday Thursday
week 38
hour 18
minute 15
second 21
Date Functions
Cheat Sheet Via Andy Kriebel

53. DATETRUNC()

Truncates the date to the
level specified by the
date_part
(like date rounding)
date_part DATETRUNC (09/16/2021)
DATETRUNC(date_part, date)
year 01/01/2021 12:00:00 am
quarter 07/01/2021 12:00:00 am
month 09/01/2021 12:00:00 am
day 09/16/2021 12:00:00 am
dayofyear 09/16/2021 12:00:00 am
weekday 09/16/2021 12:00:00 am
week 09/13/2021 12:00:00 am
hour 09/16/2021 6:00:00 pm
minute 09/16/2021 6:15:00 pm
second 09/16/2021 6:15:21 pm
Date Functions
Cheat Sheet Via Andy Kriebel

54. DATETRUNC()

Truncates the date to the
level specified by the
date_part
(like date rounding)
date_part DATETRUNC (09/16/2021)
DATETRUNC(date_part, date)
year 01/01/2021 12:00:00 am
quarter 07/01/2021 12:00:00 am
month 09/01/2021 12:00:00 am
day 09/16/2021 12:00:00 am
dayofyear 09/16/2021 12:00:00 am
weekday 09/16/2021 12:00:00 am
week 09/13/2021 12:00:00 am
hour 09/16/2021 6:00:00 pm
minute 09/16/2021 6:15:00 pm
second 09/16/2021 6:15:21 pm
Date Functions
Cheat Sheet Via Andy Kriebel