- Current Demographics provide up-to-date information for faculty and staff on total headcounts (left side), gender, citizenship, veteran status, and full- or part-time status. These demographic data are updated at the end of each month. Information is provided for (1) the overall university (top row); (2) a selected college, school, VP portfolio (C/S/VP) (bottom row), or department; and (3) all units on campus other than the selected unit (middle row).
- By default the information is presented graphically. The information can be displayed as a table by clicking on the Table button in the upper right of the page.
- Query the data to answer questions
- Color Keys for the pie chart values are at the bottom of the dashboard. Hovering over a Color Key color will highlight that portion of the charts for that variable. Clicking on a Color Key color will filter all of the charts for that value. Clicking on a Color Key color a second time will revert the dashboard to its original view.
- Hover over individual pie chart sections to display relevant information such as specific headcount, percentage of total employees, and data sources.
- In the upper right corner, select the Table button to display numeric information in place of the bar and column graphs.
- Also in the upper right corner, select
to display information for each department in your C/S/VP. (If there are not any departments this symbol will not appear.) - Filters allow you to focus on specific information. This report contains several filters across the top of the pages. You can use the filters singly or in combination to refine, or “slice,” the data. Applying a filter will modify all of the graphs simultaneously. The filters are described below.
► Note that selecting a color key filters all of the charts for that value.
► Filter to view by Age Range using the dropdown menu at the top of the page. Age range allows you to focus on a specific age group. After selecting the dropdown menu by clicking on the down arrow, select All to uncheck all of the boxes, then select the age(s) of interest. Click the Apply button. You can use Age Range in conjunction with Age Increment and Generation.
- By default, age is increased by one year increments. Grouping employees in multi-year blocks (5, 10, or 20 year blocks) may be more meaningful. To change the increment amount, go to the Age Increment box next to Age Range and use the slider or > to increase/decrease the increment to 5, 10, or 20 year increments.
- Additionally, you can select employees by age Generation (i.e., Traditional, Baby Boomer, GenX, Millennials, iGen). In the Generation filter box, below Age Increment, click on the down arrow, select All to uncheck all of the boxes, then select the generation(s) of interest. Click the Apply button.
► Filter for Benefits Eligibility using the dropdown menu at the top of the page: click on the down arrow and select All, Benefits, or Non-Benefits eligible.
► Filter for Employee Type using the dropdown menu at the top of the page: click on the down arrow, select All to uncheck all of the boxes, then select the employee type(s) of interest; click the Apply button.
► Filter for Education using the dropdown menu at the top of the page: click on the down arrow, select All to uncheck all of the boxes, select the education level(s) of interest, click the Apply button.
► Filter to view by FLSA status using the dropdown menu at the top of the page: click on the down arrow, select All, Exempt, or Non-exempt.
► Filter to view by one or more Job Categories (Occupational Group) using the dropdown menu at the top of the page. After selecting the dropdown menu by clicking on the down arrow, remove titles by clicking the check marks of categories you want to exclude, or click the All check mark to remove all check marks, then select the boxes of titles you want to include. If specific job titles are of interest, then use the Job Titles filter.
► Filter to view by one or more Job Titles using the dropdown menu at the top of the page. After selecting the dropdown menu by clicking on the down arrow, remove titles by clicking the check marks of titles you want to exclude, or click on the “All” check mark to remove all check marks, then click the boxes of titles you want to include. If categories of job titles, or occupations, are of interest, then use the Job Category filter.
► Filter to view by Race/Ethnicity using the dropdown menu at the top of the page: click on the down arrow, select All to uncheck all of the boxes, select the Race/Ethnicity(s) of interest, click the Apply button.
► Filter to view headcounts by Longevity using the dropdown menu at the top of the page: click on the down arrow, select All to uncheck all of the boxes, select the Longevity range of interest, click the Apply button. By default, longevity is increased by one year increments. Grouping employees in multi-year blocks (5, 10, or 20 year blocks) may be more meaningful. To change the increment amount, go to the Longevity Increment box next to Longevity and use the slider or > to increase/decrease the increment to 5, 10, or 20 year increments.
► Filter to view the data by Retiree Status using the dropdown menu at the top of the page: click on the down arrow and select All, Retiree, or Non-Retiree.
► Filter to view the data by Salary Range using the dropdown menu at the top of the page: : click on the down arrow, select All to uncheck all of the boxes, select the Salary Range of interest, click the Apply button.
- By default, the graph shows the number of employees in $10,000 salary ranges. Grouping employees in narrower ranges (e.g., $5,000) or wider ranges (e.g., $20,000) may be more meaningful. To change the increment amount, go to the Select Salary Increment box to the right of the Salary Range filter, click on the existing value, type the value desired and hit enter.
- Printing dashboards
► You may want to print dashboards to share with others. The graphs showing on the screen are what is printed. Multiple prints are required if a graph needs to be scrolled to reveal additional sections of the graph.
► Click on the Download button at the bottom or top of the page.
► For a PDF document, select PDF
- For most dashboards select Landscape (you will be able to see the document on-screen before printing and change if desired).
- Under Content, select This Dashboard
- Click on the Download button, a small window will appear, Download PDF, click on Download
- A Microsoft Open/Save window will open, click on the Open with button and click OK
► For an Image of the dashboard, select Image
- A small window will appear, Download Image, click on Download
- A Microsoft Open/Save window will open, click on the Open with button and click OK
- You can print directly from the Windows Photo Viewer or copy it and paste it into a Word document
► Clear all filters and return to default settings by selecting Revert at the bottom or top of the page (you can return an individual filter to its default settings by selecting 
above the filter drop down menu).
n Example 1: What percentage of the university workforce works part-time?
- Move the cursor to the Full-Time/Part-Time column on the far right of the dashboard, mouse over the Part-Time portion of the pie chart (light colored), the pop-up tip reveals 13.72% of employees are part-time (1,876 employees).
- Move the cursor to the upper right hand corner of the page and select the Table button to change the graph visualization to a table. The far right column shows that 13.72% of the university workforce (1,876 employees) works part-time. Select the Graph button to return to the graphical visualization.
n Example 2: How many employees at the university are veterans, work full-time, and are between 40 and 70 years old with salary rates between $20,000 and $70,000?
- Start at the Veteran color key, click Veteran.
- Move the mouse to the Part-Time/Full-Time color key, click Full-Time.
- Move the cursor to the Salary Increment filter at the top right of the page, click on the existing value, enter 20000, hit enter.
- Move the cursor left to the Salary Range filter, click the down arrow, click All to remove all of the checks, click $20,000, $40,000, and $60,000, click Apply.
- Move the cursor to the upper left of the page to the Age Increment filter, use the slider or > to increase the increment to 20.
- Move the cursor left to the Age Range filter, click the down arrow, click All to remove all of the checks, click 40 and 60, click Apply.
- In the Current Headcounts column (left side of the dashboard), it shows 278 employees meet these criteria.
- To view the results in tabular form, click on the Table button in the upper right corner of the page. Click on the column heading Veteran, read in the Full-Time column that there are 278 full-time veterans at the university between 40 and 70 years old with salary rates between $20,000 and $70,000.
- Print the dashboard if desired.
- Click on the Revert button at the bottom or top of the page to undo the filters.
n Example 3: What proportion of your workforce in a specific department is male with a post high school education and works part-time?
- Start by clicking on
in the upper right corner of the page. - Go to the Education filter in the upper right of the page, click on the down arrow, click on unknown, < HS, and High School to uncheck them. Click on Apply.
- Identify the department of interest in the Gender column. (You may have to scroll down to find it.)
- Click on the Male portion of the pie chart. Mouse over the Part-Time portion of the Full-Time/Part-Time pie chart in the last column to see what proportion of males are part-time.
- To display the information in tabular form, click on the Table button in the upper right corner of the page.
- Identify the department of interest in the Gender column. (You may have to scroll down to find it.)
- Click on the Male count or percentage. Read what proportion of males are part-time from the Part-Time portion of the Full-Time/Part-Time table in the last column.
- Print the dashboard if desired.
- Click on the Revert button at the bottom or top of the page to undo the filters.
For questions or comments, contact:
Karen Blanchette: karenblanchette@austin.utexas.edu (512.475.8055)
John Moore: john.moore@austin.utexas.edu (512.475.8062)