Multi-Objective Project Prioritization Program Implementation

Posted on by tamdataguide_kk5syh

Multi-Objective Project Prioritization Program Implementation

The Ohio DOT developed a Transportation Asset Management Decision Support Tool to provide a mechanism for ODOT managers to make decisions on adequate information for optimizing the performance and cost-effectiveness of infrastructure assets.

This tool supports investment decisions and demonstrates the return on those investments both quantitatively and qualitatively.

The tool was developed and implemented through the following approach:

Area: Act Informed by Data
Subarea: Project Planning, Scoping, and Design (E.2)
Element: Data-Driven Project Planning and Scoping (E.2.a)

Step 1: User Needs and Use Case Documentation

User needs and use cases for the proposed decision support tool were developed by a cross-functional team. Recommendations were provided through 1) a series of workshops with individual business and data subject matter experts, 2) engagement of executive management to establish decision-making values and priorities, and 3) review of tools of peer agencies.

Step 2: Develop Data Sources

Enterprise data needs were identified, and associated reference and master data sets were developed from source systems.

Step 3: Configure Off-the-Shelf Business Intelligence Tools

Requirements for a configurable, off-the-shelf solution were developed to ensure long-term sustainability. A custom solution was identified as a risk.

Step 4: User Engagement and Training

Staff were allowed dedicated time away from routine business responsibilities. An agile approach was used for delivery.

Step 5: Data Quality Improvement

Integrating data and formalizing metrics exposed data quality issues. Resources and responsibilities for quality were assigned.

Value Delivered

Centralized portal for data access

Leadership

Executive endorsement and vision from onset

Expertise

Business Engagement, Data Architecture & Management, BI Software & Dashboards

Coordination

Cross-functional teams & training; Central office, field, and support staff

Change

Impacts to Roles and Responsibilities, Accountability for data-informed decisions, Data Issues Exposed

Ohio TAM Decision Support Tool Content Examples

A landing page allows efficient access to data and reports, with options to filter, review maps, and generate reports.

Filtering tools provide the ability to narrow the reported data by location as well as asset characteristics.

Condition maps provide network level screening based on color coded features, and to allow access to detailed asset information through an “Asset Inspector” tool.

Standard reporting is provided across a range of information areas, including inventory, condition, performance, investment, maintenance, and planning.

A report showing forecasted pavement conditions.

A report showing total expenditure by selected assets