Civil Rights

Report pages

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

• Active Project Summary: Displays current data on active projects.
• Active Project Trends: Displays trend data on active projects over a three-month period.
• Closed Project Summary: Displays data on projects recently closed by the MnDOT Office of Civil Rights.

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.

• Commitment: a contractor’s committed percentage of hours for women and people of color working on a project (projects valued at less than $5 million will not have a commitment)
• Contract amount: contract value of a project in millions of dollars
• Date closed: date the MnDOT Office of Civil Rights concluded project monitoring
• District: MnDOT-assigned region
• Est. start date and est. end date: dates estimated to be the beginning and end of a project
• Goal: workforce goal set by the Minnesota Department of Human Rights (MDHR) that is expressed as percentages of total hours worked by women and people of color working on a project
• People of color (PoC): a person who does not identify as white
• People of color hours: number of total hours people of color worked on a project as of the given date
• People of color percent (%): percentage of total hours people of color worked on a project
• Percent (%) complete: percentage of total project amount paid to contractors
• Prime contractor: name of the contractor awarded the project and whose performance toward the applicable workforce participation goals is measured by the Results and Transparency Workforce Report
• Project description: brief description of a project area
• Project recency: when the project was added to the report
• New: a project added in the current month
• Reoccurring: a project added in a previous month
• SP number: MnDOT-assigned state project number
• MnDOT project number format: XXXX-XX or XXXX-XXX
• State Aid project number format: XXX-XXX-XXX
• Total hours: total number of hours worked on a project as of the given date
• White: a person who identifies as having origins in any of the original peoples of Europe, the Middle East, or North Africa (and does not identify as Hispanic or Latino)
• Women hours: number of total hours women worked on a project as of the given date
• Women percent (%): percentage of total hours women worked on a project

Report data comes from contractor payroll information and is updated monthly.