Business Intelligence Competency Center Common View  -  Deep Understanding  -  Better Decisions

Data Landscape

Data Moved, denormalized, and restructured to target reporting databases via multiple ETL methods for more efficient reporting methods.  There are in some cases bridges between these systems to share core source data across systems:

  • Banner – Student, Financial Aid, Student Accounts Receivable
  • Unitime – Space and Academic Scheduling
  • Slate – Prospect data for student recruitment
  • SAP – HR and Finance Data
  • Advance – University Development Data
  • COEUS – Sponsored program data
  • Boiler Insight– Purdue built stars referred to as PDW for HR, Finance, Instructional Activity Cognos Usage, etc
  • Concur - Travel
  • Ariba - Procurement
Cognos Landscape
Tableau Landscape

Target Reporting Data

  • ODS (Operational Data Store) – Ellucian delivered solution making the data from Banner available for reporting via Cognos.  Primarily used for daily operational reporting after being refreshed overnight.  Also contains frozen data captured as copies of a subset of this data on key event dates such as CENSUS, and TERM_END.
  • EDW (Enterprise Data Warehouse) – Ellucian delivered solution using source data from the ODS remodeled as Fact/Dimension models and snapshots captured by dates for comparison over time.  Course Enrollment, Course Registration, Student Accounts Receivables, Admissions/Recruitment.
  • Purdue Datamarts – Purdue built Fact/Dimension models pulling from SAP HR/Finance data as well as from ODS student data.
  • COEUS – Cognos access to COEUS system replacing Brio access.  Not modeled or combined with any other data
  • UD ODS – University Development home built ODS, accessible via Cognos

Live, Frozen, Snapshots

  • Live Data  - Live data can in in few cases mean just that “live” data directly out of the source operational system.  However, from the reporting perspective it most commonly refers to the “copy” of the live data refreshed overnight of the source data from yesterday.  It doesn’t change until the next scheduled refresh, normally nightly.  Can be completely rebuilt from the source periodically as warranted
  • Frozen Data – Copy of the “live” target reporting data in its normal data structures at a point in time and does not change. Intended for official reporting so you can always get back to official numbers
  • Snapshot Data – Captured on a regular schedule (EDW, Purdue Datamarts) on a schedule to provide longitudinal comparisons over time.
  • Tableau Data – Each dashboard should describe the source and currency of the data

See the following for significant processing and data capture dates:

  • Student ODS Freeze Calendar – Coming to DataCookbook Dec 2017
  • EDW Calendar Events – Available through any of the Cognos Student EDW Packages

Purdue University, 610 Purdue Mall, West Lafayette, IN 47907, (765) 494-4600

© 2015 Purdue University | An equal access/equal opportunity university | Copyright Complaints | Maintained by BICC

Trouble with this page? Disability-related accessibility issue? Please contact BICC at bicc@purdue.edu.