to cube or not to cube is olap the better choice l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
To Cube or Not To Cube: Is OLAP the Better Choice? PowerPoint Presentation
Download Presentation
To Cube or Not To Cube: Is OLAP the Better Choice?

Loading in 2 Seconds...

play fullscreen
1 / 24

To Cube or Not To Cube: Is OLAP the Better Choice? - PowerPoint PPT Presentation


  • 800 Views
  • Updated on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


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