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


  • 779 Views
  • Uploaded 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

PowerPoint Slideshow about 'To Cube or Not To Cube: Is OLAP the Better Choice?' - medwin


Download Now 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
to cube or not to cube is olap the better choice

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
Agenda

Paper # 013-2007

Who We Are

Introduction

Enrollment Profile

Enrollment OLAP Cube

Application Comparison

Conclusion and Future Plans

Questions and Answers

introduction
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
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
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
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
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
Application Comparison

At this time, both products require Internet Explorer (IE) 6.0 for full functionality

Paper # 013-2007

conclusion and future plans
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
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
to cube or not to cube is olap the better choice24

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