SAH-MajorMinorDetail-View Quick Start Guide
Add yourself as a Watcher to this page to be automatically emailed with any changes to this page.
This page assumes you have read https://ucsdcollab.atlassian.net/wiki/spaces/ACP/pages/11175032 and https://ucsdcollab.atlassian.net/wiki/spaces/ACP/pages/11174380
Overview
The following article is a start guide for those using demographic 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
- Current, Historical, and First ever records of students activities and information joined with SAH-Demographics-View and SAH-StudentStudentsStatsPerTerm-View
Majors and Minors
- Detailed information about students major/minor.
- This view only includes students who have either changed their major / minor or have requested program changes and does not represent a full listing of students in a given major.
- Which college and program they were enrolled or have switched to
- No census data is available for this view
Step to Take
Key Fields to View
- From Program
- To Program
- Major Minor Change Date
Key Fields to Filter On
- Registration Status = 'Enrolled', 'Registered'
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.