Data Storytelling with Tableau

1. Data Storytelling with Tableau Robert Else & Jordan Morris Santa Barbara City College Santa Barbara City College • RP Group Research and Planning Conference • April 2014

2. Who Are These Guys? Jordan Morris: Information Systems Analyst Robert Else: Sr. Director of Institutional Assessment, Research, and Planning Santa Barbara City College • RP Group Research and Planning Conference • April 2014

3. Santa Barbara City College Facts • 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 Santa Barbara City College • RP Group Research and Planning Conference • April 2014

4. 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… Santa Barbara City College • RP Group Research and Planning Conference • April 2014

5. What I really want to know is... • 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... Santa Barbara City College • RP Group Research and Planning Conference • April 2014

6. Ahhh... the last report I’ll need to write... Santa Barbara City College • RP Group Research and Planning Conference • April 2014

7. What I really want to know is... Santa Barbara City College • RP Group Research and Planning Conference • April 2014

8. It’s not like we don’t have the data… Santa Barbara City College • RP Group Research and Planning Conference • April 2014

9. Dashboards! Maybe we need… Santa Barbara City College • RP Group Research and Planning Conference • April 2014

10. Business Intelligence Where is the WISDOM we have lost in the KNOWLEDGE? Where is the knowledge we have lost in the INFORMATION? Santa Barbara City College • RP Group Research and Planning Conference • April 2014

11. Where is the “Knowledge”? Santa Barbara City College • RP Group Research and Planning Conference • April 2014

12. The Knowledge begins to emerge… Santa Barbara City College • RP Group Research and Planning Conference • April 2014

13. Edward Tufte Santa Barbara City College • RP Group Research and Planning Conference • April 2014

14. Stephen Few: ThePerceptual Edge.com Santa Barbara City College • RP Group Research and Planning Conference • April 2014

15. We evaluated the usual suspects… Eventually Gartner led us to Tableau… Santa Barbara City College • RP Group Research and Planning Conference • April 2014

16. Tableau? Qu'est-cequec'est? Tableau: noun: tableau; plural noun: tableaux Agroup of models or motionless figures representing a scene from a story or from history; a tableau vivant…. Synonyms: picture, painting, representation, illustration, image… Santa Barbara City College • RP Group Research and Planning Conference • April 2014

17. Recreating a Living Picture of a historical event… The Original The recreation… Santa Barbara City College • RP Group Research and Planning Conference • April 2014

18. The Raft of the Medusa (1819) by Géricault Santa Barbara City College • RP Group Research and Planning Conference • April 2014

19. The recreation… Santa Barbara City College • RP Group Research and Planning Conference • April 2014

20. Santa Barbara City College • RP Group Research and Planning Conference • April 2014

21. Santa Barbara City College • RP Group Research and Planning Conference • April 2014

22. The Live Demo Goes Here Santa Barbara City College • RP Group Research and Planning Conference • April 2014

23. SBCC Data Warehouse Santa Barbara City College • RP Group Research and Planning Conference • April 2014

24. For more information: Questions? Robert Else else@sbcc.edu 805-897-3522 www.tableausoftware.com Jordan Morris jcmorris2@sbcc.edu 805-965-0581 x3029 Santa Barbara City College • RP Group Research and Planning Conference • April 2014

25. In case of Demo-God intervention, break glass and use these slides… Santa Barbara City College • RP Group Research and Planning Conference • April 2014

26. Tableau Live Demo: Course Fill Rates Santa Barbara City College • RP Group Research and Planning Conference • April 2014

27. Tableau Live Demo: Student Pathways Santa Barbara City College • RP Group Research and Planning Conference • April 2014

28. Tableau - Student Demographics Santa Barbara City College • RP Group Research and Planning Conference • April 2014

29. Tableau Live Demo: Assessment Placement Santa Barbara City College • RP Group Research and Planning Conference • April 2014

30. Tableau Live Demo: Cohort Comparisons Santa Barbara City College • RP Group Research and Planning Conference • April 2014

31. Tableau Live Demo: Grades Heatmap Santa Barbara City College • RP Group Research and Planning Conference • April 2014

32. We set out to reproduce this study using our own data… Santa Barbara City College • RP Group Research and Planning Conference • April 2014

33. Work in Progress: Reproducing the CCRC study “Intensity and Attachment” (Crosta 2013) Santa Barbara City College • RP Group Research and Planning Conference • April 2014

34. More Crosta (2013) Santa Barbara City College • RP Group Research and Planning Conference • April 2014

35. Visit the Tableau Public Gallery http://www.tableausoftware.com/public/gallery RP Group Research and Planning Conference • April 2014