ODS / EDW Project - PowerPoint PPT Presentation

chipo
ods edw project n.
Skip this Video
Loading SlideShow in 5 Seconds..
ODS / EDW Project PowerPoint Presentation
Download Presentation
ODS / EDW Project

play fullscreen
1 / 11
Download Presentation
155 Views
Download Presentation

ODS / EDW Project

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. ODS / EDW Project

  2. Replace existing data warehouse with Ellucian’s ODS / EDW • Install 2 new components: RAP & SRP • Replace BI Query tool with Cognos reporting tool Project Overview

  3. Current data warehouse structure doesn’t meet the complex reporting needs of the University • Additional Banner data in the data warehouse • Improved reporting tool with new features and functions • More robust, improved reporting including dashboards • Reporting from BRM (Banner Relationship Management) Why?

  4. ODS = Operational Data Store • Used for Operational reporting • Ad-hoc reporting • More flattened data than Banner ODS

  5. EDW = Enterprise Data Warehouse • More Aggregated data • Snapshots of data • Used for Analytics and Trend reporting EDW


  6. RAP = Recruitment & Admissions Performance • SRP = Student Retention Performance • Integrate with BRM • Pre-developed reports from Ellucian that utilize EDW RAP & SRP

  7. When?

  8. Identify reports used in the existing data warehouse • Identify / inventory your department’s reports • Work with us, as needed, to identify report requirements for existing reports What do we need from you?

  9. Project web site: http://oregonstate.edu/is/projects/ods-edw • Contact: Diana.Lindsley@oregonstate.edu • Phone: 737-5981 More info