Building Trust with Improved UDOT Commission and Project Delivery Dashboards

Item #: 20260011

CONTACTS

Implementing Organization: Project Development
Implementation Lead: Marcelo Manzo
Development Team:
- Marcelo Manzo - Data Scientist (Lead)
- Natalie Knudson - Data Analytics Project Manager
- Carmen Swanwick - Director of Project Development
- Paul Egbert - Region 1 Program Manager
- Kendall Draney - Region 2 Program Manager
- Andrew Gwynn - Region 3 Program Manager
- Cameron Gay - Region 4 Program Manager
Article Written By: Marcelo Manzo
Innovation Team Coordinator: Winston Inoway

STATUS

Implementation Date: August 15, 2025
Adoption Status: Fully Implemented
Adoptability Note: What information could you share with your stakeholders that would improve trust and transparency?

APPLIES TO

Topic: Data Collection, Analysis and Visualization
Organization(s): UDOT (all)
Job Role(s): Administrative Staff / Commissions, Business Analyst, Construction Engineer, Executive Leadership, Finance / Accounting, Program Manager
Tags: Active transportation, air transportation, highway transportation, public transit, railroad transportation, water transportation, capital productivity, labor productivity, materials, supplies, use charges, employee empowerment, personnel development, political factors, economic benefits, value of time, ( simplification ), accounting > billing, budgeting, payment, ( comptroller ), communications > public relations ( PR ), contract administration > bids, contracting, solicitations, contracts, ( RFP, FRQ ), finance > appraisals, investments, asset management, cost recovery, cost sharing, fees, loans, revenues, sales, taxes, usage charges, governance > auditing, policy making, procedures, compliance, law, ( legal ), information technology >> software, networks, leadership, logistics > inventory, distribution, purchasing, procurement, warehousing, supply chain management, marketing > advertising, ( data visualization ), construction, contracting, planning, program management, project management, public opinion, user benefits, value capture

PROBLEM

The previous Project Development dashboard, based on Masterworks data, was compromised in data accuracy and transparency. Information such as number of projects, total contracts and change orders amounts were unreliable and not user-friendly.

CHANGE

In July 2024, key business questions were identified which helped define data needs: project delivery timelines, performance tracking, and transparency. Scripts were written to leverage Google Big Query and Masterworks/ePM data with a daily automated schedule. This effort culminated in the development of two Looker Studio Dashboards: UDOT Commission Delivery and UDOT Program and Commission Delivery dashboards.

RESULT

The two dashboards have become essential tools for demonstrating progress to UDOT leadership and the Utah Transportation Commission in delivering projects on time and within budget. This accessible and accurate infomation resource enhance internal and external communication of market trends, supports discussions about recurring statewide challenges, and enables tracking of individual project managers’ performance and progress. More importantly, the dashboards promote greater data accuracy and transparency, helping build public trust and accountability in our program delivery.

LINKS

IMPACT

BETTER MOBILITY

Easier to track project progress
Better management of projects and needs

GOOD HEALTH

CONNECTED COMMUNITIES

Builds trust through transparency and accuracy

STRONG ECONOMY

Improved tracking accuracy
Increased accountability

EFFICIENCIES*

Estimated Cost Savings in the First Year (FY YYYY): $NN,NNN [or Anticipated break-even by MMM, YYYY (N years, N months)]
Cost Avoidance: $N,NNN over NN years (MMM D, YYYY - MMM D, YYYY)*
Labor Avoidance: NNN hours annually*
Benefit/Cost Ratio: BB:1

*Benefits are estimated net of initial and ongoing expenses. Savings are averaged over the expected benefit life of the innovation. See details.

Page updated

Report abuse