Enterprise Data Warehouse Implementation Guide

As part of a robust data governance strategy, agencies must decide how to best manage storage, access, and dissemination of data products and services for internal use/reuse and external distribution within its data architecture. An important piece of a modern data architecture is an enterprise data warehouse, which, conceptually, will provide a way to reduce data redundancy, improve data consistency, and enable data usage for better decisions. Effective implementation of a data warehouse is complex, especially when an entity has highly diverse data sets and technology infrastructure. Thus, departments of transportation (DOTs) will benefit greatly from guidance on how to best architect and implement an enterprise data warehouse strategy that will meet diverse business needs while remaining performant. However, the industry lacks a guidebook on how to develop and implement a comprehensive data warehouse for DOTs. This research is intended to develop a guide on data warehouse implementation to support efficient use, sharing, and reporting of data and address transportation agency business needs. The deployable product from this research is a best practice guide for state DOTs to use in guiding the development and implementation of an enterprise data warehousing strategy that encompasses data in structured (tabular), semi- or un-structured (non-tabular), and geospatial file formats (includes geometry). Benefits of data warehousing include routine decision-making by improving data quality and increasing accessibility and security through using inventory best practices and improving organizational productivity through improved interoperability of data and automation of common analysis and reporting activities. Additional value is realized through time and cost savings to agencies by providing guidance on enterprise data warehouse strategies that can be quickly applied to improve the current state of data, rather than duplicating efforts with multiple or unknown outcomes. Moreover, collaboration and sharing of data across business units and agencies will be timelier and more efficient by adopting common standards.


  • English


  • Status: Proposed
  • Funding: $350000
  • Contract Numbers:

    Project 23-29

  • Sponsor Organizations:

    National Cooperative Highway Research Program

    Transportation Research Board
    500 Fifth Street, NW
    Washington, DC  United States  20001

    American Association of State Highway and Transportation Officials (AASHTO)

    444 North Capitol Street, NW
    Washington, DC  United States  20001

    Federal Highway Administration

    1200 New Jersey Avenue, SE
    Washington, DC  United States  20590
  • Project Managers:

    Barcena, Roberto

  • Start Date: 20220607
  • Expected Completion Date: 0
  • Actual Completion Date: 0

Subject/Index Terms

Filing Info

  • Accession Number: 01847466
  • Record Type: Research project
  • Source Agency: Transportation Research Board
  • Contract Numbers: Project 23-29
  • Files: TRB, RIP
  • Created Date: May 27 2022 12:57PM