ODS (Operational Data Store) and EDW
Download
Report
Transcript ODS (Operational Data Store) and EDW
ODS / EDW Project
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
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?
ODS = Operational Data Store
Used for Operational reporting
Ad-hoc reporting
More flattened data than Banner
ODS
EDW = Enterprise Data Warehouse
More Aggregated data
Snapshots of data
Used for Analytics and Trend reporting
EDW
RAP = Recruitment & Admissions
Performance
SRP = Student Retention Performance
Integrate with BRM
Pre-developed reports from Ellucian that
utilize EDW
RAP & SRP
When?
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?
Project web site:
http://oregonstate.edu/is/projects/odsedw
Contact: [email protected]
Phone: 737-5981
More info