Why create a "diversity dashboard"?
The Commonwealth of Massachusetts is committed to creating and sustaining a work culture that is welcoming, inclusive, and mutually respectful to all its employees regardless of race, color, age, creed, religion, national origin, ethnicity, sex, gender identity or expression, sexual orientation, genetic information, veteran or disability status. We strive to reflect diversity in all facets and levels of government.
The dashboard will allow the public to better understand the employee demographics that make up our various secretariats, agencies, and departments. We are proud of the strides we are making toward our workforce benchmarks -- women (48%), minorities (20.7%), persons with disabilities (12%), and veterans (7%) -- and toward becoming an employer of choice.
What does this dashboard include?
The data in this dashboard describes the workforce of Executive Branch departments. It does not include data for the Judiciary, Legislature, or the State and Community College Systems.
The dashboard includes five charts:
- The line graph at the top left represents the number of full-time equivalent (FTE) state employees in each of the most recent 12 fiscal quarters.
- The box on the top right shows the number of FTE state employees as a numeric figure.
- The map of Massachusetts on the bottom left displays the number of FTE state employees by county.
- The bar graph on the middle right displays percentages of FTE state employees by race, further broken out by male and female employees within each race category. The race categories represented are American Indian/Alaska Native, Asian, Black/African American, Hispanic, Native Hawaiian/Other Pacific Islander, White, and Not Disclosed.
- The bar graph on the bottom right displays percentages of male and female FTE state employees.
Above the charts is a set of five dropdown menus that allow you to filter the data by different characteristics. The first menu allows you to filter by particular cabinet secretariats, including also the Governor's Office and independent state agencies. The second menu allows you to filter by Executive Branch department, the third by EEO-4 job category, the fourth by full-time or part-time status and the fifth by fiscal quarter.
Data will be updated in April, July, October, and January, after the close of each fiscal quarter.
The data is available for download in the Additional Resources section following the dashboard.
For more information about the terms in this section and the dashboard, please see the Glossary section further down the page.
How to use this tool
This dashboard provides data about workforce diversity in Massachusetts state government.
- You can filter the data by secretariat, department, EEO-4 job category, full-time or part-time status, and fiscal quarter by selecting from the dropdown menus at the top. If you select a secretariat(s) in the first menu, the department menu will show only the departments in that secretariat(s).
- To use the filters, click on the arrow to display dropdown options, then check or uncheck boxes to filter the data. Click Apply at the bottom of the list to register your selection(s) before moving to the next filter. You may choose more than one secretariat, department, or job category, in which case the values you see in the dashboard will be summed across your selections, but you may only select one fiscal quarter at a time. There is no Apply button on the fiscal quarter filter; the dashboard will register your selection.
- The section below provides tips to assist Adaptive Technology (AT) users navigate the dashboard.
- For best performance, use Firefox, Safari, or Chrome.
For assistive technology users
This dashboard was created using Tableau, which is software for visualizing data. In our internal testing, we found that Tableau dashboards are not fully compatible with screen readers, particularly Voiceover. You may wish to navigate this dashboard with a different screen reader if you are primarily a Voiceover user. The instructions below are based on our testing with JAWS 2020 with Chrome 86 and Edge 86.
Please refer to the 'What does this dashboard include?' section above for more detail about how the dashboard is put together and what it contains. When using a keyboard to navigate the dashboard, you will navigate the filters first—secretariat name, department name, EEO-4 job category, full-time / part-time, and fiscal quarter—and then the charts from top left to bottom right. Each chart contains a title and some descriptive text that will give you information about the data based on your filter selections. You can also download the unfiltered raw data in tabular format from the Additional Resources section immediately following the dashboard.
Some keyboard commands you are accustomed to using with your screen reader may not work or may produce different results when used with Tableau. For best results:
- The dashboard may be announced as a figure or an iframe. See instructions below for accessing the frame. Once in the frame, press Tab to go to the first filter, Secretariat Name. From here, you will need to start using Tableau-specific keystrokes to navigate elements. Use Tab to move the focus to the next navigation component and Shift + Tab to move backwards to the previous navigation component. The end of the dashboard may not be clearly announced, but it can be identified by reaching the toolbar containing the Tableau Public button. At the end of the dashboard, use Tab to exit.
- To select items in a filter, push Enter to open the filter and hear all of the filter options. Navigate through the menu options using the up and down arrow keys. You may need to push Enter twice to open the filter depending on your screen reader.
- To make a filter selection, navigate to All and press the space bar to deselect All, then navigate to your chosen option(s) and press the space bar to select that option(s). You can also press the space bar to clear individual options. Once you have selected your options, push Tab to navigate to the Apply button and push Enter to select Apply. To choose a past fiscal quarter, navigate to the fiscal quarter and press the space bar; there is no All option to de-select or Apply button on the fiscal quarter filter.
- Once you have selected Apply (or a fiscal quarter), press Esc to exit the filter and Tab to move to the next filter. You may need to press Esc twice to exit the filter depending on your screen reader. Selecting either Apply on one of the first four filters or a fiscal quarter in the fifth refreshes the dashboard view, so it is best to wait a few seconds before pushing Esc to ensure the refresh has completed.
For more information, please refer to Tableau's list of keyboard commands for navigating the dashboard without a mouse.
You can access the dashboard frame from the main page or through the JAWS feature, Frames List. If you use Frames List, you can access the dashboard from anywhere on the main page. You don't need to go through other page elements to reach the dashboard.
To access the dashboard from the main page: After the skip link, "Skip the dashboard graphic presentation and go to the Additional Resources section where you can download the data in table form from the link provided.", JAWS announces "figure".
To access the dashboard from the JAWS feature, Frames List:
- Use Insert + F9 to bring up a list of frames that are present within the page.
- In the Frames List, the Diversity Dashboard is listed as the data visualization.
- Since that's the only frame in the page, it's already selected. Hit Enter to get into the frame.
- Hit Tab to go to the first filter, Secretariat Name. This is where to start using the Tableau-specific instructions presented above to navigate elements (Tab, Shift + Tab).
The next section contains the dashboard.
Executive Branch Employee Diversity Dashboard
Glossary of terms used in this dashboard
What is full-time equivalent (FTE), and how is it measured?
Full-time equivalent (FTE) counts employees by the number of hours they work weekly rather than by headcount. You can calculate an employee's FTE by dividing the employee’s scheduled hours by the total number of hours the employer considers a full-time work week. For example, if the employer considers a full-time work week to be 40 hours, and the employee works part-time for 20 hours weekly, then the FTE count for that employee is 0.5. If the employer considers a full-time work week to be 40 hours, and the employee works full-time for 40 hours per week, then the FTE count is 1.
What is a “secretariat”? What is the difference between secretariats and departments?
Secretariats are sections of the Executive Branch of Massachusetts state government. There are 9 secretariats, each of which is headed by a secretary who reports directly to the Governor. This dashboard also includes some independent agencies, the heads of which do not report to the Governor (e.g. Office of the Comptroller), under the secretariat filter.
Departments are organizations in state government established by the Legislature to focus on specific missions. Departments usually report to secretariats, as compared with independent agencies. For example, the Department of Public Health is a department within the Health and Human Services secretariat.
What are EEO-4 job categories?
Under Public Law 88-352, Title VII of the Civil Rights Act of 1964, as amended by the Equal Employment Opportunity Act of 1972, all state and local governments that have 15 or more employees are required by regulation to report to the Equal Employment Opportunity Commission. Job codes are used to track positions by salary ranges, pay scales, and other payroll classifications. In Massachusetts state government, these job codes roll up into 8 EEO-4 job categories:
OFFICIALS/ADMINISTRATORS: Occupations in which employees set and execute broad policies; direct departments or special phases of an agency's operations; or provide specialized consultation on a regional, district, or area basis. Sample job titles include: Commissioner, Program Manager, Chief Operating Officer, Chief Fiscal Officer.
PROFESSIONALS: Occupations that require specialized and theoretical knowledge that is usually acquired through college, or through work experience and other training that provides comparable knowledge. Sample job titles include: Social Worker (A/B), Social Worker (C), Registered Nurse, Human Services Coordinator (C), Sr. Programmer/Analyst Pdpp, Civil Engineer, Compliance Officer III, Counsel II, Tax Examiner, Job Service Representative, General Construction Inspector I, and Support Enforce Spec (C).
TECHNICIANS: Occupations that require a combination of basic scientific or technical knowledge and manual skill, the training for which employees obtain through specialized post-secondary school education or equivalent on-the-job training. Sample job titles include: Licensed Practical Nurse II, Benefits Eligibility & Refer Social Worker (C), Computer Operator, Records Analyst I, Elevator Operator, Case Reviewer (A/B), and EDP Operations Coordinator.
PROTECTIVE SERVICE WORKERS (Sworn): Occupations in which workers are entrusted with public safety, security, and protection from destructive forces Includes: Police patrol officers, firefighters, guards, deputy sheriffs, bailiffs, correctional officers, detectives, marshals, harbor patrol officers, game and fish wardens, park rangers (except maintenance), and kindred workers. Sample Job titles include: Correction Officer I, II, III, Campus Police Officer I, State Trooper, 1st Class, Environmental Police Officer (A/B), Captain DOC, State Police Sergeant and State Police Dispatcher.
PROTECTIVE SERVICE WORKERS (Non-Sworn): Occupations in which workers are entrusted with public safety, security, and protection from destructive forces. Sample job titles include: Developmentally Disabled Worker I, II, II, Mental Health Worker I, II, III, IV, Youth Services Group Worker I, and Nursing Assistant I, II.
OFFICE and CLERICAL WORKERS: Occupations in which workers are responsible for communications and recording and retrieving data and/or information required in an office. Sample job titles include: Clerk III, IV, Paralegal Specialist, Administrative Secretary II, Receiving Teller I, Word Processing Operator I, EDP Control Clerk I, and Communications Dispatcher.
SKILLED CRAFT WORKERS: Occupations in which workers perform jobs that require special manual skill and a thorough knowledge of the processes involved in their work. They are trained through on-the-job experience, formal training programs, and/or apprenticeships. Sample job titles include: Maintenance Equipment Operator I, Steam Fireman, Trades Worker, 3rd Class, Power Plant Engineer, Cook II, and Motor Equipment Mechanic III.
SERVICE MAINTENANCE WORKERS: Occupations in which workers’ duties include contributing to the upkeep and care of buildings, facilities, or the grounds of public property to improve comfort, convenience, hygiene, or public safety. Workers in this group may operate machinery. Sample job titles include: Motor Truck Driver, Laborer II, and Launderer I.
- "Full time" is the equivalent of FTE equal to 1 based on the definition given above.
- "Part time" is the equivalent of someone working less than the standard work week, or FTE less than 1 based on the definition given above.
- This filter is helpful for searches of agencies that may have multiple board member positions which work less than a standard number of hours per week, perhaps only meeting once or twice out of a month or quarter.
What is a fiscal year?
A fiscal year is a year-long period that an organization uses for reporting on its budget and finances. The Commonwealth’s fiscal year begins July 1 and ends June 30.
How do you define a fiscal quarter?
A fiscal quarter is a 3-month time frame. The Commonwealth’s fiscal quarters are:
- Quarter 1: July 1 to Sept. 30
- Quarter 2: Oct. 1 to Dec. 31
- Quarter 3: Jan. 1 to March 31
- Quarter 4: April 1 to June 30
When is the data updated?
The Commonwealth will update the dashboard with new quarterly data by the 10th day of the month following the end of a fiscal quarter. Please note that the data shown in a given quarterly release of the dashboard may not precisely match data from previous releases due to updates to historical data that may occur between releases. Please refer to the current release for the most accurate and up-to-date data.
Please contact the Office of Diversity and Equal Opportunity with any questions related to this webpage.