Employee Demographics

Purpose

This dashboard will help you discover and explore the demographics of employees in ALVSCE. It supports our Foundational Strategic Intent and the University’s core values. 

Updated 12/05/24, next update beginning of Spring term.

Information

How to Use the Dashboard

  • You may need to Sign-In to ABOR BI before beginning
  • The tabs at the top can be used to select different views
  • Use the filters in the right-hand pane to limit the results further

Known Issues

  • The dashboard filters are still being developed to work with the hover-over tooltips.

Questions & Concerns

Definitions

Generation

This is a modified definition based on the Pew Research Center's definitions of the generations.  The modification is on Millennials to span 1981-1999 instead of 1981-1996 which affects Generation Z to begin 1999 instead of 1996.

Unit

The Unit Group and Unit Label is dependent on the Employee Group.  This is important for faculty in administrative roles; their unit will be the unit of their ALVSCE professorship. 

Employee Group: Faculty

Faculty is comprised of administrators and leaders in addition to core faculty. The Faculty Type and Faculty Rank is derived from the faculty member's primary professorship title where applicable/available or by their primary faculty title.

Employee Group: Student Employees

This is a grouping comprised of Student Workers and Graduate Assistants/Associates. 

Employee Group: University Staff

This is a grouping following suit with UCAP that encompasses Classified Staff, Appointed (Academic and Service) Professionals (including Advisors), and Post Docs (per UHAP). 

Employee Group: Unit Leads

Unit Lead is a flag that is derived from an employee having one of the following terms in any of their titles: director, head, dean, chair, or vice president.

Tenure Group

The tenure status is derived from the title of professorship and are standard except for Non-Tenure Track which includes not just Non-Tenure Track (NTT) proper but also any other faculty member contract types (including Year-to-Year and Multi-Year). Non-Tenure Track does not include Career Track faculty, because Career Track is its own category.  Non-Tenure Track includes faculty members with titles like Research Professor, Lecturer, Instructor, and others without tenure/continuing eligibility.  

Gender

Values are limited by the system in being able to reflect gender beyond the available binary options.

Unit Lead

The field/filter named 'Unit Lead' is derived by logic, marking anyone with the following words in any of their titles as a 'unit lead': 'president', 'dean', 'head', 'director', 'chair'.

2019.04.22

  • Changed UA systems wording of "Non-Resident Alien" to "International" and added link to Foundational Goal at the top of the dashboard page

2019.04.18

  • Fixed display issues: 1) tooltip clutter; 2) tooltip sums; 3) tooltips being affected by filters; 4) changed display format from Story mode to utilizing tabs; 5) add titles to each view; 6) other minor fixes

2019.04.05

  • Updated the underlying database to support automated recurrent updates

2019.03.26

  • Added Genders and Ethnicities tab

2019.03.08

  • Created Generation2 column in order to create Total/Gender ratios in the same table as the Generation/Gender ratios
  • Changed Generation2 column name to Generation_
  • Added same Generation_ Total to the By Unit view

2019.03.07

  • Added By Unit view

2019.03.06

  • Redefined Millennials and Gen Z
  • Added legends

2019.03.05

  • Created dashboard
Select tabs below to alternate between views.
 

Options


A dialog box will appear in the dashboard to confirm the Download; you may need to scroll back up to the dashboard to click Download.

A dialog box will appear in the dashboard to confirm the Download; you may need to scroll back up to the dashboard to change content options and download the PDF.