1 / 15

Overview to Discoverer

Overview to Discoverer. Overview to Student Data Mart. Data Mart Goals. Integrate multiple data sources into single repository Apply agreed-upon business rules for consistent interpretation of data Provide access to commonly requested data Track historical data for point-in-time comparisons.

zelda
Download Presentation

Overview to Discoverer

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. Overview to Discoverer Overview to StudentData Mart

  2. Data Mart Goals • Integrate multiple data sources into single repository • Apply agreed-upon business rules for consistent interpretation of data • Provide access to commonly requested data • Track historical data for point-in-time comparisons

  3. Banner = Complicated Subject Term Course Level Section Registration Name Meeting Pattern Instructor Room Building

  4. Data Mart = Easy Term Dimension Subject Dimension College Dimension Section Fact Level Dimension Department Dimension Status Dimension

  5. Data Mart Structure • Star Schema: related fact and dimension tables for each subject area • Student Enrollment • Course Enrollment • Registration • Degrees • Views: combine two or more fact and dimension tables • Enforce college/department security • Combine data from multiple stars

  6. Data Mart Structure • Facts: subject area metrics • Section capacity • Actual enrollment • Generated hours • FTE • Dimensions: subject area qualifiers • Term • Campus • College

  7. Student Data Mart Model Student Enrollment Star Course Enrollment Star

  8. 3 Components of SDM • Student & Registration (STU): • Student Bio & Demo information. The Student information in the data mart is restricted to directory information. To request sensitive information like SSN, Age, Gender etc you will have to go to the registrars office. • Registration Star will provide information related to student course registration such as registered hours and grades. • Enrollment ( ENR) • Enrollment Star provides Course Scheduling. • Degree ( DEG) • Degree Star will provide graduation status, degree status, honors etc.

  9. Student / Registration Enrollment Star Major Student Level Date Reg Status Term Degree Program Student Fact Registration Fact College Department Domicile Grade Mode Campus Student Type Student Status Student

  10. Reports – Student & Registration Star • STU Enrollment Summary • STU Academic Standing • STU Registration Eligibility • STU Unsatisfactory Grades • STU Unsatisfactory Mid Term Evaluations • STU Incomplete Grades

  11. Course Enrollment Star (ENR) Date Term Location College Meeting Pattern Section Enrollment Department Subject Campus Part of Term Course Section Schedule Type Course Level Course Status

  12. Reports – Course Enrollment Star • ENR Course Enrollment Summary • ENR Analyzing Meeting Patterns • ENR Schedule of Classes

  13. Degree Enrollment Star (DEG) Degree Status Program Grad Status Term Degree Fact Degree Level Level Department Dim Date College Major Degree

  14. DEG Degree Conferred • DEG Graduation Status • DEG Students Graduating with Honors

  15. Data Mart Status • Release 1 – Student Enrollment (June 2007) • Release 2 – Course Enrollment (July 2008) • Release 3 – Registration (Jan 2009) • Release 4 – Degrees (Jan 2010) • Release 5 – Snapshot and Census (tbd)

More Related