740 likes | 916 Views
- Data Analytics - January 2013 – QA Institute Leah Lommel, Assistant Vice President Information Technology, Arizona State University. Desired Learning Outcomes. Desired Learning Outcomes of P resentation. Learn How to Become a Data-Driven Institution
E N D
- Data Analytics -January 2013 – QA InstituteLeah Lommel, Assistant Vice PresidentInformation Technology, Arizona State University
Desired Learning Outcomes of Presentation • Learn How to Become a Data-Driven Institution • Learn about Higher Education Computer Systems That Help Capture Data • Learn about Data Warehousing Concepts, Benefits and Value • Learn about Dashboards and How They Make Consumption of Information Easier • Learn How Information Can Help Student Success • Learn Best Practices for Analytics • Have Some Dialog with Presenters and Ask Lots of Questions
downtown phoenix campus ASU campuses
west campus ASU campuses
polytechnic campus ASU campuses
tempe campus ASU campuses
ASU is Largest Institution in U.S. *Undergraduate
ASU Leaders Rely on Data Daily Dr. Elizabeth Phillips Provost of ASU Creator of eAdvisor Dr. Morgan Olsen CFO of ASU Data Driven Dr. Michael Crow President of ASU One of “America’s Top 25 Thinkers”
History of ASU Analytics • First University to Build Meaningful Data Warehouse (1992) for Reporting • First University to Start Build Meaningful Dashboards/Scorecards (2005) • First International Presentation on ASU’s Analytics – Vietnam (Dec. 2012)
ASU’s Analytics Featured in Book ASU’s Dashboard are Featured in Chapter of this Book From ASU’s Dashboard Information Dashboard
ASU is Measured by Board of Regents http://www.azregents.edu
Data Warehouse Definition • SUBJECT-ORIENTED • INTEGRATED • TIME-VARIANT • NON-VOLATILE collection of data in support of management’s decision making process. -Bill Inmon, Inventor of Data Warehouse-1990s
What’s Needed to Build One • Separate Database to Store Data • ETL (Extract/Transform/Load) Process • Move Data to Data Warehouse • Reporting/Visualization/Dashboard Tools • Helps with Reporting/Analysis/Data Mining
Why Build a Data Warehouse? • Powerful Data Source for Reporting • Integrates Data from Separate Computer Systems • Keeps Historical Data/Assists Longitudinal Studies • Operational Systems Performance Not Impacted by Queries Against It • Both Strategic and Tactical for Reporting • Helps Assessment and Student Retention
Data Put Into Data Warehouse PRIMARY SUPPORT SPECIAL DICTIONARY USER_TABLE STUDENT FINANCIAL HUMAN_ RESOURCE LOOKUP SRC COURSE CENSUS DARS PERSON DIRECTORY_ SERVICES FINANCIAL AID STUDENT FEES RESEARCH FACILITY PROPERTY ETC. TRAINING(*) STUDENT_ RETENTION WAREHOUSE_ ADMIN PROXY DBs March 1, 2002
Warehouse Helps Build Reports • Admission Dashboard
“Dashboard” Defined A dashboard is a report interface that, somewhat resembling an automobile's dashboard, organizes and presents information in a way that is easy to read and understand.
ASU Dashboards http://dashboard.asu.edu
Monitoring Class Enrollment From ASU’s Course Enrollment Management Dashboard
Pre-Enrollment Tracking From ASU’s Undergraduate Dashboard
Information on Instructors From ASU’s Faculty Dashboard
Faculty Doing Instruction and Research From ASU’s Faculty Dashboard
Single Version of Truth Research Data From ASU’s Research Dashboard
Financial Account Information From ASU’s Financial/SuperReportDashboard
Early Warning/Retention Tool From ASU’s Retention Dashboard