SAH-CourseAssociationNarrow-View Quick Start Guide

SAH-CourseAssociationNarrow-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 SAH Quick Start Guides and SAH Core Views Quick Start Guides

Overview


  • The SAH-CourseAssociationNarrow-View focuses on Course relationships and Course versions.

  • This view does NOT include Student PID or student level data.

  • This view includes ALL courses, even those with no associations.

Critical Concepts


Associations

  • Courses can be associated to other courses for a variety of reasons.

  • A course can have multiple types of associations.

  • A course can have multiple associations per Association Type.

Course Subject Code and Number

Associated Course Subject Code and Number

Association Type

Course Subject Code and Number

Associated Course Subject Code and Number

Association Type

BENG 128B

BENG 128A

Prerequisite

BENG 187C

Corequisite

Term Sets

  • Both Term Sets are for the Course

Steps to Take


Key Fields to Display

  1. Association Type

  2. Course Subject Code and Number / Course ID

  3. Associated Course Subject Code and Number

Key Fields to Filter on

  1. Association Type

  2. Course Subject Code and Number / Course ID

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.

Folder

Measures

Key (Uniqueness / Group By)

Folder

Measures

Key (Uniqueness / Group By)

 

 

 

 

If you still have questions or need additional assistance, please submit a ticket or email busintel@ucsd.edu