Civil Rights

Report pages

Use the buttons at the top right to navigate to the three report pages.

• Overview: Displays DBE, workforce, and OJT project summary data and progress toward reaching goals.
• DBE: Displays current DBE payments and progress toward reaching the DBE commitments.
• Workforce & OJT: Displays current workforce participation data for women, people of color, and by race/ethnicity. Displays OJT trainee and hours data.

Filters

Use the filters on the left to sort the data on the report page.

To select multiple options in a single filter, hold the Ctrl key down and select the desired options.

To clear a filter, select the filter option again or select the eraser icon on the filter. To clear all filters at once, select the “Reset filters” button.

Data table

The data table at the bottom of each report page can be further filtered in ascending or descending order by selecting the column headers.

Viewing tools

• Full screen mode: Full screen mode expands the report to fill the entire screen.
• To open the report in full screen mode, select the full screen icon (i.e., the two-way diagonal arrow) at the bottom right of the report.
• To exit full screen mode, click the X or press Esc.
• Tooltips: Tooltip messages provide additional information when the cursor hovers over a graph.
• To view tooltip messages, hover your cursor over various parts of a graph.
• Focus mode: Focus mode enlarges the section to a full screen view.
• To open focus mode, hover your cursor over or click on a report visual and select the focus mode icon (i.e., the box with an arrow pointing up and to the right).
• To exit focus mode, click the “Back to Report” button or press Esc.
• Show as table: Show as a table expands and converts the report visual into a data table.
• To open show as a table, right click on the visual and select “Show as a table.”
• To exit show as a table, click the “Back to Report” button or press Esc.

If you use assistive technology such as a screen reader or rely on keyboard-only access, use the following guidance and shortcuts to improve report interaction:

• Enter report: To enter and interact with the report, tab to the report and press:
• Windows: Ctrl + Enter
• Mac: Command + Return
• Keyboard shortcuts list: For a list of available keyboard shortcuts, enter the report and press:
• ? (Shift + /)
• Page navigation: To move between report pages, press:
• Windows: Ctrl + F6
• Mac: Command + F6
• Section navigation:
• Use tab or arrow keys to move between sections on a report page.
• Press Enter to enter a section.
• Press Enter or Space bar to select and unselect a data point, then use tab or arrow keys to move between data points.
• Press Esc to exit the section.
• Focus mode: Focus mode enlarges the section to a full screen view. To enter focus mode, tab to the section and press:
• Windows: Alt + Shift + F10 then tab to focus mode and press Enter
• Mac: Option + Shift + F10 then tab to focus mode and press Enter
• Show as a table: The show as a table feature makes a report section screen reader friendly. To show as a table, tab to the section and press:
• Windows: Alt + Shift + F11
• Mac: Option + Shift + F11
• Focus mode and show as a table navigation:
• Use tab or arrow keys to move between the sections in focus mode and table sections.
• Press Enter or Space bar to interact with the data points, then use tab or arrow keys to move between data points.
• Press Esc to stop interacting with elements.

For more information, visit Consume Power BI reports using accessibility features

• Select project: MnDOT-assigned state project number with XXXX-XX or XXXX-XXX format
• Prime contractor: contractor awarded the project
• MnDOT district: MnDOT-assigned region
• Percent (%) complete: percentage of total project amount paid to contractors
• DBE: Disadvantaged Business Enterprise
• DBE %: current percentage of subcontracted dollars paid to DBE firms
• DBE commitment %: prime contractor’s committed percentage of subcontracted dollars to DBE firms
• DBE goal: DBE goal set by MnDOT Office of Civil Rights that is expressed as a percentage of total subcontract dollars to certified firms
• Prime contract awarded: total value of contract awarded to prime contractor
• DBE commitment $: prime contractor’s committed subcontract dollars to DBE firms
• Amount paid to prime: current total payments made to the prime contractor
• DBE dollars: current total payments made to DBE firms
• Percent paid to DBE: current percentage based of total paid to firm divided by the total commitment amount
• People of color (PoC): a person who does not identify as white
• Women %: percentage of total hours Women worked on the project
• Women goal: workforce goal set by the Minnesota Department of Human Rights (MDHR) that is expressed as percentages of total hours worked by women working on the project
• Women hours: number of total hours women worked on the project as of the given date
• Women commitment: prime contractor’s committed percentage of hours for women working on the project
• People of color %: percentage of total hours people of color worked on the project
• People of color hours: number of total hours people of color worked on a project as of the given date
• People of color goal: workforce goal set by the Minnesota Department of Human Rights (MDHR) that is expressed as percentages of total hours worked by people of color working on the project
• People of color commitment: prime contractor’s committed percentage of hours for People of Color working on the project
• Total project hours: total number of hours worked on a project as of the given date
• Race/ethnicity: employee self-identification based on an Affirmative Action survey
• On-the-job training (OJT): a federal program designed to help people of color, women, and disadvantaged persons move from apprentice to journey-level status administered by MnDOT’s Office of Civil Rights
• OJT hours: number of hours worked by people of color, women, or otherwise disadvantaged persons approved for and participating in MnDOT’s on-the-job training program
• OJT hours goal: project-specific goal for the total number of hours worked by OJT trainees set by MnDOT’s Office of Civil Rights
• OJT trainees: People of color, women, or otherwise disadvantaged persons approved for and participating in MnDOT’s on-the-job training program
• OJT trainee goal: project-specific goal for the total number of OJT trainees set by MnDOT’s Office of Civil Rights

Report data comes from AASHTOWare CRL contractor payroll and subcontractor payment information and is updated monthly