Student Data Warehouse Training (last updated 12152010).ppt

* * * * * Show in BusinessObjects * * * Sample query – Liberal Arts majors by class. This might be a good time for a BREAK! Show video during data overview. * * Students with Liberal Arts majors by class code. * * * * * * * * * * Student Data Warehouse Training (last updated: 12/15/2010) “Some day, on the corporate balance sheet, there will be an entry which reads Information; for in most cases, the information is more valuable than the hardware which processes it.” - Grace Murray Hopper Training Schedule Part 1 - Lecture demo Data Warehouse Background Overview Query Tools Architecture Terms and Definitions Student Data Overview Using Corporate Documents Building a Query and Report in BusinessObjects Part 2 - Hands-on in lab work through 5 or 6 exercises in the lab Background What is it? Central warehouse for student, course, enrolment data Does not replace existing systems Unlimited report building capabilities How did we get here? Student data warehouse completed in 1998 Started capturing data in Fall 1997 Entire/natural connection downloading Data Warehouse Overview Data is organized for ad-hoc, reporting access not transaction processing Snapshots at various points in time Easy access with query tools Retention of additional historical data Students enrolled from Fall 1997 onward All of the WSU transcripts for them (even prior to 1997) Does not replace existing systems, but provides another way to access the data from them. Flow of Data Online Phonebook (email addresses) OARS UNAF (addresses) SRTS STUDENT DATA WAREHOUSE END USER (YOU) WSU ORG Sources of Student Data OARS - Student Records System Student academic, demographic data Traditional enrollments and DDP (EUS) Course/Section data Other supporting data SRTS - Transcript System Student Transcripts - gpas, credits Student Transcript Details - courses, grades Other Sources of Data Online Phonebook student email addresses (email forwarding) UNAF - Universal Name and Address File mailing, home, pare