1 / 20

Using SAS to Create Dynamic Web Sites

Today's Topics. BackgroundTaskMethodCourse Registration ProfileEnrollment ProfileOther ActivitiesQuestions. Background. Senior Administration: Need for better" access to data and informationA data warehouse???Planning

ernie
Download Presentation

Using SAS to Create Dynamic Web Sites

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. Using SAS® to Create Dynamic Web Sites Sabrina Andrews Evangeline Collado University of Central Florida FAIR Conference July 18, 2002

    2. Today’s Topics Background Task Method Course Registration Profile Enrollment Profile Other Activities Questions

    3. Background Senior Administration: Need for “better” access to data and information A data warehouse??? Planning & Evaluation team Academic Affairs Statistics Business PeopleSoft Implementation Charge to develop 3 prototypes Addressing unmet university needs

    4. Task 3 prototypes Static web site with quick facts, trends and comparisons (HTML) Institutional Dashboard (Crystal) Data Mart (SAS) Objective: Develop a management information system for use in planning, decision making, and evaluation Easily accessible – Understandable Graphical – Clearly defined

    5. Methods – Static HTML web site

    6. Methods – Static HTML web site

    7. Methods – Static HTML web site

    8. Methods – Static HTML web site Advantages Aesthetically pleasing High quality graphs More control Disadvantages VERY labor intensive Limited term data

    9. Methods – SAS® IntrNet

    10. Methods – SAS® IntrNet

    11. Methods – SAS® IntrNet Advantages “Interactive”/User control Graphical Capability More user options Less programmer time to maintain Disadvantages Look and feel of “generated” tables and graphs Less control over data sources

    12. Meeting the Unmet University Needs PeopleSoft reporting Access to the data Users unrest Responding to user needs Course Registration Profile Enrollment Profile

    13. Course Registration Profile Background Originated as planning tool for Dr. Taylor Ellis in the College of Business Static web pages were created daily and stored on local machine Course information, e.g., prefix, number, etc., was entered manually into programs High maintenance required

    14. Course Registration Profile Tasks Create a planning tool to provide registration information for university community Give user control of information access Create historical data file for future trend comparisons DEMO

    15. Course Registration Profile Feedback & Future Enhancements Favorably received by college faculty, administrators and schedulers Enhancements based on user feedback Retrieve data directly from PeopleSoft using SAS/ACCESS® Overlay previous year’s data on trend plot for comparisons

    16. Enrollment Profile Background Faculty & staff want to see enrollment statistics during 1st week of classes Replicate University headcount reports generated each semester One-click access to total university headcount

    17. Enrollment Profile Tasks Create dynamic access to current and historical headcount numbers and percentages Give user capability to see headcount statistics by college, major, gender, ethnicity, classification, and course load Show enrollment trends DEMO

    18. Enrollment Profile Feedback & Future Enhancements Faculty & administrative staff are using the site frequently Enhancements made based on user requests Collect data from RDS instead of legacy data bases for current enrollment Additional views – replicate/replace some hard copy reports (e.g. geographical report)

    19. Other Activities PeopleSoft RDS Development Executive Dashboard Development Query Library Development PeopleSoft Portal Architecture for data warehouse

    20. Questions

More Related