Enhancing Data Analysis for Clemson University's Fact Book
Exploring the implementation of Tableau Server for presenting Clemson University's Interactive Fact Book, including considerations for data accuracy, design consistency, and improved navigation. The report covers insights on data preparation, retention, graduation, and the importance of communication in the process.
Uploaded on Jul 27, 2024 | 0 Views
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
Clemson University Interactive Fact Book South Carolina Association for Institutional Research January 28-29, 2019 Greenville, SC Juan Xu Joe McLaughlin Melissa Welborn Ronnie Chrestman
Overview Background Standing on the Giants Shoulders Considerations for the New Fact Book Retention and Graduation Data Preparation The Reports A Demo Discussions and Future Improvements
Background Purchase of Tableau Server Decision to Present Fact Book Using Tableau Vendor Solution and User Feedback What did it look like from the Vendor? (from Tableau Server or a picture) Major Feedbacks: Trend and student profile for a specific year combined in one page, overwhelming, difficult to navigate The Decision to Make Continue with the Vendor (Pros and Cons) Self-Reliance (Pros and Cons) Communication, Communication, and Communication!
Standing on the Giants Shoulders What we have Aggregated data tables ideal for fact book An introduction of the data tables in My SQL server Existing fact book using PHP programming (sample page) Draft tableau fact book TOC design, established links to my SQL database, ready-set data calculations and value labels Similar products from peers Community of Tableau Learners
Standing on the Giants Shoulders (Cont.) What we need to have Revised Presentation Longitudinal overview Retention/Graduation Improved Navigation Data Definition Bottom line: Building on the team s experiences and strength
Considerations for the New Fact Book Design stage Accuracy Consistency Flexibility KISS Systematic Updates FERPA Posting: Tableau Server or Tableau Public
Retention and Graduation Background Data preparation Data Source - Student Enroll and Completions files that had been previously submitted to the South Carolina Commission on Higher Education Over 49,000 records of entering students Fall 2009-Fall 2018 including Spring Terms Over 290,000 student returning records Over 33,000 graduation records
Retention and Graduation-Cont. What do we track? 1stYear to 2ndYear Retention 2ndYear to 3rdYear Retention 2-Year Graduation Rate 3-Year Graduation Rate 4-Year Graduation Rate 5-Year Graduation Rate 6-Year graduation Rate
Retention and Graduation-Cont. Comparison Data First Time Freshmen Under Represented Minorities vs. Non-Under Represented Minorities In-State vs. Out-of-State First Generation College vs. Non-First Generation College Transfer Students South Carolina Technical College Transfers vs. Non-South Carolina College Transfers Bridge Students vs. Non-Bridge Students College Level Department Level
Retention and Graduation-Cont. The Report Key Features Limited Parameters Institutional Flexibility Rate and Cohort Numbers
A Demo Key Features Navigation to Main Page Reset Filters Uses Both Tables and Graphs Treatment of Small Cells Continuous Improvement
Discussions and Thoughts about Future Improvements Discussions: Mask Small Cells? Future Considerations: Profile on Employee Reports A Different Look for Table of Content? Inclusion of Financial Information Acknowledgements: The Whole IR Team Support from Other Departments Peer Institutions
Questions? Thanks! Contact information: Juan Xu, PhD Director, Office for Institutional Research Clemson University jxu2@clemson.edu (864)656-0585
