Faculty Info for Surveys

Pull data to assist with survey questions, include Tippie course information from the previous full academic year through to current semester. HR data is incorporated for the instructors including employee ID, UID, Rank and FTE. Uses last day snapshot for previous semesters and daily snapshot for current semester.

Scope

Academic Sessions - Pull the previous full academic year through to current semester.
HR Data - Pulls the current or most recent position in Tippie org within the last year prioritizing faculty positions.
Courses - Pull courses for Tippie college where we are the subject admin. Exclude courses with course section management type “WORKSHOPCCP”. Instructor roles are filtered to include only primary instructor or team teacher.
Degrees - Used to indicate terminal degrees for instructors, values are only displayed if the degree was either an MBA, JD or PhD. Focus on subject areas was not included. If an instructor has obtained multiple, they will be concatenated (e.g. “MBA, PhD” or “PhD, PhD”).

Security

This report was built for the use by Tippie HR staff and contains sensitive information. Data from this report is for internal use only and should only be disbursed with HR’s discretion.

Scheduled Refresh

Saturday at 10:30 am

Mechanics

Slicers - These are dropdown filters (parameters) which will filter all visuals on the page.

• Semester

  • Options will include semesters from the previous full academic year through to current semester.

• Employee Type

  • Options: Faculty (Adjunct, Clinical Track, Emeritus, Instructional Track, Tenure Track, Tenured, Visitor), Graduate Research Assistant, Graduate Teaching Assistant, & Staff.

• Course Section Management Type

  • Options: ACADEMICUNIT, BUSN_ANALYTICS, CIMBA, EXTCREDITPGMS, MBA_CIMBA, MBA_EXEC, MBA_EXEC_ON_CAMP, MBA_PM

Bookmarks - Feel free to utilize personal bookmarks which allows you to save specific filtering you may use frequently. This is available in the upper right-hand corner on the blue/teal ribbon. If you find things are being remembered or saved automatically and you wish to reset this, click on the curly arrow to reset any settings Power BI Service may have remembered. This is separate from personal bookmarks which have to be specifically added/deleted.

Visuals

Cards - dynamic values will change based on the selected criteria in the slicers.

• Courses

  • Provides a distinct count of courses (sections).

• Instructors

  • Provides a distinct count of instructors who’ve taught a course.

• Instructors w/ Terminal Degree

  • Provides a distinct count of instructors who’ve taught a course and have at least one terminal degree (MBA, JD, PhD).

Tables

• Counts by Semester & Course Section Management Type

  • Provides distinct counts of courses and instructors broken out by semester per course section management type. Includes academic year subtotals. If an instructor taught courses in more than one course section management type, they will be counted once for each. The bottom totals reflect a distinct count across all course section management types.

• Instructor Ct Full/Part Time

  • Provides distinct count of instructors who are full or part-time. Totals on the right provide distinct count of instructors for the semester. Bottom totals provide distinct count of instructors for each group across all semesters selected.

• Instructor Detail by Semester & Course Section Management Type

  • Provides a list of instructors for each semester and course section management type and course counts. Includes HR data such as employee id, UID, rank, full or part-time status and FTE.

Terms

Exports

Hover over the object you wish to export. You’ll notice a bar will appear, click the “…”.

Open

• Click “Export data”.

Open

• Select “Data with current layout” option and click “Export”. Save to a desired location.

Open