Order Tool Dashboard

Institution specific ordering data from the Order Tool can be visualized in a Google's Looker Dashboard for Program Administrators.

The Order Tool Dashboard has three views:

View 1

This view demonstrates the amount of orders that each profile has submitted, as well as the percentages of Course Coordinators and Instructors with at least one order.

View 2

This view demonstrates the growth of orders by SIS term and shows the percentages of Course Coordinators and Instructors with at least one order.

View 3

This view demonstrates a list of all active profiles with Program Administrator permissions and Course Coordinator permissions, respectively.

Data on this dashboard is updated twice per day: at 5am EST and 3pm EST.

The following data are pulled from the Order Tool to populate the dashboard:

Column name	Data type	Definition
is_active	Boolean	If “true,” the profile is active.
is_admin	Boolean	If “true,” the profile has program administrator ordering permissions.
is_coordinator	Boolean	If “true,” the profile has at least one course coordinator ordering permission.
is_instructor	Boolean	If “true,” the profile has instructor ordering permissions.
network_id	Text	The "network_id" for a user is the identifier released by your Institutions' Identity Provider in a Single Sign-on integration. In a Shibboleth implementation, this value must be identical to the EPPN attribute released by your Institution's Identity Provider.
last_name	Text	The SIS provided last name for a user.
first_name	Text	The SIS provided first name for a user.
sis_term_id	Text	The unique and immutable SIS ID for the Term; e.g., "201890."
sis_user_id	Text	The unique and immutable SIS ID for the individual user.
profile_id	Text	The unique and immutable Profile ID for the individual user in Order Tool.
has_teaching_assignments	Boolean	If “true,” the profile has at least one teaching assignment.
order_id	Text	The unique and immutable Order ID for an individual order.

Please contact Unizin Services if you would like to set up this dashboard for your institution.