130 likes | 290 Views
Enrollment Management Unified Report (EMUR). Indiana University of Pennsylvania Jeff Montgomery. Presentation Goal. To provide an overview of IUP development of an Enrollment Management Unified Report. This project is IN PROGRESS . About IUP. 14,000 students; 1,800 employees
E N D
Enrollment Management Unified Report (EMUR) Indiana University of Pennsylvania Jeff Montgomery
Presentation Goal • To provide an overview of IUP development of an Enrollment Management Unified Report. • This project is IN PROGRESS
About IUP • 14,000 students; 1,800 employees • Largest Member, SSHE • 3 campuses; 1 center; 1 academy • Doctoral I • Clock-hour programs
Banner at IUP • Live with 8 baseline modules and 6 Self Service products since 2000. • Banner 7.x – October 2005 • Oracle 9i Database • Oracle Application Server 10g • Sun Solaris – DB servers • INB Servers (4)
Topics? • Why build EMUR? • For Whom? • How to build EMUR? • Challenges • Results
Why build EMUR • Report accuracy • Consistent methods for retrieving results • User knowledge of data • User Training • Maintenance nightmare
For Whom? • Technology Staff • Admissions internal users • Undergraduate; Graduate; Culinary; Continuing; Honors College; Branches • Admissions customers (ex. Colleges; Branches) • Senior Staff
How to build EMUR? • Meet with Admissions staff and Senior staff • What are the questions? • Identify tables/fields to answer questions • Warehouse methodology
Warehouse methodology Banner Production Database – The “REAL DATA” Data Warehouse Staging Database – “time to transform” Data Warehouse Reporting Database – “User Friendly” User ad-hoc and canned reporting
Challenges • Consolidating the questions • Researching the tables/fields • Criteria – attributes, source, contact codes, etc.. • Data processing standards • Training Technical and Users on reporting • Banner 7 upgrade during implementation
Results • Still in progress… • Admissions pieces of EMUR • Planning for Enrollment pieces of EMUR • Reporting Tools: MS Access & Discoverer
Questions? Jeff Montgomery, IUP jmontgom@iup.edu
In Closing • Complete Conference Evaluation • Join PA Bug listserv • Get involved!