Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This view is NOT joined with:

  • SAH-Demographics-View 
  • SAH-StudentStudentsStatsPerTerm-View

...

Table of Contents


Warning
titleRequired Reading

This page assumes you have read (1) SAH Quick Start Guides and (2) SAH Restricted Views Quick Start Guide.


Overview


  • Information about the instructors and the class sections

...

Since here might be are more than one instructor per class section, then there might be more than one row per class section. 

...

  • associated with them
  • In general this view shows you all the class section associated with any instructor. If an instructor has multiple class sections per term, all class sections associated with that instructor would be visible in a given term.

Excluding:

  • Waitlist or transfer records
  • Previous terms / historical records

Granularity:

  • Instructor and Class Section

Key Fields:

  • This view is NOT joined with SAH-Demographics-View or SAH-StudentStudentsStatsPerTerm-View
  • Instructor most prominent job appointment - This does NOT include all the appointments associated with instructors who have more than one job appointment
  • Currently does NOT include Waitlist or Transfer records and Previous terms / historical records

Other Resources


Critical Concepts


Course and Class Sections

  • Course folder: includes all fields related to a Course
  • Class Section folder: includes all fields related to the Class Section
  • In this view there may be more than one instructor per class section, then there might be more than one row per class section. 

Departments

  • Course related departments will be labeled as 'Course Department...'
  • Instructor related departments are located in the Department folder.
  • The Department hierarchy only relates to the Instructors and this information comes from the Employee Activity Hub

Instructor Employee Information

  • Instructor employee information (position, job, department) comes from the Employee Activity Hub based on their teaching positions.  This means an instructor can have multiple positions, creating multiple rows.


Key Fields

...

Folder

...

to View


  • Instructor Information 
  • Class Section Information

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.

Note

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.