Specifications include, but are not limited to: The objective of this research is to develop a guide for enterprise data warehouse development, implementation, and best practices to support DOT business needs. DOT business needs include, but are not limited to, efficient upload, use, sharing, security of data, data analytics, operations management, performance management, asset management, safety management, data-driven decision-making, data integration, and federal and state data reporting. The accomplishment of the project objective will require, at the minimum, the following tasks: TASKS Task descriptions are intended to provide a framework for conducting the research. The NCHRP is seeking the insights of proposers on how best to achieve the research objective. Proposers are expected to describe research plans that can realistically be accomplished within the constraints of available funds and contract time. Proposals must present the proposers' current thinking in sufficient detail to demonstrate their understanding of the issues and the soundness of their approach to meeting the research objective. PHASE I—Planning Task 1. Conduct a critical literature review of research related to enterprise data for transportation and other multidiscipline agencies. The review shall include published and unpublished research conducted through national, international, pooled-fund-sponsored research as well as relevant literature generated within the public sector. Task 2. Evaluate and synthesize Task 1 to identify the knowledge gaps for effective transportation enterprise data warehouse implementation. These gaps should be addressed in this research, as budget permits, or included in the recommendations for future research. Present the results and findings in Technical Memorandum 1. Task 3. Propose a methodology to accomplish the research objective to be fully developed in Phase II of this project. At a minimum, the work plan and methodology shall consider: · Targeted surveys or interviews with DOT chief data officers or equivalent, as well as business domain experts to learn about analytical and reporting requirements, the status of practice, and current challenges; · Strategies to assess current enterprise data warehouse capabilities and opportunities in transportation; · Identification of essential data warehouse capabilities including, but not limited to, input, access, cybersecurity/permission management, privacy, data quality, change management, and data retention; · Data management approaches and technology needed to enable the development and implementation of effective enterprise data warehouses; · Required documentation to develop and maintain an enterprise data warehouse (e.g., glossary of terms, operating procedures) keeping in mind the diverse operational contexts in different DOTs; · Foundational success factors for enterprise data warehouse implementation and adoption; · Coordination needs with partner agencies and third-party data (i.e., rail, utilities, data subscription); · Enterprise data warehouse governance; · Transportation-specific challenges including temporal, geospatial, linear referencing systems (LRS), and building information modeling (BIM) data sets; and · Strategies that encompass data in structured (tabular), semi-structured, or unstructured (non-tabular) geospatial file formats (includes geometry); the incorporation of existing and new data sets into enterprise data warehousing; and the corresponding required technology. The development of the elements above shall be framed from these perspectives: · Daily data-based decision-making within transportation agencies; · Organizational productivity through improved interoperability of data and automation of common analysis and reporting activities; · Cost-effective strategies that can be quickly applied to the current state of data, avoiding duplicating efforts with multiple or unknown outcomes; · Data sharing efficiencies across transportation business units and agencies; · Building and maintaining historic records of agency data that are separate from operational data stores that are highly dynamic; and · Development of data-based performance metrics. Task 4. Propose a preliminary outline for the guide based on the proposed methodology. Task 5. Prepare Interim Report No. 1 that documents Tasks 1 through 4 and provides an updated work plan for the remainder of the research no later than 4 months after the contract has been awarded. The updated plan must describe the process and rationale for the work proposed for Phases II and III. Note: Following a 1-month review of Interim Report No. 1 by the NCHRP, the research team will be required to meet virtually with the NCHRP project panel to discuss the interim report. Work on Phases II and III of the project will not begin until authorized by the NCHRP. Phase I shall be limited to $50,000. PHASE II—Work Plan Implementation Task 6. Execute the work plan and methodology approved Interim Report No. 1. Task 7. Prepare Interim Report No. 2 that documents Task 6 and provides an updated work plan for the remainder of the research. Interim Report No. 2 must include a draft guide and a table of contents for a webinar based on the guide to disseminate the project’s results to DOT practitioners and other transportation agencies. Notes: The research team shall plan to have one virtual meeting with the panel when approximately 50% of Phase II has been completed. Other virtual meetings may be requested based on the progress of the project. Following a 1-month review of Interim Report No. 2 by the NCHRP, the research team will meet with the panel to discuss the interim report. Phase II is expected to be 8 months. Work on Phase III of the project will not begin until authorized by the NCHRP. PHASE III—Final Deliverables Task 8. Revise the draft guide based on the NCHRP review comments. Task 9. Develop materials for the webinar. The materials for the webinar need to be approved by the NCHRP panel before conducting the webinar. Task 10. Prepare the final deliverables including: 1. The guide for enterprise data warehouse development, implementation, and best practices. 2. Present at least two webinars for DOT and other transportation agency practitioners. 3. A stand-alone technical memorandum titled “Implementation of Research Findings and Products” (see Special Note J). 4. A conduct of research that documents the entire research effort and lessons learned, including the recorded webinars, list of participants, questions and answers, feedback, and other records from the webinars.
