SAH-MajorMinorNarrow-View and SAH-MajorMinorNarrowCensus-View Quick Start Guide
- De Silva Jayasinghe, Kevin (Deactivated)
- Saparnell
Add yourself as a Watcher to this page to be automatically emailed with any changes to this page.
This page assumes you have read SAH Quick Start Guides and SAH Core Views Quick Start Guides
Overview
The following article is a start guide for those use Major Minor information from the Student Activity Hub (SAH). It includes various terms for those using the tool and tips for new users.
Critical Concepts
Pre-Joined Data
SAH-Demographics-View and SAH-StudentStudentsStatsPerTerm-View
Pre-Joined Data
All Majors / Minors of students for every term is in one field (Program / Program Code) in this view. Therefore, might see multiple rows per term per student:
Data Source | Folder: Term Set - Student Stats Per Term Field: Term Code | Student | Folder: Term Based Program Field: Program Code | Program Type | Student primary Major Flag |
SAH-MajorMinorNarrow-View | FA20 | Student 1 | P1 | Major | Yes |
SAH-MajorMinorNarrow-View | FA20 | Student 1 | P2 | Minor | Yes |
SAH-MajorMinorNarrow-View | FA20 | Student 1 | P3 | Major | No |
Steps to Take
Granularity
Granularity is the scale or level of detail present in a set of data. It identifies where levels of uniqueness exists in the data. The data lives in the view at the lowest level, but each BI tool totals the levels differently.
Please note: The Level of Detail (LOD) calculations listed here for Tableau developers are a baseline and do not necessary include all of the LOD equations needed for your report.