Versions Compared

Key

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

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 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.
  • 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 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.