Transcript Slide 1
The New UC Information Center
Gaining valuable insights into the University of California using data visualizations
I NSTITUTIONAL R ESEARCH U & A NIVERSITY OF CADEMIC P LANNING C ALIFORNIA (IRAP) O FFICE OF THE P RESIDENT 2015 ETS C ONFERENCE
The Need
• • • • • Quick, clear, easy and timely access to information for communication and advocacy efforts.
Making pertinent information that concerns UC readily available to the public.
Centralized source of information; a single source of truth.
Demonstrate UC’s commitment and contributions to CA.
Address calls for accountability and transparency 5/1/2020 The New UC information Center 5-15-15 2
Vision: UC Information Center
FACULTY AND SENIOR ACADEMIC AFFAIRS ADMINISTRATORS
Attract and retain the best students
BUDGET, FINANCE & HUMAN RESOURCES
Leverage financial reporting capabilities that support compliance with internal and external requirements Analytics for recruitment and retention
PRESIDENT, PROVOST, ACADEMIC SENATE & REGENTS
Gain a strategic view of revenue streams, budgets, costs and expenses at system wide and campus level Facilitate collaborative budget preparation and execution Tie institution, academic, operational and financial performance together
INSTITUTIONAL RESEARCH
Provide evidence based guidance in strategic planning, policy and decision support
What Key Questions Does SSC Address?
5/1/2020
GENERAL PUBLIC
Learn more about the University of California The New UC information Center 5-15-15
STUDENTS & TEACHERS
Increase the likelihood of predicting student success Reduce transfer and attrition rates
Students
What is the best fit path for each individual student to take given their interest and aptitude? How can data support our efforts to help students make more informed academic decisions on their path to degree? 3
Why Use Data Visualizations?
• • • Allows the presentation of large amounts of data without being overwhelming.
Provides opportunities to glean things from data that help make better decisions, take smarter actions and operate more efficiently.
Provides one of the best ways to discern data relationships.
5/1/2020 The New UC information Center 5-15-15 4
Employed Visualization Software
• • Tableau Desktop Professional Tableau Public Premium – Easy to install and use.
– – Web analytics in minutes and not days.
Creates rich environment for discovery, collaboration and inspired analysis.
– Provides users the ability to interact deeply with data, giving the ability to add meaning and uncover hidden relationships.
– Easy to embed within UC webpages.
5/1/2020 The New UC information Center 5-15-15 5
Components of the UC IC
• • •
UC Storyboards
– Focuses on data-driven narratives that weave multiple data visualizations into a storyline.
UC Dashboards
– Quick and easy access to answers to frequently asked questions.
UC Data Tables
– Static and interactive reports that provide access to view and download data from online tables.
5/1/2020 The New UC information Center 5-15-15 6
Storyboards
Initial Mock-Up Page
Dashboards Data Tables 5/1/2020 The New UC information Center 5-15-15 7
5/1/2020
UC Storyboard
The New UC information Center 5-15-15 Story points – way to build narrative data People understand and remember concepts through stories Stories show how facts are connected and provide context 8
5/1/2020
UC Dashboard
The New UC information Center 3-26-15 Allows you to see your data more effectively Makes data make sense beautifully Makes complex data meaningful 9
5/1/2020
UC Data Table
The New UC information Center 5-15-15 Access to raw numbers Ability to slice and dice data Provides readily available data to handle repeated requests 10
Development Approach
• • Data Mart analysis, design and development.
Collaboration and partnership with other UC offices via review sessions: – Human Resources – Academic Personnel – Academic Affairs – Graduate Studies – Diversity and Engagement 5/1/2020 The New UC information Center 5-15-15 11
Data Processing (ETL)
Data Mart Development
Visualizations and Reporting Star Schema Load 5/1/2020 The New UC information Center 5-15-15 Data Marts 12
5/1/2020
Active Ongoing Collaboration
• Collaboration with other key units within UCOP and UC campuses: – To avoid multiple inconsistent views of the same data.
– To avoid sporadic development of data sharing websites.
The New UC information Center 5-15-15 13
Development Phases
• • Beta site development and deployment – – 12/19/2014 Feedback process initiated.
Production site go-live – Updates to exist visualizations.
– – Creation of new visualizations.
Categorizations to facilitate search functionality.
– – Google analytics to monitor site traffic.
Deployment to mobile devices (iPad/Smartphones).
– Enabling data download from dashboards and tables.
5/1/2020 The New UC information Center 3-26-15 14
5/1/2020
Beta Site Feed Back Process
• • • Specific email address created for feedback.
Clearly defined timeline for feedback.
Action on feedback received for production site.
The New UC information Center 3-26-15 15
5/1/2020
Live Production Site
Categorization & Search Functionalities “View More” Options The New UC information Center 3-26-15 Quick Links to Legislative Maps and Fact Sheets 16
5/1/2020
What Next?
• • • • Ongoing updates based on feedback Three planned releases per year – July 15 – Nov 15 – March 15 Acquisition and implementation of Tableau Server for enhanced security Possible integration of D3.js with Tableau The New UC information Center 3-26-15 17
Thank You for Coming!
• Questions and Comments – [email protected]
5/1/2020 The New UC information Center 3-26-15 18
Live Demo
http://www.universityofcalifornia.edu/infocenter 5/1/2020 The New UC information Center 3-26-15 19