Data Storytelling With Tableau

Robert Else & Jordan Morris
Santa Barbara City College
Robert Else: Sr. Director of
Institutional Assessment, Research,
and Planning
Jordan Morris:
Information
Systems
Analyst
• One of the first CCC’s – founded in 1909
• About 20,000 students in Fall 2013
• Aspen Prize #1 Community College in the U.S.
• IR Department of 4
• IT Department of 8 + Network services
+ User Services
Searching for a Decision Support System…
• It has to be easy to use
• It has to be affordable
• It has to be easy to use…
• Fast implementation
• It has to be easy to use…
•
How many students completed “x” units and English 110/111 and Math 117, 120, or above
•
I need to know about students who have changed their major a lot.
•
How many FTES did we generate in Online courses, over time?
•
Do Business majors finish or transfer earlier than Chemistry majors?
•
I need facts about Ethnicity and transfer for a grant that is due Friday
•
Sorry, I meant Ethnicity and degree completion. Breakdown by age. Noon Friday still OK?
•
How many matriculating students have close to 100 units? How long have they been here?
•
And while you’re at it...this should be easy...
•
I need the option to exclude Summer...
•
And then I would like to see...
Ahhh...
the last report
I’ll need to
write...
What I really want to know is...
It’s not like we don’t have the
data…
Maybe we need…
Dashboards!
B
I
Where is the WISDOM
we have lost in the
KNOWLEDGE?
Where is the knowledge
we have lost in the
INFORMATION?
GPA by Residency and Gender
Fall 2004
Fall 2005
Fall 2006
Fall 2007 Fall 2008 Fall 2009 Fall 2010 Fall 2011
Female
2.74
2.2
2.26
2.55
2.49
2.5
2.59
2.59
Male
2.18
2.13
2.23
2.38
2.26
2.49
2.69
2.54
Female
3.07
3.61
3.24
2.79
2.64
2.98
3.08
2.59
Male
3.15
2.96
2.82
2.9
2.74
1.95
2.26
2.65
Female
2.84
2.67
2.81
2.75
2.77
2.83
2.83
2.7
Male
2.56
2.55
2.37
2.35
2.4
2.31
2.34
2.33
Female
2.75
2.7
2.71
2.7
2.73
2.74
2.75
2.78
Male
2.47
2.52
2.52
2.47
2.49
2.49
2.52
2.53
AB540
Out of Country
Out of State
Resident CA
Edward
Tufte
Stephen Few:
ThePerceptual
Edge.com
We evaluated
the usual
suspects…
Eventually
Gartner led us
to Tableau…
Tableau: noun: tableau; plural noun: tableaux
A group of models or motionless figures
representing a scene from a story or from
history; a tableau vivant….
Synonyms: picture, painting, representation,
illustration, image…
Recreating a Living Picture of a historical event…
The Original
The recreation…
The Raft of the Medusa (1819) by Géricault
The recreation…
SBCC
Data
Warehouse
www.tableausoftware.com
Robert Else
• else@sbcc.edu 805-897-3522
Jordan Morris
• jcmorris2@sbcc.edu 805-965-0581 x3029
Tableau Live Demo: Course Fill Rates
Tableau Live Demo: Student Pathways
Tableau - Student Demographics
Tableau Live Demo: Assessment Placement
Tableau Live Demo: Cohort Comparisons
Tableau Live Demo: Grades Heatmap
We set out to reproduce this study using our own data…
Work in Progress:
Reproducing the CCRC study “Intensity and Attachment” (Crosta 2013)
More
Crosta
(2013)
Visit the Tableau Public Gallery
http://www.tableausoftware.com/public/gallery