1 / 11

Graduate Admissions Data Mart

Graduate Admissions Data Mart. Tom Leventhal. Graduate Admissions Data Mart. Purpose: Track applications for Graduate Admissions Modified version of Virginia Tech model. Why Use Data Marts?. Banner is a relational database and is hard to navigate

arella
Download Presentation

Graduate Admissions Data Mart

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. Graduate Admissions Data Mart Tom Leventhal

  2. Graduate AdmissionsData Mart • Purpose: Track applications for Graduate Admissions • Modified version of Virginia Tech model

  3. Why Use Data Marts? • Banner is a relational database and is hard to navigate • Data Marts are in a star schema form making them much easier to use

  4. Banner Complex

  5. Star Schemas Easy Dimension Table Dimension Table Dimension Table Graduate Fact Dimension Table Dimension Table Dimension Table Snowflake Tables

  6. Data Mart Structure • Star Schema: Fact table, Dimensions • Type 2 dimensions -- changes reflected by creating new records and making existing records historical • Snowflake tables exist to track such items as • Applicant addresses • Prior college • Test scores • Ability to track enrolled status of applicant • For the applicant in general (regardless of app) • By specific application

  7. Data Mart History • History kept in all dimension and fact tables • History tracked by using three fields: • EFF_FROM_DATE - Date a row is created • EFF_TO_DATE - Either the date that a row is replaced or the date 12/31/9999 • HISTORY_IND: • NULL - row is current • ‘Y’ - row is historical

  8. Graduate Admissions Model

  9. Data Marts Status • Incremental builds occurring on a daily basis • Set up in Discoverer • Currently resides in DMSQ. Will be moving data mart to DMSP this week

  10. Reporting Tools • Provide an easy way to report against data mart without having to understand the underlying joins • Discoverer: A reporting tool supplied by Oracle. • Cognos: Very powerful reporting tool • Will be set up in Cognos in the future

  11. Questions

More Related