Versions Compared

Key

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

...

►       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).

  • Example 1: How many employees in your college, school, or VP portfolio (C/S/VP) are Hispanic, and what is their average age, average longevity, and median salary? What are these values for male Hispanics only?

►       In the Race/Ethnicity graph, mouse over the C/S/VP Hispanic bar to identify the number of Hispanics and their percentage of C/S/VP employees.

►       Click the Hispanic bar to select it. Under the Headcount by Age graph, read the average age; under the Headcount by Longevity graph, read the average longevity; under the Headcount by Salary graph, read the median salary.

►       Go to the Gender filter at the top left of the page, click on the drop box down arrow, and click on male. Mouse over the highlighted C/S/VP Hispanic bar to identify the number of male Hispanics and their percentage of C/S/VP employees.

►       Read the age, longevity, and salary values under the respective graphs.

►       Select the Table button in the upper right corner of the page to display tabular values. Note the Gender filter remains on. To view only Hispanic males in your C/S/VP, select the C/S/VP Hispanic value/cell.

►       Print the dashboard if desired.

►       Click the Revert button on the top or bottom of the page to undo the filters.

  • Example 2: In your C/S/VP, how many benefits eligible females with a Bachelor’s degree earn between $45,000 and $75,000? What is their average age and average longevity?

►       Start with the Benefits Eligibility filter in the upper left corner. Click on the down arrow and select Benefits Eligible.

►       Move down to the Gender filter, click on the down arrow and select Female.

...





►       Move to the Educational Attainment graph. Click on the BA/BS bar for your C/S/VP panel.

►       Move to the Salary Range graph in the lower right, mouse over the columns for $45,000, $50,000, $55,000. $60,000, $65,000, and $70,000, note the number of employees for each column and sum them.

►       The average age and average longevity are displayed below the Headcount by Age and Longevity in Years graphs.

►       To use the Table view to answer this question, as above, go through the filtering for benefits eligibility and gender, adjust the salary range settings, then go to the upper right of the dashboard and select the Table button. The graphs will turn into tables.

  • Move to the Educational Attainment table. Click on the number of employees count or percentage in the BA/BS column for your C/S/VP panel.
  • Move back to the Salary Range table in the lower right, sum the number of employees in the columns from $45,000 to $70,000.

►       Print the dashboard if desired.

►       Click the Revert button on the top or bottom of the page to undo the filters.

  • Example 3: You have departments within your C/S/VP, and you want to know how many full-time employees have bachelor’s degrees in a particular department.

►       Start with the Educational Attainment graph, click on Image Removedto display the departments in your C/S/VP and their educational attainment.

►       Go to the Full-Time/Part-Time filter at the top of the page, right side, click on the down arrow, select Full-Time.

►       For the department you are interested in, mouse over the column for BA/BS, or click on the Table button in the upper right corner of the page to display counts and percentages.

►       Print the page if desired.

►       To return to the C/S/VP level, click Image Removedon the in the upper right corner of the page.

►       Click on the Revert button at the bottom or top of the page to undo the Full-Time filter.

For questions or comments, contact:

...