Transcription
Tableau User GuideStudent Data Warehouse (SDW)
Table of ContentsStudent Data & Systems Use Agreement . 3What is Tableau? . 4Definition & License Information . 4Data & Student Privacy . 4Note on Race/Ethnicity & Aggregate Data . 4SDW Data . 5Getting Started . 7Logging In . 7Home Page . 7Navigating & Interacting with Content (Viewer & Explorer Licenses) . 7Navigating Screens & Reports . 7Running Reports . 7Useful Tools . 8Exporting Reports . 8Creating & Saving Workbooks (Explorer Licenses Only) . 8How to Search/Query for Data . 8Some Commonly Used Tables . 9Table Joins . 9Common Automatically Joined Fields . 10When Tables are Not Automatically Joined . 12Accessing Data Source . 13Dimensions vs. Measures . 13Continuous vs. Discrete Variables . 14Filters & Columns/Rows . 14Views (Text Tables & Charts) . 15Saving Workbooks & Views . 15SDW Database Tables Guide . 16Tables Quick Reference . 16Tables Guide . 18 ADVISOR Table . 19 ADVISOR DEPARTMENT Table. 19COLLEGE Table . 20COURSE Table . 20COURSE DROP Table . 21 COURSE PREREQ Table . 22COURSE PREREQ SYNONYMS Table . 23COURSE PREREQ TEXT Table . 24COURSE PROFILE Table. 24COURSE RESERVATION Table . 25COURSE SEMESTER Table . 26 COURSE TAG Table . 26COURSE WAITLIST Table . 27DEGREE AWARDED Table . 27DEPARTMENT Table . 29Tableau (SDW) User Guide (11/2020)University Registrar’s Office1
GRADE CHANGES Table . 30 INSTRUCTOR Table. 30MAJOR MINOR Table . 31 MEETING Table . 32 PARENT GUARDIAN Table . 32 PCHE CROSS REG Table. 33 PREREQ RESULTS Table . 34PROGRAM Table . 35 QPA Table . 36 RANK Table. 37 SCHEDULE Table. 38 SECTION Table . 39SECTION INSTRUCTOR Table . 41 SEMESTER Table . 41 SISROOMS Table. 42STUDENT Table . 43STUDENT ADDRESS Table. 45STUDENT ADVISOR Table . 46STUDENT ATHLETICS Table . 46STUDENT MAJOR MINOR Table . 47 STUDENT PHONE Table . 48STUDENT RACE Table . 48STUDENT REGISTRATION HOLD Table . 48STUDENT SEMESTER Table . 49TRANSFER CREDIT Table . 51Code Translations . 52College Codes (COLLEGE ID) . 52Department Codes (DEPARTMENT ID) . 52Major Codes (MAJOR MINOR ID) . 55 CFA . 55 CIT . 58 CMU . 60 DC . 73 HC . 76MCS . 78SCS . 80 TSB . 82Degree Codes (DEGREE ID) . 83Enrollment Status Codes (ENROLLMENT STATUS ID) . 84Entity Codes (ENTITY ID) . 84Visa Status Codes (VISA STATUS ID) . 85Tableau (SDW) User Guide (11/2020)University Registrar’s Office2
Student Data & Systems Use AgreementApplicable SystemsTh
Exporting Reports Once filters are entered and the data for the report has been generated, you can export the report Click the ‘Download’ icon in the toolbar along the top of the screen Select the option for exporting (most common below): o Image o PDF o Crosstab (CSV Excel file)
