Institute for Transportation

About the research

State departments of transportation (DOTs) and other transportation organizations have a wealth of data. This data is stored in multiple environments and formats and is accessible by various methods. Some of these environments easily integrate, while others require complex programming. At times, the cost of this integration outweighs the potential benefit.

This research developed a guide for enterprise data warehouse (EDW) development and best practices to support DOT business needs. While many warehousing technologies can be chosen and implemented, from SAS to Snowflake, for example, many of these can meet the basic needs of a DOT. What gets overlooked when deploying an enterprise data environment is not directly related to the technology. This research not only looked at technology and traditional data governance practices but addressed how best practices in services/APIs, software ecosystems, security of data and systems, and the culture of an organization complement a thriving data ecosystem.