240 likes | 1.14k Views
U NIVERSITY OF C ENTRAL F LORIDA I NSTITUTIONAL R ESEARCH To Cube or Not To Cube: Is OLAP the Better Choice? Dr. M. Paige Borden, Director and University Data Administrator Evangeline Collado, Coordinator of Computer Applications Agenda Who We Are Introduction Enrollment Profile
E N D
UNIVERSITY OF CENTRAL FLORIDA INSTITUTIONAL RESEARCH To Cube or Not To Cube: Is OLAP the Better Choice? Dr. M. Paige Borden, Director and University Data Administrator Evangeline Collado, Coordinator of Computer Applications
Agenda Paper # 013-2007 Who We Are Introduction Enrollment Profile Enrollment OLAP Cube Application Comparison Conclusion and Future Plans Questions and Answers
Introduction Paper # 013-2007 • Enrollment Profile • Dynamic web-based application • Utilized Base SAS® and SAS/IntrNet® software technology • Various “views” of headcount numbers and percentages • Enrollment OLAP Cube • OLAP - On Line Analytical Processing • Provides pre-summarized dimensional data in a user-friendly, drill-down environment • On-the-fly customized reports and charts
Enrollment Profile Paper # 013-2007 Headcount by college, undergraduate vs. graduate, full-time vs. part-time status, gender, ethnicity, residency, classification, and major Replaced and enhanced numerous hard copy reports User-friendly, dynamic and interactive environment More than 30 different tabular displays Menu or drill-down accessibility to “views”
Enrollment Profile - Maintenance Paper # 013-2007 • Two full days of programmer time • Update data • Oracle to Microsoft Access to SAS® data set • Cleanse, validate, and transform • Programmatically calculate trend statistics • Program maintenance • Change default values each term • Modify formats when new colleges and/or majors added • Alter JavaScript for navigation menu changes • Special maintenance for software upgrades
Enrollment OLAP Cube Paper # 013-2007 • Data Extract • Enrollment fact table created from warehouse dimension tables • SAS® Enterprise Guide® used to build table • SAS OLAP Cube Studio • Client tool of the SAS® Enterprise Business Intelligence (BI) Server Suite • User-friendly, graphical interface to create and maintain OLAP cubes • Multiple Tools to View Cube • SAS client tools • Microsoft Office products
Enrollment OLAP Cube - Maintenance Paper # 013-2007 Run job in Enterprise Guide to update fact table Rebuild the cube in SAS® OLAP Cube Studio Update generated information map if necessary
Application Comparison At this time, both products require Internet Explorer (IE) 6.0 for full functionality Paper # 013-2007
Conclusion and Future Plans Paper # 013-2007 • Benefits of OLAP • Improved functionality • End-user flexibility of reporting • Less maintenance • Future Plans • Augment Enrollment cube with current data • Create additional cube for degrees granted • Convert other current applications to OLAP
How to Contact Us Paper # 013-2007 • Office of Institutional Research • Email: iroffice@mail.ucf.edu • Web: http://www.iroffice.ucf.edu • Address: P.O. Box 160021, Orlando, FL 32816-0021 • Phone: (407) 823-5061 Fax: (407) 823-4769 • Paige Borden: mborden@mail.ucf.edu • Angel Collado:ecollado@mail.ucf.edu
UNIVERSITY OF CENTRAL FLORIDA INSTITUTIONAL RESEARCH To Cube or Not To Cube: Is OLAP the Better Choice? Dr. M. Paige Borden, Director and University Data Administrator Evangeline Collado, Coordinator of Computer Applications