1 / 24

To Cube or Not To Cube: Is OLAP the Better Choice?

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

medwin
Download Presentation

To Cube or Not To Cube: Is OLAP the Better Choice?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. Agenda Paper # 013-2007 Who We Are Introduction Enrollment Profile Enrollment OLAP Cube Application Comparison Conclusion and Future Plans Questions and Answers

  3. 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

  4. 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”

  5. Paper # 013-2007

  6. Paper # 013-2007

  7. Paper # 013-2007

  8. Paper # 013-2007

  9. Paper # 013-2007

  10. 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

  11. 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

  12. Paper # 013-2007

  13. Paper # 013-2007

  14. Paper # 013-2007

  15. Paper # 013-2007

  16. Paper # 013-2007

  17. Paper # 013-2007

  18. 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

  19. Application Comparison At this time, both products require Internet Explorer (IE) 6.0 for full functionality Paper # 013-2007

  20. Paper # 013-2007

  21. Paper # 013-2007

  22. 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

  23. 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

  24. 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

More Related