K12 Tableau User Group meeting: September 2024

National K12 Tableau User Group event from September 2024

1. Session begins at the top of the hour!
MUTE your mic please
Yes, the session will be recorded, if we forget please remind us.
Use the CHAT feature to say, “Hi,” and tell us where you are
joining from.
Use the Q&A feature to ask your questions for the presenters.
Use the CHAT to give your praise and color commentary.

Welcome and Happy “New Year” K12 Data Rockstars!

2. Back to school:
Time series displays and
Early Warning Indicator
dashboards.
September 3, 2024
https://usergroups.tableau.com/k-12-tableau-user-group/
K12 TUG

3. K12 Tableau User Group
370
registered
community
members
8+
events lined
up for 2024-
25
3
TUG Co-leads

4. A Global Community Of Helpful People + Free Resources
Supporting Your Data Journey
9M+
Tableau Public
Visualizations and dashboards
to inspire you
Learn More + Get Started: Tableau.com/Community/Welcome
400K+
Tableau Forums
Users answering questions
to skill you up
500+
Community Blogs
To inspire you and help
advance your data journey
25,000+
TUG Members
For virtual + local learning
and connection
3M+
Students + Teachers
Empowered with free
software and data skills

5. welcome to the
GET STARTED WITH MORE RESOURCES:
Tableau K12 Introduction from Salesforce
Tableau Tuesdays Demonstrations
K12 Tableau Q&A Community
K12 Tableau Networking

6. Announcements
Tableau new stuff
K12 TUG stuff
Your new stuff (achievements, opportunities, etc.)

7. Shared Dimensions
Simplify sophisticated analyses
Holistic data models to bring in multi-fact
data across data silos

In K12 think: which data sources have
common fields such as student ID or race/
ethnicity? Your SIS + Canvas + Google
Classroom + Survey Responses

Ensure consistency and accuracy in common
data models across teams

Drive efficiency through a shared semantic
layer with fewer data sources

Shared Dimensions Summer ‘24

8. 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
Learn more with Tableau Tim
https://www.youtube.com/watch?v=Z0JtvH_WMmw

9. K12 TUG
Upcoming Events
October 9, 2024
•Community Member Spotlight
•Raquel Vandenesse, Virginia Department of Education - Virginia
•K12 Iron Viz Participants Tips and Tricks
•Brian Flores, Fresno County Office of Education - California
•Shelby Hurst, Douglas County - Colorado

November 6, 2024
•K12 Community Dashboards
•Tyler Portis, Noble Schools - Illinois
•Kate Ory, Chico Unified School District - California
•Stacey Pulmano, Hawaii Department of Education - Hawaii



MARK YOUR
CALENDAR!!

10. Your
Announcement Here
Sharing your success, opportunities
and needs with the community
Who cares? WE DO!!!

Get a promotion?

Have a Tableau opportunity for others?

Wish you a Happy Birthday or Anniversary?
K12 Happenings Fall ‘24

11. How to visualize time
“Time moves slowly, but passes
quickly.” — Alice Walker, The Color
Purple

12. Andy Cotgreave
Tableau Evangelist
Iron Viz Host
First downloaded Tableau
Desktop in 2007 as a data
analyst at the University of
Oxford

13. How we built an EWIS
dashboard with
‘SuperDistrict’ data
“History is a vast early warning system.”
— Norman Cousins

14. Collin Smith
Lyon Abido
The Information Lab, NYC
On a mission to help as many
people as possible to make
sense of their data.

15. Building a
“SuperDistrict”
Dataset for EWIS
Making Tableau training relevant for K12

16. Helping people make sense of data.
Thanks for joining!
Collin Smith
Senior Consultant @ The Information Lab US
Co-founder, Accessibility TUG
LinkedIn: collinsmith106
Lyon Abido
Consultant @ The
Information Lab
LinkedIn: lyon-abido

17. Helping people make sense of data.

18. Helping people make sense of data.
Equip thousands of companies around the
world with the skills and tools to make
sense of their data
OUR MISSION

19. TABLE OF CONTENTS
1 PROJECT BACKGROUND
2 DATA PREPARATION
3 DATASET DEMO
4 OUTCOME AND AREAS FOR IMPROVEMENT

20. Helping people make sense of data.
Project
Background
1

21. Helping people make sense of data.
AISD
Challenge
Could we build a two day
enablement training around
school district data?

22. 1 A MIX OF DIMENSIONS, MEASURES, AND GEOGRAPHY
2 OPPORTUNITIES FOR CALCULATIONS
3 CONSISTENT HIERARCHIES
4 “REALNESS” with simplicity
An effective “mock” dataset for education would require…

23. Helping people make sense of data.
Data Preparation
2

24. Helping people make sense of data.
1 2 3
Enrollment
Student level
information with
demographics and
school association



Absences
Class absence level
with class
categorization



Schools
Geographic
information for
school locations

25. Helping people make sense of data.
1 2 3
Mockaroo
Create the base
tables for analysis




Alteryx
Conditional logic
matching, preparing
geographic fields




Python
Randomize dates
within specified
range.

26. Assumptions
●Absences are for full day
●Absences can’t occur before a student’s entry date for
the school year
●Absences can’t be during the weekend or on holidays
●Students can only take classes within their grade level
●Accurate demographic splits (ESL, Race/Ethnicity,
Economic disadvantage) will be saved for v2

27. Helping people make sense of data.
Demo: Let’s
dive in!
3

28. Helping people make sense of data.
Outcomes and
Next Steps
4

29. More variation
More content
-Adapt more advanced
trainings to the dataset
-Create “Assessments”
table

Helping people make sense of data.
- Make dataset match
natural demographic
splits

More trainings!
-Work with districts
around the country to
build their Tableau skills

30. Helping people make sense of data.
Get in touch!
Collin Smith
Senior Consultant @ The Information Lab US
Email: [email protected]

31. Helping people make sense of data.
Q&A

32. Plante Moran
K12 TUG Sponsor
Tableau Professional Services
Server/Cloud support, dashboard development and mentoring
Self-paced Tableau Training
●Courses - introductory through advanced, technical + design skills
●Videos, instructions and hands-on work in Tableau Desktop
●12-month access to the learning management system
●Contact Stephanie Henry about he K12 TUG discount and to see a
demo!!
One-Firm-Firm
Support educational systems with infrastructure, technology, audies,
cyber security, analytics, governance, and more!
Footnote

33. K12 TUG
Upcoming Events
October 9, 2024
•Community Member Spotlight
•Raquel Vandenesse, Virginia Department of Education - Virginia
•K12 Iron Viz Participants Tips and Tricks
•Brian Flores, Fresno County Office of Education - California
•Shelby Hurst, Douglas County - Colorado

November 6, 2024
•K12 Community Dashboards
•Tyler Portis, Noble Schools - Illinois
•Kate Ory, Chico Unified School District - California
•Stacey Pulmano, Hawaii Department of Education - Hawaii



MARK YOUR
CALENDAR!!

34. Thank You